topic Re: Transpose data in SAS Procedures

Transpose data

septemberbulb — Wed, 18 Jan 2017 18:14:46 GMT

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.

Re: Transpose data

Shmuel — Tue, 17 Jan 2017 20:37:17 GMT

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;

Re: Transpose data

Reeza — Tue, 17 Jan 2017 20:39:32 GMT

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

Re: Transpose data

PGStats — Tue, 17 Jan 2017 20:41:02 GMT

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

Re: Transpose data

septemberbulb — Wed, 18 Jan 2017 18:13:50 GMT

hope to change different code to a new column. thanks

Re: Transpose data

PGStats — Tue, 17 Jan 2017 21:25:55 GMT

Could be as simple as:

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

Re: Transpose data

septemberbulb — Wed, 18 Jan 2017 13:56:20 GMT

Thank you very much. It works.