 |
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: Re: RE: RE: Identifier from three variables
Your Name: N�dia Simoes
Male or Female plus age: Female 28
Address: rua da industria 74 ; 1300 306 Lisboa
E Mail: [email protected]
Your requirements: kitchen (fridge and microwave); internet would be good
but it isn't a requirement)
Date of arrival and time: 5/08/2007
Which Airport: Heathrow
Length of stay: until 11/08/2007
Is this a Group , Family, Couple or Single reservation? Single
Number of adults: 1
Number of children under 16 years of age:
Number of rooms required: 1
Bed and Breakfast or Self catering: self catering
Do you require parking? no
Other requirements:
How did you hear about London-rooms or London Homestay, which search engine
did you use? google
You inspect the houses right? Or did you had aby problems in the past?
Best wishes,
N�dia
----- Original Message -----
From: "Rafael Osorio" <[email protected]>
To: <[email protected]>
Sent: Monday, July 30, 2007 1:45 PM
Subject: st: RE: RE: Identifier from three variables
Other way of doing it, supposing each identifier is <= 99:
gen id = house*1000+family*100+individual
By doing it this way you can tell to which house and family a specific
person belongs to. If your data was not sorted by the identifiers, if you
sort by this new identifier the result will be equal to sorting it by all
identifiers. If your final id is large: gen double id...
If your identifiers are greater than 99, adjust the multipliers.
Rgds,
Rafael
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Nick Cox
Sent: Friday, July 27, 2007 2:09 PM
To: [email protected]
Subject: st: RE: Identifier from three variables
I'll answer this myself:
1. Don't do that. Use -egen, group()- with the -label- option.
2. See also
FAQ . . . . . . . . . . . . . . . . . . . . . . Creating group
identifiers
3/01 How do I create individual identifiers numbered
from 1 upwards?
http://www.stata.com/support/faqs/data/group.html
3. If you really must, look into -egen, concat()-, including
its options.
Nick
[email protected]
N�dia N. Sim�es
How can I generate an identifier from three variables?
In my data I have a column for the house, one for the family
and one for the individual
example:
house family individual
1 1 1
1 1 2
1 1 3
2 1 1
2 1 2
...
and I would like to know how can I create an identifier per
individual such as:
individual
010101
010102
010103
020101
...
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.10.25/926 - Release Date:
29-07-2007 23:14
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/