Hi, I am creating code that will send out an automatic report. This is a daily report and it tracks the changes from day to day. I want to track the difference by a (+) or (-) so whoever reads it knows if the numbers are going up or down. For example, here is part of my output: As of 19SEP2022, The percentage of beds occupied is 3.1% ( ( 0.1%) change from the previous day). I would like to say (-0.1% change from the previous day). Also how do I get rid of the extra parentheses around the 0.1%? Please see code below: data test; set counts11; DIF_bullet1 = DIF(prop_new); format today_s_date MMDDYY10.; run; Data bullet1; Set test; CALL SYMPUTX('bullet1', put(prop_new,percent10.1)); CALL SYMPUTX('DIF_bullet1', put(DIF_bullet1, percent10.1)); KEEP today_s_date prop_new DIF_bullet1; Run; OPTIONS EMAILSYS=smtp Emailhost = placeholder.org EMAILPORT=25 EMAILID="placeholder.org"; FILENAME Mailbox EMAIL ATTACH=("T:\Placeholder" "T:\Placeholder"); Data _NULL_; FILE Mailbox TO=('Placeholder.org') CC=('placeholder.org') SUBJECT="Daily Report &today"; PUT "The &today Report."; PUT " "; PUT "• As of &today, The percentage of beds occupied is &bullet1. ( &DIF_bullet1. change from the previous day)."; proc printto; RUN;
... View more