BookmarkSubscribeRSS Feed
SAS_taozi
Calcite | Level 5

Hi everyone,

 

I need to create extra rows by swapping variables. For example, I have a dataset with two variables first name and last name:

firstName lastName

Sara        Daner

 

And I want an extra row by swapping first name and last name, desired dataset will be like:

firstName lastName

Sara        Daner

Daner      Sara

 

What is the best way to do it? Thanks!

 

 

1 REPLY 1
Tom
Super User Tom
Super User

One way is to use RENAME= option.

data want;
  set have have(rename=(firstName=lastName lastName=firstName));
run;

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