topic Re: Transpose a single column. in SAS Programming

Transpose a single column.

deleted_user — Wed, 27 May 2009 08:40:27 GMT

My table has only one variable, Var1, with 3 observations. The table looks like this:

Var1
qwer
asdf
zxcv

I want the table to have one single row(observation) like this:

Col1 Col2 Col3
qwer asdf zxcv

I have tried with PROC TRANSPOSE in different ways, but haven't succeeded.

The examples I have found are more complicated and can't be applied to this simple situation.

Susan

Re: Transpose a single column.

LinusH — Wed, 27 May 2009 09:11:07 GMT

Do you want a generic solution that will transpose all rows in table independent of number of rows? If you just want to transpose this three row table, just use a data step with assignment statements and explicit output. A generic solution would contain a step the figure out number of rows, and building an array to assign the row values to.

Maybe you could use PROC TRANSPOSE, but I'm always find myself frustrated when using it, because I can't understand how the different options/statements interact, it feels less logical to me than other procedures.

/Linus

Re: Transpose a single column.

deleted_user — Wed, 27 May 2009 09:24:46 GMT

I am almost new to SAS.

I know the number of rows(observations of Var1) in my one column table, but I don't know the values in advance.

I don't think there are any indexes on a variable in a SAS table.

If it had been, I could have assigned Col1=Var1(1); Col2=Var1(2); Col3=Var1(3);.

Susan

Re: Transpose a single column.

ieva — Wed, 27 May 2009 12:19:17 GMT

Simple code that works:

data have;
input Var1 $;
datalines;
qwer
asdf
zxcv
;
run;

proc transpose data=have out=want (drop=_name_);
var var1;
run;

Re: Transpose a single column.

sbb — Wed, 27 May 2009 12:23:05 GMT

When you truly have a code problem, it is best to share the SAS code attempted and ideally any SAS log output with PUTLOG and other pertinent output diagnostics for forum subscriber feedback. Since attachments are not permitted, you can paste data/information directly into you forum post/reply as a communication means.

Scott Barry
SBBWorks, Inc.

Re: Transpose a single column.

deleted_user — Wed, 27 May 2009 12:39:27 GMT

Thank you very much, ieva.

I "knew" it had to be a simple solution.

Susan