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!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.