I would like to add blank rows in between each subject group. Here's my data and I tried using PROC REPORT. However, the blank rows works only in the listings output. Didn't work on my report output. Since I use ODS EXCEL, the blank rows didn't work. Can anyone please help?
data report;
input variable $ value $ group ;
cards;
Sex F 1
Sex M 1
Age <18 2
Age 18-30 2
Age 31-50 2
Age >50 2;
run;
/* ods excel file='/mydirectory.report.xlsx'; */
proc report nofs data=report headline ;
columns group variable value ;
define group / order noprint ;
define variable / display ;
define value / display ;
break after group / skip ;
run;
/* ods excel close; */
One way would be to add a compute block. e.g.:
data report; input variable $ value $ group ; cards; Sex F 1 Sex M 1 Age <18 2 Age 18-30 2 Age 31-50 2 Age >50 2 ; run; /* ods excel file='/mydirectory.report.xlsx'; */ ods excel file='/folders/myfolders/report.xlsx'; proc report nofs data=report headline ; columns group variable value ; define group / order noprint ; define variable / display ; define value / display ; /* break after group / skip ; */ compute after group; line ' '; endcomp; run; ods excel close;
Art, CEO, AnalystFinder.com
One way would be to add a compute block. e.g.:
data report; input variable $ value $ group ; cards; Sex F 1 Sex M 1 Age <18 2 Age 18-30 2 Age 31-50 2 Age >50 2 ; run; /* ods excel file='/mydirectory.report.xlsx'; */ ods excel file='/folders/myfolders/report.xlsx'; proc report nofs data=report headline ; columns group variable value ; define group / order noprint ; define variable / display ; define value / display ; /* break after group / skip ; */ compute after group; line ' '; endcomp; run; ods excel close;
Art, CEO, AnalystFinder.com
Thank you very much. This is perfect!
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.
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.