BookmarkSubscribeRSS Feed
StaffanK
Calcite | Level 5
I need to convert a SAS-data set with two sort keys to a new set where key 1 define rows and key 2 define columns in the new set as exemplified below (as can be done with the pivot function in Excel)

Input:
Key1 Key2 Data
T1 AA 23
T2 AA 24
T3 AA 21
T1 BB 19
T2 BB 25
T1 CC 43
T3 CC 43

needed output:

Key1 AA BB CC
T1 23 19 43
T2 24 25
T3 21 43
1 REPLY 1
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Check PROC TRANSPOSE in the SAS DOC. Also, there are SAS support website technical / conference material on the topic.

Scott Barry
SBBWorks, Inc.

Suggested Google advanced search argument, this topic / post:

proc transpose site:sas.com

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 917 views
  • 0 likes
  • 2 in conversation