BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Aidan
Quartz | Level 8

Hi

 

I want to piviot the below data in excel on export.

Any ideas?

I know how to use proc export etc to do a data cump in excel but how would I pivot the data?

 

 

Col AAgeQtrGenderTypeAmt
E143Quarter 3 FIP2
E145Quarter 3 MIP1
E146Quarter 3 FDC10
E147Quarter 4FIP1
E148Quarter 4MDC1
E153Quarter 3 FIP2
E155Quarter 3 MIP1
E156Quarter 3 FDC10
E157Quarter 4FIP1
E158Quarter 4MDC1

Expected Output

 

 

Sum of Amt QtrGenderType         
  Quarter 3     Quarter 3  TotalQuarter 4   Quarter 4 TotalGrand Total
  F F TotalMM Total FF TotalMM Total  
Col AAgeDCIP IP  IP DC   
E143 22  2     2
 5   111     1
 610 10  10     10
 7      11  11
 8        1111
E153 22  2     2
 5   111     1
 610 10  10     10
 7      11  11
 8        1111
Grand Total 2042422262222430
1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

ODS EXCEL + PROC TABULATE 

View solution in original post

1 REPLY 1
Reeza
Super User

ODS EXCEL + PROC TABULATE 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 1230 views
  • 1 like
  • 2 in conversation