Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: st: generating number list depending on another variable
From
Joe Canner <[email protected]>
To
"[email protected]" <[email protected]>
Subject
RE: st: generating number list depending on another variable
Date
Wed, 19 Mar 2014 15:05:40 +0000
Patricia,
If Variable1 is a string variable, -encode- should be all you need (no need to egen...):
. encode variable1, gen(variable2)
If Variable1 is a numeric variable with a label, then you may not need to do anything. Do the following to see what the actual values are:
. tab variable1, nolabel
Regards,
Joe Canner
Johns Hopkins University School of Medicine
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Patricia Biedermann
Sent: Wednesday, March 19, 2014 10:59 AM
To: [email protected]
Subject: Re: st: generating number list depending on another variable
Hello,
-decode seems not to work with string variables. So I used encode.
- When I generate variable2 with egen variable2=fill(1(1)100) I get
this result:
Variable 1 Variable 2
AL 1
AL 2
AL 3
BS 4
BS 5
BS 6
BS 7
BS 8
SF 9
SF 10
ZG 11
etc etc.
On Wed, Mar 19, 2014 at 3:52 PM, Richard Goldstein
<[email protected]> wrote:
> then -decode- it is one option
>
> however, if it is already numeric doesn't it already meet what you want?
> if not, what is wrong with it?
>
> Rich
>
> On 3/19/14, 10:49 AM, Patricia Biedermann wrote:
>> Hi Richard,
>> Thanks for your reply. Variable 1 is already encoded....it's a long
>> variable now.
>> Pati
>>
>>
>> On Wed, Mar 19, 2014 at 3:43 PM, Richard Goldstein
>> <[email protected]> wrote:
>>> it looks like variable 1 is a string variable so you want the -encode-
>>> command; when you read the help file, pay attention to the "label" option
>>>
>>> Rich
>>>
>>> On 3/19/14, 10:34 AM, Patricia Biedermann wrote:
>>>> Dear all,
>>>>
>>>> Following problem:
>>>> I have variable1 with different values (AL, BS, SF, ZK...etc.) and
>>>> want to create another variable with a list of numbers reaching from
>>>> e.g. 1-100;
>>>> For each value in variable1 there should be the same number in
>>>> variable2; it should look like that in the end:
>>>>
>>>> Variable 1 Variable 2
>>>> AL 1
>>>> AL 1
>>>> AL 1
>>>> BS 2
>>>> BS 2
>>>> BS 2
>>>> BS 2
>>>> BS 2
>>>> SF 3
>>>> SF 3
>>>> ZG 4
>>>> etc etc.
>>>>
>>>> I tried to use egen variable2=fill(1(1)100) also in combination with
>>>> foreach; somehow generates values from 1-100 independently from
>>>> Variable 1
>>>>
>>>> Thank you!
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/faqs/resources/statalist-faq/
> * http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/faqs/resources/statalist-faq/
* http://www.ats.ucla.edu/stat/stata/