Help using Base SAS procedures

keep sequence in proc transpose

Reply
Super Contributor
Posts: 395

keep sequence in proc transpose

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

Respected Advisor
Posts: 3,777

Re: keep sequence in proc transpose

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

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