Producing a report for multilayer output in Proc report SAS

[st_012]

    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

[ChrisNZ]

What do the numbers represent?

How is your data organised?

[st_012]

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.

[st_012]

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

[ChrisNZ]

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

[st_012]

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

[ChrisNZ]

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