Transpose data

[septemberbulb]

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.

[Shmuel]

proc sort data=have; by application_numbar appstatusdate action code; run;

data want;

 set have;

    by application_numbar appstatusdate action;

        length code1 code2 $1;

        retain code1 code2;

        if first.action then do;

           code1=' '; code2=' ';

       end;

       if code='f' then code1=code;

       if code='s' then code2=code;

       if last.action then output;

run; 

[Reeza]

How do you identify a 'group' or know that the two rows go together?

[PGStats]

Please post a machine readable version of your data. Can't do any processing on a picture of your data.

[septemberbulb]

hope to change different code to a new column. thanks

[PGStats · Accepted solution]

Could be as simple as:

proc transpose data=have out=want(drop=_name_) prefix=code;
by APPLICATION_NUMBER APPSTATUSDATE ACTION notsorted;
var CODE;
run;

[septemberbulb]

Thank you very much. It works.