Re: st: generating number list depending on another variable

[Patricia Biedermann <pati.stat@gmail.com>]

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
<richgold@ix.netcom.com> 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
>> <richgold@ix.netcom.com> 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/