BookmarkSubscribeRSS Feed
Tejaswini3
Obsidian | Level 7

I want to combine two columns.

The dataset is

Tejaswini3_1-1654882044292.png

 

The final column should be

BODY AS A WHOLE - GENERAL DISORDERS

FATIGUE

FEVER

CENTRAL & PERIPHERAL NERVOUS SYSTEM DISORDERS

HEADACHE

 

1 REPLY 1
Reeza
Super User

For a report? Or in a data set? This seem smore like a report structure than data set structure.

 

*assumes data is sorted correctly. If order is important as in the file structure, add the word NOTSORTED to the end of the BY statement;
*replace data set and variable names as needed;
data want;
set have;
by Col2 Col1;
if first.Col2 then do;
temp=col1;
col1=col2; 
output;
col1=temp;
output;
end;
else output;
keep col1;
run;

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

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