topic Re: %If & then Error in New SAS User

%If & then Error

sas_noob420 — Mon, 02 Mar 2020 23:21:26 GMT

Hey guys,

I am new to macros. I'm having trouble getting it to run properly. &q resolves into either a 0 or 1. Whenever is resolves to a one then d=1, I then want it to assign variable1 the variable Count_parameter so I can use it in the bottom macro. If &q resolves to 0 then I want there to be no variable name in the parameter so that it is missing. However whenever I run it regardless of the value of d the variable one is always missing and then the parameters are missing from the next macro. I know this is because of the way SAS compiles, but I don't know how to fix it. Thank you!

%Let C1=Count_Parameter

d=&q;

%IF d=1 %THEN %DO;
   %let variable1=&C1;
  %END;
  %Else %DO;
   %let variable1= ;
  %END;

%macroexample(var=variable1);

Re: %If & then Error

mkeintz — Mon, 02 Mar 2020 23:31:54 GMT

The expression

%if d=1 %then %do;

will NEVER be true. Macro thinks you are comparing a one-letter character string (d) to the single digit (1). You have to tell macro that D is a macro variable, not a literal text. That's what the leading ampersand is for So, lesson 1 in macro coding, try

%if &d=1 %then %do;

But before you get there you also need to change

d=&q;

%let d=&q;

Re: %If & then Error

sas_noob420 — Mon, 02 Mar 2020 23:44:00 GMT

Hallelujah! Thank you! It worked. I tried everything for hours, but that.