Help in my code when using %symexist function

[knveraraju91]

Spoiler

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;

[Tom · Accepted solution]

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;

[Kurt_Bremser]

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;