topic Help in my code when using %symexist function in SAS Programming

Help in my code when using %symexist function

knveraraju91 — Mon, 20 Apr 2020 18:08:28 GMT

data one;
input avalc $ aval;
datalines;
r1 1
r2 2
r3 3
r4 4
;

proc sql ;
select count(distinct avalc) into: cntt trimmed from one;
select distinct avalc into :param1 -:param&cntt.
from one;
quit;

%put &param1;
%put &param2;
%put &param3;
%put &param4;

data two three four six;
set one;
if avalc='r1' then output two;
if avalc='r2' then output three;
if avalc='r3' then output four;
if avalc='r4' then output six;
run;

%macro want;
data final;
set two three %if %symexist (param3) %then %do; four;%end; %if %symexist (param4) %then %do; six; %end;;
run;
%mend;
options mprint mlogic symbolgen;
%want;

Dear

when I run macro(%want) at the bottom of my pgm i am getting error. Please suggest Thank you

output expected from macro %want

data final;
set two three four six;
run;

Re: Help in my code when using %symexist function

Tom — Mon, 20 Apr 2020 18:13:47 GMT

If you wanted that code then why did you insert those two extra semi-colons?

Plus the %do/%end blocks seem like overkill.

%macro want;
data final;
  set two three 
%if %symexist (param3) %then four ;    
%if %symexist (param4) %then six ;
  ;
run;
%mend;

Re: Help in my code when using %symexist function

Kurt_Bremser — Mon, 20 Apr 2020 18:20:41 GMT

Since version 9.4M5, you do not need a macro definition, %if %then %do %end can be used in open code:

data final;
set
  two
  three
%if %symexist (param3) %then %do; 
  four
%end;
%if %symexist (param4) %then %do;
  six
%end;
;
run;
%mend;