topic Re: conditions in macro in SAS Programming

conditions in macro

Kitty_Zhu — Mon, 30 Jun 2014 08:53:15 GMT

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 — Mon, 30 Jun 2014 08:58:36 GMT

Hi,

Your missing the ampersand:

where=&wherecon1.;

Kitty_Zhu — Mon, 30 Jun 2014 09:01:56 GMT

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

Dalveer — Mon, 30 Jun 2014 11:59:24 GMT

Hi,

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

so, where=&wherecon1;

rest is perfect....