BookmarkSubscribeRSS Feed
podarum
Quartz | Level 8

Hi, I'm trying to keep the date of a group of accts. and transpose it into the column name along wiht the score.. here's what I mean..

Have

Acct    Date     Score

001     Jul12     234

001     Aug12   235

001     Sep12   364

002     Jul12    535

002    Aug12   534

002    Sep12    535

Want

Acct   Jul12_score     Aug12_score         Sep12_score

001        234                    235                         364

002         535                    534                         535

thanks

1 REPLY 1
data_null__
Jade | Level 19

PROC TRANSPOSE has everything you need to create have from want.  Have you seen the online documentation it is very informative.

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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