ODS EXCEL - Proc Reports Side by Side

Rushh — Wed, 27 Jun 2018 12:26:08 GMT

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

Growth %

Date

Growth %

Date

Growth %

Turnover

Turonver

Turnover

01/06/2017

01/06/2018

x $

02/06/2017

+k%

01/06/2018

...

02/06/2017

01/06/2018

02/06/2017

02/06/2018

y $

03/06/2017

+m%

02/06/2018

03/06/2017

02/06/2018

03/06/2017

03/06/2018

z $

04/06/2017

+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

Re: ODS EXCEL - Proc Reports Side by Side

RW9 — Wed, 27 Jun 2018 12:42:11 GMT

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.

topic Re: ODS EXCEL - Proc Reports Side by Side in ODS and Base Reporting

ODS EXCEL - Proc Reports Side by Side

Re: ODS EXCEL - Proc Reports Side by Side