01-17-2017 03:22 PM - edited 01-18-2017 01:14 PM
Hello, I am trying to create table using proc transpose to generate the things below. I dont know how to just convert the CODE to horizen but still fits the application_number and action and also the appstatusdate will change with it. If anyone could help, I will appreciate that. Thanks.
01-17-2017 03:37 PM
proc sort data=have; by application_numbar appstatusdate action code; run;
by application_numbar appstatusdate action;
length code1 code2 $1;
retain code1 code2;
if first.action then do;
code1=' '; code2=' ';
if code='f' then code1=code;
if code='s' then code2=code;
if last.action then output;
Need further help from the community? Please ask a new question.