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;
