Hi Cynthia,   Thank you for your comments. Sometimes I use similar codes generating rtf and excel. That's the reason you still see part of the codes for rtf. Below is the complete version of my code. %macro exportOutput(cohort, sheetname); ods excel file="/Volumes/data/Output/Table_&cohort..xlsx" options(sheet_name=&sheetname.); title "Table1. Baseline Characteristics by Study Cohorts"; proc report data=outputw style(report)={just=left} colwidth=6 style(header)={just=center protectspecialchars=off font_weight=BOLD background=white} headline headskip split="/" missing; column group ('Characteristics' vardesc) (' ' var_val) ("UC Overall" ("N" col1_cohort1) ("%" col2_cohort1) ) ("UC Moderate to Severe" ("N" col1_cohort2) ("%" col2_cohort2) ) ("UC Trial Similar" ("N" col1_cohort3) ("%" col2_cohort3) ) ("General Population" ("N" col1_cohort4) ("%" col2_cohort4) ) ; define group /group noprint order=data; define vardesc /group ' ' order=data style=[just=l]; define var_val / display ' ' order=data style(column)={width=1 in just=l}; define col1_cohort1 /display ' ' format=comma10. style(column)={cellwidth=0.5in just=c }; define col2_cohort1 /display ' ' format=comma5.2 style(column)={cellwidth=0.5in just=c }; define col1_cohort2 /display ' ' format=comma10. style(column)={cellwidth=0.5in just=c }; define col2_cohort2 /display ' ' format=comma5.2 style(column)={cellwidth=0.5in just=c}; define col1_cohort3 /display ' ' format=comma10. style(column)={cellwidth=0.5in just=c }; define col2_cohort3 /display ' ' format=comma5.2 style(column)={cellwidth=0.5in just=c }; define col1_cohort4 /display ' ' format=comma10. style(column)={cellwidth=0.5in just=c }; define col2_cohort4 /display ' ' format=comma5.2 style(column)={cellwidth=0.5in just=c}; compute before group/ style=[just=l font_weight=bold]; line @1 group group.; endcomp; compute var_val; call define(_col_,"style","style={leftmargin=.15in font_weight=medium}"); endcomp; compute col1_cohort1; if var_val in ('Mean (SD)') then call define(_col_,"format","format=comma5.2"); /* if var_val in ('Mean (SD)') then call define(_col_,'style','style=[TAGATTR="format:#,##0.00"]'); */ endcomp; compute col1_cohort2; if var_val in ('Mean (SD)') then call define(_col_,"format","format=comma5.2"); /* if var_val in ('Mean (SD)') then call define(_col_,'style','style=[TAGATTR="format:#,##0.00"]'); */ endcomp; compute col1_cohort3; if var_val in ('Mean (SD)') then call define(_col_,"format","format=comma5.2"); /* if var_val in ('Mean (SD)') then call define(_col_,'style','style=[TAGATTR="format:#,##0.00"]'); */ endcomp; compute col1_cohort4; if var_val in ('Mean (SD)') then call define(_col_,"format","format=comma5.2"); /* if var_val in ('Mean (SD)') then call define(_col_,'style','style=[TAGATTR="format:#,##0.00"]'); */ endcomp; run; /* ods rtf close; */ /* ods listing; */ title; ods excel close; %mend exportOutput; %exportOutput(Cohorts, 'Table 1-Demographic'); ... View more

Yes, using freq statement instead really works. Thank you @ballardw @Reeza for your great suggestions! ... View more

Thank you for your reply! Adding weight statement alone couldn't generate weighted N and weighted column percentage from 'n*f=comma8. colPctN*f=4.1' in SAS Studio. ... View more

data sample; input uniqueid $ flag_A1C9_lst Cat_raceeth obesity Hyperlipidemia Hypertension cohort FWGT_2019 ; datalines; 1 1 1 1 1 0 1 1473 2 0 2 0 1 1 0 2296 3 . 3 1 0 1 1 7484 ; run; The expected output looks like below: Thank you for your help! ... View more

Good catch! But unfortunately, it didn't work when I fixed as you suggested. I guess the order of color is set by default and hard to change in SAS studio? ... View more

Thank you for your response! @JeffMeyers Yes. I was asking for CL of mean as pointed out by @user021 . Congratulations on the new position!    ... View more

That is very helpful! Thanks for your inputs! ... View more

Hello @JeffMeyers  Thanks for sharing your great work. It makes my life much easier with your macro. May I ask if it's possible to provide 95% CI for continous variable as well? It would be great if the table could provide N and % in seperate cell, which would be even better when people want to generate figures using the output data. I wish I could make some adjustment of your program to achieve it. But it's out of my capability. Any suggestion will be greatly valued. Thank you!  ... View more