Help using Base SAS procedures

Proc Transpose Problem

Reply
Occasional Contributor
Posts: 6

Proc Transpose Problem


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!

Respected Advisor
Posts: 4,644

Re: Proc Transpose Problem

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

PG
Ask a Question
Discussion stats
  • 1 reply
  • 163 views
  • 3 likes
  • 2 in conversation