BookmarkSubscribeRSS Feed
Parashar
Calcite | Level 5
my raw data is like this
id ab bb cb db eb a1 b1 c1 d1 e1 a2 b2 c2 d2 e2 a3 b3 c3 d3 e3
1 11 23 43 23 43 12 34 54 23 43 11 23 45 67 65 11 23 45 67 32
2 43 54 76 87 45 67 87 54 67 89 76 54 34 67 89 09 76 45 34 56

I have to make it like this
base 1wk 2wk 3wk
a 11 12 11 11
b 23 34 23 23
c 43 54 45 45
d 23 23 67 67
e 43 43 65 32



Please Help me with this and guid me how to transpose that using proc transpose or array or anything else pls give me coding for that also

Thanks in advance
1 REPLY 1
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
It is not necessary to post a particilar query in multiple SAS discussion forums.

Scott Barry
SBBWorks, Inc.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

Health and Life Sciences Learning

 

Need courses to help you with SAS Life Sciences Analytics Framework, SAS Health Cohort Builder, or other topics? Check out the Health and Life Sciences learning path for all of the offerings.

LEARN MORE

Discussion stats
  • 1 reply
  • 1287 views
  • 0 likes
  • 2 in conversation