What is the best way to create extra rows by swapping variables?

SAS_taozi — Tue, 28 Jun 2022 16:48:21 GMT

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!

Re: What is the best way to create extra rows by swapping variables?

Tom — Tue, 28 Jun 2022 17:35:59 GMT

One way is to use RENAME= option.

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