All,
I have a simple question. How can one perform a logical test to validate if a macro variable has missing value ?
For e.g.:
%Let a = .;
%Put &a.;
%If &a = %str() %Then
%Do;
%Put "1";
%End;
I thought something like this, but doesn't get me too far.
@Astounding ,
Thank you for your response. May I ask you to offer a little more clarity ,
%Let a = . ;
%if %length(&a) %then
%do;
%put 1;
%end;
%else;
%put 0;
%end;
This returns an error. Can you point as to what is wrong ? Additionally, can you point me to the paper you are referring to ?
@UdayGuntupalli wrote:
(...) Additionally, can you point me to the paper you are referring to ?
Just for completeness, this is (most likely) the paper Astounding referred to: https://support.sas.com/resources/papers/proceedings09/022-2009.pdf
%If &a = %Then %Do;%Put "1";%End;
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.
Ready to level-up your skills? Choose your own adventure.