Transpose data

twildone — Thu, 04 Mar 2021 23:01:17 GMT

Hi....I have been trying to transpose this data and haven't had any luck. I am trying to transpose it by AcademicYear and Status (such as 2013/4_Domestic as one of the columns). I have been separating the data into two separate datasets by Status and transposing each dataset and then merging the two but I would like to eliminate from having to do this. Thanks.

data Have;
	infile datalines missover;
    input AcademicYear $ Status $ Decision $ Count;
datalines;
2013/14 Domestic No 89
2013/14 Domestic Yes 480
2013/14 International No 34
2013/14 International Yes 333
2014/15 Domestic No 123
2014/15 Domestic Yes 406
2014/15 International No 49
2014/15 International Yes 340
2015/16 Domestic No 110
2015/16 Domestic Yes 371
2015/16 International No 28
2015/16 International Yes 540
2016/17 Domestic No 102
2016/17 Domestic Yes 374
2016/17 International No 70
2016/17 International Yes 584
;
run;

Re: Transpose data

Reeza — Thu, 04 Mar 2021 23:49:30 GMT

Please show what you expect as output.

topic Re: Transpose data in SAS Programming

Transpose data

Re: Transpose data