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.
... View more
