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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.