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
Patricia Biedermann <[email protected]>
To
[email protected]
Subject
Re: st: generating number list depending on another variable
Date
Wed, 19 Mar 2014 15:58:36 +0100
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/