conditions in macro

[Kitty_Zhu]

Hi guys,

I keep getting errors of the following code, it says "NOTE: Variable "wherecon1" may not be initialized". Could you help? Thanks!

%let wherecon1=(year>=1993);

%macro applyfilters;

  data db.filtersample;

    set db.fullsample(obs=5);

    where=wherecon1;

  run;

%mend;

%applyfilters;

[RW9 · Accepted solution]

Hi,

Your missing the ampersand:

    where=&wherecon1.;

[Kitty_Zhu]

Ha...yeah...I forgot to add &...Thanks!!!

[Dalveer]

Hi,

to take that macro value you need to call that macro by using &

so, where=&wherecon1;

rest is perfect....