topic Re: Move group on proc report as header in ODS and Base Reporting

Move group on proc report as header

albertsamaniego — Wed, 02 May 2018 04:43:02 GMT

Is there a way to move the groupings on proc report above each data for that groupings?

For example

I need to move the groupings above similar to this one.

Here's the code that I'm using

	proc report nowd data=dataset1;
				col (
				  (
				 	 groupings
				 	 ('Category A' categ_a_data1 categ_a_data2 categ_a_data3) 
				  	('Category B' categ_b_data)
			  		)
				);
				define groupings/ group;
			run;

Re: Move group on proc report as header

Cynthia_sas — Wed, 02 May 2018 12:33:05 GMT

Hi:
That looks like Report #2 in this previous posting: https://communities.sas.com/t5/ODS-and-Base-Reporting/Combine-Two-or-More-Proc-Report-Outputs-into-1-Output/m-p/456368#M20871

Can you explain what is different between this question and the question you originally posted? Can you provide data? Is that your COMPLETE code? That doesn't look like the output that should be created by that code because the default usage for all your character variables should be DISPLAY, but the report doesn't look like they are DISPLAY usage.

cynthia

Re: Move group on proc report as header

albertsamaniego — Thu, 03 May 2018 00:44:32 GMT

from my previous post, i'm just want to combine multiple proc reports from different dataset into 1 rtf table. but from this one, i'm just using one dataset and 1 proc report. and yes that's the complete code that i'm using and it's working. i just change the column names and the data because of the confidential data.

Re: Move group on proc report as header

Cynthia_sas — Thu, 03 May 2018 13:23:35 GMT

Hi: Can you post your fake data? The previous code that I posted was also just using 1 dataset, with the By Group information on top of each group's section. So it is exactly the same as what you are asking here.

Cynthia