BookmarkSubscribeRSS Feed
albertsamaniego
Fluorite | Level 6

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

 

For example

 

report1.PNG

 

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

report2.PNG

 

 

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;

 

3 REPLIES 3
Cynthia_sas
SAS Super FREQ
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...

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
albertsamaniego
Fluorite | Level 6
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.
Cynthia_sas
SAS Super FREQ
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

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 993 views
  • 0 likes
  • 2 in conversation