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!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.