topic Re: data management creating one row per each id for different variables in SAS Programming

data management creating one row per each id for different variables

lillymaginta — Sun, 01 Oct 2017 21:21:32 GMT

I have the following data;

id date  dx         a b c d e f g
1   1/1/2005 4    1 0 0 0 0 0 0
1   2/2/2005  5    0 0 0 0 0 0  0
1    3/3/2006  3    0 1 0 0 0 0 0 
2    1/2/2005  4    1 0 0 0 0 0 0 
2    2/3/2008   2    0 0 0 0 0 0 0 
2    3/3/2005   3    0 1 0 0 0 0 0
2    3/3/2005   6    0 0 0 0 1 0 0

Here is the output I want

id   a b c d e f g
1    1 1 0 0 0 0 0
2     1 1 0 0 1 0 0

so if the id has any (1) then output 1 for that variable regardless of the date if none then zero.

Re: data management creating one row per each id for different variables

Reeza — Sun, 01 Oct 2017 21:30:02 GMT

Take the max of every column by ID.

You can use SQL, PROC MEANS/SUMMARY/UNIVARIATE.

Re: data management creating one row per each id for different variables

lillymaginta — Sun, 01 Oct 2017 21:39:44 GMT

perfect! I have not thought about this way, thanks Reeza!