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

Hi All,
I need some help with proc transpose:

Have   Want
word meaning   word meaning1 meaning2 meaning3 meaning4
enthusiasm  strong excitement of feeling    enthusiasm  strong excitement of feeling  something inspiring fervor belief in special revelations of the Holy Spirit religious fanaticism
enthusiasm  something inspiring fervor   pessimism the doctrine that reality is essentially evil the doctrine that evil overbalances happiness in life    
enthusiasm  belief in special revelations of the Holy Spirit   set to cause to sit : place in or on a seat to place (oneself) in position to start running in a race to cause to assume a specified condition, relation, or occupation  
enthusiasm  religious fanaticism            
pessimism the doctrine that reality is essentially evil            
pessimism the doctrine that evil overbalances happiness in life            
set to cause to sit : place in or on a seat            
set to place (oneself) in position to start running in a race            
set to cause to assume a specified condition, relation, or occupation            

 

the word 'set' has nearly 100 meanings. Is it possible to transpose 'have' to get 'want'. 

1 ACCEPTED SOLUTION

Accepted Solutions
Astounding
PROC Star

This should be a standard transpose.  Assuming that your data set is sorted by WORD:

 

proc transpose data=have out=want (drop=_name_) prefix=meaning;

var meaning;

by word;

run;

View solution in original post

1 REPLY 1
Astounding
PROC Star

This should be a standard transpose.  Assuming that your data set is sorted by WORD:

 

proc transpose data=have out=want (drop=_name_) prefix=meaning;

var meaning;

by word;

run;

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 745 views
  • 3 likes
  • 2 in conversation