topic Re: Producing a report for multilayer output in Proc report SAS in SAS Programming

Producing a report for multilayer output in Proc report SAS

st_012 — Fri, 16 Nov 2018 01:36:43 GMT

I am trying to produce a report that looks like the one as in the attachment.

	Entourage (2015)	MAGIC MIKE XXL	KEANU	The Nice Guys	Fist Fight	CHIPS (2017).	GOING IN STYLE (2017)	HOUSE, THE	Game Night
	29-Sep-15	6-Oct-15	2-Aug-16	23-Aug-16	30-May-17	27-Jun-17	1-Aug-17	10-Oct-17	22-May-18
	$32.4	$66.0	$20.6	$36.3	$32.2	$18.6	$45.0	$25.0	$68.8
Wal-Mart	8.5	43.9	8.3	13.3	20.6	27.6	22.9	13.3	13.8
Target	3.5	14.4	2.4	4.6	3.4	2.9	4.5	2.4	3.9
Best Buy	4.6	5.2	2.0	5.8	2.4	2.6	2.4	1.7	3.5
Amazon	4.3	11.9	1.2	6.3	0.8	1.8	3.0	1.0	2.0
Others	5.3	11.0	2.6	8.1	5.3	7.1	6.7	4.3	5.6
Total	26.1	86.3	16.6	38.2	32.4	41.9	39.5	22.7	28.7

The Entourage,magic mike... House the are the movie titles which are in the column MPM Description. The date below the movie titles are the Release date for each movie and the dollar value below that line is the box office collection for each titles. left most column is the accounts name. Is there any anyway we can produce this report with proc report? Please help me get it.

Thank you,

Shankar

Re: Producing a report for multilayer output in Proc report SAS

ChrisNZ — Tue, 20 Nov 2018 03:41:56 GMT

What do the numbers represent?

How is your data organised?

Re: Producing a report for multilayer output in Proc report SAS

st_012 — Tue, 20 Nov 2018 03:48:14 GMT

The first row is the name of the movies under the Column name MPM_Description. The second row is the date of that movie release and the third row is the Box office collection for each movies. The Rows on the right is the account name. The table is filled with the value of Initial Shipment. The data is like in MPM_Description, Release_Date, Box_office, Acctname, Initial_Ship.

Re: Producing a report for multilayer output in Proc report SAS

st_012 — Tue, 20 Nov 2018 20:19:37 GMT

Here is the output:

The input data is attached below. The Meg is the new release we have and the column day1plan,day1estimate and day1 variance is for that Title only.

Please let me know if any solutions. I really need this.

Thank you,

Shankar

Re: Producing a report for multilayer output in Proc report SAS

ChrisNZ — Tue, 20 Nov 2018 20:29:32 GMT

1. Try to avoid MS office files, many people won't download them.

2. The specific layout you are after may best be created with the very flexible ODSOUT object.

See https://communities.sas.com/t5/ODS-and-Base-Reporting/The-DATA-step-ODSOUT-object/td-p/87686

Re: Producing a report for multilayer output in Proc report SAS

st_012 — Tue, 20 Nov 2018 22:28:07 GMT

Thanks ChrisNZ. But, I am not that much familiar with that ODSOUT and it is little urgent.So, if there is any way with proc report that would be great.

Thank you.
Shankar

Re: Producing a report for multilayer output in Proc report SAS

ChrisNZ — Tue, 20 Nov 2018 23:01:00 GMT

I don't know how proc report could span rows the way you expect.