topic Re: Cross tab query in New SAS User

Cross tab query

aj34321 — Thu, 13 Jun 2019 03:35:51 GMT

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;

Re: Cross tab query

Reeza — Thu, 13 Jun 2019 03:34:44 GMT

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;

Re: Cross tab query

aj34321 — Thu, 13 Jun 2019 03:40:14 GMT

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