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
Here's a way to transpose via an array
http://www.ats.ucla.edu/stat/sas/modules/widetolong_data.htm
Here's a way to transpose via an array
http://www.ats.ucla.edu/stat/sas/modules/widetolong_data.htm
Thank you -I didn't even think about using an Arrray!
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.