turn one row from an existing table into a column

[grungoo]

It seems like this should be pretty simple, but I can't find a way to make it work.  I have a table with multiple observations and 20 variables.  I want to pull one observation from that table and put the values into a column.

When I try proc transpose it only gives me half the variables, namely those with numerical values.

I just need to go from this:

name	this	that	other	those
Bob	5	male	42	5/31/2016

to this:

Bob

5

male

42

5/31/2016

Is there any easy way to do this?

[FreelanceReinh · Accepted solution]

Hi @grungoo,

By default, PROC TRANSPOSE transposes only numeric variables, but if you list character variables in the VAR statement, they will be transposed as well. So, the simplest way to transpose all variables is probably to use the statement

var _all_;

in the PROC TRANSPOSE step.

[grungoo]

I knew it had to be something simple.  Thank you!