DATA Step, Macro, Functions and more

data management creating one row per each id for different variables

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 136
Accepted Solution

data management creating one row per each id for different variables

[ Edited ]

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. 

 


Accepted Solutions
Solution
‎10-01-2017 05:38 PM
Super User
Posts: 24,018

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

Posted in reply to lillymaginta

Take the max of every column by ID. 

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

 

 

View solution in original post


All Replies
Solution
‎10-01-2017 05:38 PM
Super User
Posts: 24,018

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

Posted in reply to lillymaginta

Take the max of every column by ID. 

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

 

 

Frequent Contributor
Posts: 136

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

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 221 views
  • 0 likes
  • 2 in conversation