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!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: