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-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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