BookmarkSubscribeRSS Feed
WillS_
Calcite | Level 5


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!

1 REPLY 1
PGStats
Opal | Level 21

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 644 views
  • 3 likes
  • 2 in conversation