Proc Transpose Problem

WillS_ — Fri, 21 Nov 2014 17:24:52 GMT

I am working with a data set and I performed the proc transpose to see multiple dates for the same variable in the by statement.

transpose data=dataset out=wide;

by var1;

var var2;

run;

When I run this I get . in Col1 for some but Col2 has data in it. My question is how can I move the data in Col2 to Col1 or move all data over so the first variable is in Col1?

Example:

Col1 Col2 Col3

. 31 32

30 32 33

Thank you!

Re: Proc Transpose Problem

PGStats — Fri, 21 Nov 2014 17:39:26 GMT

To move all non missing data towards Col1, try

PROC transpose data=dataset(where=(var2 is not missing)) out=wide;

by var1;

var var2;

run;

topic Proc Transpose Problem in SAS Procedures

Proc Transpose Problem

Re: Proc Transpose Problem