topic how to create dummy variable from the variable that has a lot different values in SAS Programming

how to create dummy variable from the variable that has a lot different values

viollete — Wed, 02 May 2018 10:30:30 GMT

Hi,

I have a variable that consists information about diagnosis (6496 different diagnosis). For each diagnosis i want to create a dummy variable and i used this code:

DATA b2;
  set b;
 
  ARRAY dummys {*} 3.  diag1_1 - diag1_6496;
 
  DO i=1 TO 6496;			      
    dummys(i) = 0;
  END;
  dummys( diag1  ) = 1;		
 
RUN;

However, I get this error message:

Array subscript out of range at line 2087 column 1.

Can anyone tel me what is wrong with code?

thank you

Re: how to create dummy variable from the variable that has a lot different values

Kurt_Bremser — Wed, 02 May 2018 10:41:09 GMT

With such errors, you get a listing of all variables and their values in the log. Look for the value of diag1. It might be zero or missing.

Re: how to create dummy variable from the variable that has a lot different values

s_lassen — Wed, 02 May 2018 10:43:11 GMT

Obviously, the value of the DIAG1 variable is not always between 1 and 6496. Is it missing or 0 in some observations? What does the log say about the value of DIAG1 when the error occurs?

Re: how to create dummy variable from the variable that has a lot different values

Kurt_Bremser — Wed, 02 May 2018 10:43:29 GMT

Still better: run a proc freq on diag1 and inspect the result.

Re: how to create dummy variable from the variable that has a lot different values

viollete — Wed, 02 May 2018 10:47:20 GMT

Thanks,

There is no 0 or missing values; however, I found what was wrong with code (my values were letters not numbers) and I made it work

Re: how to create dummy variable from the variable that has a lot different values

RW9 — Wed, 02 May 2018 11:14:45 GMT

I would question why you want to do this. Just take a simple example of having two records:

DIAG

This is two datapoints of information. If you transpose that into your structure, you would have 6496 datapoints of information. This is just a simple example of where your intended data structure is very verbose in terms of storage, but you will also find your coding is far harder as well.

Re: how to create dummy variable from the variable that has a lot different values

Ksharp — Wed, 02 May 2018 13:24:20 GMT

data have;
set sashelp.class;
dummy=1;
run;
proc logistic data=have outdesign=want outdesignonly;
class name/param=glm;
model dummy=name;
run;

proc print data=want(drop=dummy intercept) noobs;run;