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.
Take the max of every column by ID.
You can use SQL, PROC MEANS/SUMMARY/UNIVARIATE.
Take the max of every column by ID.
You can use SQL, PROC MEANS/SUMMARY/UNIVARIATE.
perfect! I have not thought about this way, thanks Reeza!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.