topic Re: turn one row from an existing table into a column in SAS Programming

turn one row from an existing table into a column

grungoo — Fri, 13 May 2016 15:31:28 GMT

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

male

5/31/2016

Is there any easy way to do this?

Re: turn one row from an existing table into a column

FreelanceReinh — Fri, 13 May 2016 15:44:16 GMT

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.

Re: turn one row from an existing table into a column

grungoo — Fri, 13 May 2016 15:48:21 GMT

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