DATA Step, Macro, Functions and more

Help with Proc Transpose

Accepted Solution Solved
Reply
Contributor
Posts: 43
Accepted Solution

Help with Proc Transpose

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


Accepted Solutions
Solution
‎12-27-2016 01:41 PM
Super User
Posts: 19,789

Re: Help with Proc Transpose

[ Edited ]

All Replies
Solution
‎12-27-2016 01:41 PM
Super User
Posts: 19,789

Re: Help with Proc Transpose

[ Edited ]

Here's a way to transpose via an array

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

Contributor
Posts: 43

Re: Help with Proc Transpose

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 223 views
  • 1 like
  • 2 in conversation