two records to a single record

[znhnm]

I have a column called "score" in my SAS dataset. Each "score" has two records with for c_flag=1 and c_flag=0. When c_flag=1 the "event" column has a value but "nonevent" column is missing. When c_flag=0 the "nonevent" column has a value but "event" column is missing. I want to create another dataset that will list the uniq values of "score" and write the nonmissing event and nonevent values. How do I write this code?

[ErikLund_Jensen · Accepted solution]

Hi @znhnm 

You don't provide any test data, so this is an untested solution, bot I think you could use something like this:

proc sql;
   create table want as select distinct
     score,
     max(event) as event,
     max(nonevent) as nonevent
   from have
   group by score;
quit;