Hello,
how can I turn a macrovariable currently having missing value to being zero?
Thanks,
Your sincerely,
Simone
Hello @Tom ,
thanks for your answer. The %IF/%THEN/%DO block was just what I was looking for.
Have a nice day,
Simone
If you want to change the value use a %LET statement.
If you want to change it conditionally then use a %IF/%THEN/%DO block.
Macro variables do not have a concept of missing. They are just text strings.
If by missing you mean not defined then use:
%if not %symexist(mvar) %then %do;
%let mvar=0;
%end;
If by missing you mean totally empty then use:
%if 0=%length(&mvar) %then %do;
%let mvar=0;
%end;
But you might want to instead update the code that is creating the macro variable to create it with zero for missing.
So if you created macro variable MVAR from actual variable VAR then perhaps update the code to be more like this:
call symputx('mvar',coallesce(var,0));
Hello @Tom ,
thanks for your answer. The %IF/%THEN/%DO block was just what I was looking for.
Have a nice day,
Simone
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 how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.