cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ecc14
‎10-12-2018
  • 3 Posts
  • 1 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Data Transformation SAS Help: from Rows to Columns

by Calcite | Level 5 in SAS Programming
‎10-12-2018 03:28 PM
‎10-12-2018 03:28 PM
Do you mind walking me through what you are doing here? I'm not sure I am following:   call execute(catt('have(where=(Metric="',Metric,'") rename=(Actual=',Metric,'_Actual Forecast=',Metric,'_Forecast Total=',Metric,'_Total))')); if last then call execute(';by Product;drop Metric;run;')   ... View more

Re: Data Transformation SAS Help: from Rows to Columns

by Calcite | Level 5 in SAS Programming
‎10-11-2018 05:04 PM
‎10-11-2018 05:04 PM
Thank you so much Astounding! This worked for me.   ... View more

Data Transformation SAS Help: from Rows to Columns

by Calcite | Level 5 in SAS Programming
‎10-11-2018 04:33 PM
‎10-11-2018 04:33 PM
Hi,    I am trying to transform how my data is laid out. The data that I am starting with is formatted as such:  Product Metric Actual Forecast Total A Sales 10 10 20 A Profit 5 5 10 B Sales 20 20 40 B Profit 15 15 30   I am trying to transform my data to look like this: Product Sales Actual Sales Forecast Sales Total Profit Actual Profit Forecast Profit Total A 10 10 20 5 5 10 B 20 20 40 15 15 30   I am newer to SAS, but have had success with transposing data in the past though i have not been able to get it to work with this dataset.    Thank you in advance for the help, Emily ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-12-2018 08:24 PM
Likes given to
View All
Quick links