Hello,
I am preparing a detailed report with ODS EXCEL.
I couldn't figure out how to print my proc reports side by side on a sheet. There is a solution with using R in the forums but I am looking for a different solution.
I want my data to look like this:
Proc report 1 (newyork)
Proc report 2 (miami)
Proc report 3 (paris)
Proc report 1 | New York | Proc report2 | Miami | Proc Report 3 | Paris | |||||||||||
Date | Date | Growth % | Date | Date | Growth % | Date | Date | Growth % | ||||||||
Turnover | Turnover | Turnover | Turnover | Turonver | Turnover | |||||||||||
01/06/2017 | 01/06/2017 | 01/06/2017 | . | |||||||||||||
01/06/2018 | x $ | 02/06/2017 | a$ | +k% | 01/06/2018 | ... | 02/06/2017 | . | . | 01/06/2018 | .. | 02/06/2017 | . | . | ||
02/06/2018 | y $ | 03/06/2017 | b$ | +m% | 02/06/2018 | . | 03/06/2017 | . | . | 02/06/2018 | . | 03/06/2017 | . | . | ||
03/06/2018 | z $ | 04/06/2017 | c$ | +n% | 03/06/2018 | . | 04/06/2017 | . | . | 03/06/2018 | . | 04/06/2017. | . | |||
04/06/2018 | . | 05/06/2017 | . | +% | 04/06/2018 | . | 05/06/2017 | . | . | 04/06/2018 | . | 05/06/2017 | . | . | ||
05/06/2018 | . | 06/06/2017 | . | . | 05/06/2018 | . | 06/06/2017 | . | . | 05/06/2018 | . | 06/06/2017 | . | . | ||
06/06/2018 | . | 07/06/2017 | . | . | 06/06/2018 | . | 07/06/2017 | . | . | 06/06/2018 | . | 07/06/2017 | . | . | ||
07/06/2018 | . | 08/06/2017 | . | . | 07/06/2018 | . | 08/06/2017 | . | . | 07/06/2018 | . | 08/06/2017 | . | . | ||
08/06/2018 | . | 09/06/2017 | . | . | 08/06/2018 | . | 09/06/2017 | . | . | 08/06/2018 | . | 09/06/2017 | . | . | ||
09/06/2018 | . | 10/06/2017 | . | . | 09/06/2018 | . | 10/06/2017 | . | . | 09/06/2018 | . | 10/06/2017 | . | . | ||
10/06/2018 | . $ | 11/06/2017 | .$ | +.% | 10/06/2018 | . | 11/06/2017 | . | . | 10/06/2018 | . | 11/06/2017 | . | . | ||
The hardest way to do this is preparing the data source by appending side by side but I will have a lot of proc reports around 7-8.
Is there a way to print proc reports at the same sheet side by side?
Thank you
As far as I know you can't. You can merge the data together - I don't see why this is a big issue for you?
data want; merge report1 report2 (rename=(date=date2 turnover=turnover2...)) report3 (rename=(date=date3...)); by ...; run;
There are missing parts there as I don't have full information, maybe you want to merge by _n_, if so you need to add that as a variable to the data.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.