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.

SAS Innovate 2025: Call for Content

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!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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