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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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