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;

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

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