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
Diamond | Level 26
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
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
  • 1 reply
  • 947 views
  • 0 likes
  • 2 in conversation