BookmarkSubscribeRSS Feed
twildone
Pyrite | Level 9

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;
1 REPLY 1
Reeza
Super User
Please show what you expect as output.
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 481 views
  • 0 likes
  • 2 in conversation