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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.