BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
TMiles
Quartz | Level 8

A vendor sent this file and for the life of me I cannot get it to transpose the way I want.  The file is structured with a column for each date and metric (so 90 extra columns to wide)

 

I need the 1st 5 columns (my by statement) with a single date column and 1 column for each metric (impressions, adcost, & clicks)

 

Thank you for any help

Tammy

1 ACCEPTED SOLUTION
2 REPLIES 2
TMiles
Quartz | Level 8

Thank you -I didn't even think about using an Arrray!

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 2 replies
  • 1825 views
  • 1 like
  • 2 in conversation