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
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.