topic Re: How to have %LET apply to only non-missing values in SAS Programming

How to have %LET apply to only non-missing values

Walternate — Thu, 14 Nov 2019 20:58:38 GMT

Hi,

I'm trying to set a macro variable called i using an existing variable in my dataset (which is numeric).

%let i = %sysfunc(inputn(var1, 3.));

The problem is that some records have var1 as correctly missing. I don't want those records to go through the macro I've set up anyway, but no matter how I try to set it up to run the macro conditionally, I'm getting error messages which indicate that SAS is trying to use the missing values of var1.

This is an example of something I tried:

%macro one;

if var1 ne . then do;

%let i = %sysfunc(inputn(var1, 3.));

end;

%mend;

%one;

I also tried

data want;

set have;

if var1 ne . then do;

%one;

end;

run;

I thought that since the records where var1 is missing did not meet the if criteria, they would not be run through the macro and cause the error messages, but that has not been the case.

Any help is appreciated.

Re: How to have %LET apply to only non-missing values

novinosrin — Thu, 14 Nov 2019 21:00:44 GMT

In a datastep use call symputx to create a macro variable

In an open code or macro definition, you could use %let . I hope you understand the macro compile time operation?

Re: How to have %LET apply to only non-missing values

Tom — Thu, 14 Nov 2019 21:08:11 GMT

Your macro code doesn't make any sense.

You are using %SYSFUNC() to call the INPUTN() function. As the value for inputn() to read you are passing in the constant text var1. Because you are using the informat of 3. the function is going to try and read just the first three of those characters, var, as a number. That will always return a missing value.

To access the value a variable named var1 you would need to use actual SAS code, not macro code.

What is it that you want to do in your data step?

Once you figure that out then you can think about whether or not you need to use any macro statements.