data management creating one row per each id for different variables

[lillymaginta]

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. 

[Reeza · Accepted solution]

Take the max of every column by ID. 

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

[lillymaginta]

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