creating dummies (automatically)

[jkf91]

I have data with month variable. For each month, I want to create a dummy variable. Can someone tell me how I can do this automatically?

I think teh following should do the job, but it doesn't. Anyone knows why?

THanks,

C

DATA auto3;

  set auto3;

  ARRAY dummys {*} 8.  month_1 - month_12;

  DO i=1 TO 12;                                   

  dummys(i) = 0;

  END;

  dummys(month) = 1;

RUN;

[art297 · Accepted solution]

You will have to post what auto3 initially looks like and be more specific about what you want to achieve.

The way your code is written, the twelve variables month_1-month_12 would have to already exist.  You may be looking for something like:

DATA auto3;

  set auto3;

  ARRAY month_ {12};

  DO i=1 TO 12;                                  

    month_(i) = ifn(i=month,1,0);

  END;

RUN;

[jkf91]

thnak you! you got it.

[data_null__]

What if you don't know how many levels and/or you have many variables?

[MikeZdeb]

Hi ... maybe you can skip the loop and only change one value per observation (doesn't answer _null_'s question) ...

data auto3;

array month_(12) (12*0);

set auto3;

month_(month) = 1;

output;

month_(month) = 0;

run;

[data_null__]

The answer to my question is PROC TRANSREG or PROC GLMMOD. :smileyplain: