topic Re: Help with Proc Transpose in SAS Programming

Help with Proc Transpose

TMiles — Sat, 24 Dec 2016 00:48:55 GMT

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

Re: Help with Proc Transpose

Reeza — Sat, 24 Dec 2016 05:20:07 GMT

Here's a way to transpose via an array

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

Re: Help with Proc Transpose

TMiles — Tue, 27 Dec 2016 18:42:22 GMT

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