Hi. I have the following step that outputs my Proc Report to excel. I'm wondering if there a way to Bold cells in the output that contain the word TOTAL and SUBTOTAL? See attached pic of output.
I'd appreciate any help you can give. Thanks.
ODS EXCEL FILE="C:\USERS\STEVEBUECHLER\BOX SYNC\IBM\USPS\HRC PAY DATA ANALYSIS\&SITE._HCR_PD_SUMMARY.XLSX";
PROC REPORT DATA=&SITE._HCR_SUMMARY;
COLUMNS _ALL_;
RUN;
ODS EXCEL CLOSE;
The CALL DEFINE statement in a COMPUTE block in PROC REPORT will allow you to modify text to bold (and many other things as well).
Examples here: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=proc&docsetTarget=p0xcdci...
The CALL DEFINE statement in a COMPUTE block in PROC REPORT will allow you to modify text to bold (and many other things as well).
Examples here: https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=proc&docsetTarget=p0xcdci...
This paper has fully worked examples for many format options.
https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2018/2479-2018.pdf
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.