Proc Transpose Problem

[WillS_]

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!

[PGStats]

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;

PG