BookmarkSubscribeRSS Feed
Jaime
Fluorite | Level 6
Is there a way to keep proc report from skipping a group element.

For example, the script below will skip printing award_date if the previous value is the same.

proc report data=sheet3 style=mystyle split='*' ;
column award_date member_id name_last name_first fee_type
('Fee Category Breakdown' fee1 fee2 fee3 fee4 fee5 )
('Summary' owed paid pending);
define award_date/ 'Award*Date' order;
define member_id/ 'Member #' order;
1 REPLY 1
Cynthia_sas
SAS Super FREQ
Hi:
Look at this previous forum posting:
http://support.sas.com/forums/thread.jspa?messageID=15963㹛

especially at the creation of the COMPUTED variable DISPREG. It would not matter if REGION was a GROUP or ORDER variable, you would use a similar technique to make your AWARD_DATE variable value repeat on every line.

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
  • 1 reply
  • 611 views
  • 0 likes
  • 2 in conversation