Outputting blank variables in if/then statement

scolitti1 — Fri, 28 Oct 2022 20:33:33 GMT

I have created an automated report that changes based on daily numbers. I have been asked to add (+) or (-) in front of increased or decreased numbers. SAS will already put a (-) sign in front of a decreased number, so I put together code that will out put a (+) for an increased number. However, if there was no change or if there was a decrease it will still output a (+). Below is my code so far:

data emaster;
set counts11;
if DIF_bullet1>0 then b1='+'; else if DIF_bullet1<=0 then b1='';
format today_s_date MMDDYY10.;
run;

Re: Outputting blank variables in if/then statement

Quentin — Fri, 28 Oct 2022 20:48:08 GMT

I'm not quite understanding your example, but would suggest building a picture format, as described in the answers to this post:

https://communities.sas.com/t5/SAS-Enterprise-Guide/SAS-EG-Numeric-Format-add-positive-sign-to-values/td-p/406513

topic Re: Outputting blank variables in if/then statement in New SAS User

Outputting blank variables in if/then statement

Re: Outputting blank variables in if/then statement