Help with Proc Transpose

[TMiles]

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

[Reeza · Accepted solution]

Here's a way to transpose via an array

http://www.ats.ucla.edu/stat/sas/modules/widetolong_data.htm

[TMiles]

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