Automatic Recode of a variable into a multiple new variables

[galzohar]

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!

[Patrick · Accepted solution]

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.