topic Re: two records to a single record in SAS Programming

two records to a single record

znhnm — Thu, 09 Feb 2023 19:10:38 GMT

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?

Re: two records to a single record

ErikLund_Jensen — Thu, 09 Feb 2023 19:20:46 GMT

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;