Cross tab query

[aj34321]

Hi there.. Need help on the below. Request if someone can help me.

Pleas note: Below decision status - these are not only the decisions made, but it may contain any status from  a list of some 50 decision status - which is not show in this sample below.

I have this dataset:

data have;
infile datalines delimiter=',';
length Appln_key $18 Transit_Decsn $35 desision_seq $16;
input Appln_key $ Transit_Decsn $ desision_seq $;
datalines;
APP121000000000001,APPLICATION_WITHDRAWN_DURING_EDIT,DECISION_CODE_1
APP121000000000001,APPLICATION_WITHDRAWN,DECISION_CODE_2
APP121000000201001,APPLICATION_WITHDRAWN_DURING_EDIT,DECISION_CODE_1
APP121000000201001,APPLICATION_AUTO_DECISION_APPROVED,DECISION_CODE_2
;
run;

And I want to get this output.
data want;
infile datalines delimiter=',';
length Appln_key $18 DECISION_CODE_1 $35 DECISION_CODE_2 $35;
input Appln_key $ DECISION_CODE_1 $ DECISION_CODE_2 $;
datalines;
APP121000000000001,APPLICATION_WITHDRAWN_DURING_EDIT,APPLICATION_WITHDRAWN
APP121000000201001,APPLICATION_WITHDRAWN_DURING_EDIT,APPLICATION_AUTO_DECISION_APPROVED
;
run;

[Reeza · Accepted solution]

Have you tried PROC TRANSPOSE?

That should work here, if not, post the code and we can help tell you where to fix it.

https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-long-to-wide-using-proc-transpose/

---

@aj34321 wrote:

Hi there.. Need help on the below. Request if someone can help me.

I have this dataset:

data have;
infile datalines delimiter=',';
length Appln_key $18 Transit_Decsn $35 desision_seq $16;
input Appln_key $ Transit_Decsn $ desision_seq $;
datalines;
APP121000000000001,APPLICATION_WITHDRAWN_DURING_EDIT,DECISION_CODE_1
APP121000000000001,APPLICATION_WITHDRAWN,DECISION_CODE_2
APP121000000201001,APPLICATION_WITHDRAWN_DURING_EDIT,DECISION_CODE_1
APP121000000201001,APPLICATION_AUTO_DECISION_APPROVED,DECISION_CODE_2
;
run;

And I want to get this output.
data want;
infile datalines delimiter=',';
length Appln_key $18 DECISION_CODE_1 $35 DECISION_CODE_2 $35;
input Appln_key $ DECISION_CODE_1 $ DECISION_CODE_2 $;
datalines;
APP121000000000001,APPLICATION_WITHDRAWN_DURING_EDIT,APPLICATION_WITHDRAWN
APP121000000201001,APPLICATION_WITHDRAWN_DURING_EDIT,APPLICATION_AUTO_DECISION_APPROVED
;
run;

---

[aj34321]

Thanks Reeza.. It worked.. I was doing proc transpose before but guess i was doing something wrong and was not getting the right output. But this time i got it.. 

Many thanks,

Rgds, Anil