Is there a way to automatically recoding a certain variable into multiple new variables at once? For instance, make the gender variable into two different variables at once?
I rather use it with function if possible, but any solution would be helpful.
Thanks!
It's most of the time better to have a long and narrow table over having a wide table with values split into multiple variables with a lot of blanks/missings.
Most SAS procedures work just fine with such long and narrow tables.
If you really need to go for a wide table structure then how to transform your data will depend. But have a look into Proc Transpose. That might give you what you're after.
It's most of the time better to have a long and narrow table over having a wide table with values split into multiple variables with a lot of blanks/missings.
Most SAS procedures work just fine with such long and narrow tables.
If you really need to go for a wide table structure then how to transform your data will depend. But have a look into Proc Transpose. That might give you what you're after.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.