topic Re: Hi! Does anybody have a clue why this error appeared? in SAS Programming

Hi! Does anybody have a clue why this error appeared?

freezingswallow — Mon, 02 Feb 2015 19:19:25 GMT

Hello!

This is my macro code:

%macro printz(patient);

proc print data = PT;

where patient = "&patient";

var patient AGE_DERIVED_FUL AGE_DERIVED_UNIT_FUL LstChg_Ts;

run;

%mend printz;

%printz(10011001)

After submission, I got the error message:

ERROR: WHERE clause operator requires compatible variables.

Can I get some help?

Re: Hi! Does anybody have a clue why this error appeared?

SASKiwi — Mon, 02 Feb 2015 19:24:06 GMT

Most likely patient is a numeric variable so your WHERE clause needs a compatible value. Remove the quotes to correct your error: where patient = &patient;

Re: Hi! Does anybody have a clue why this error appeared?

ftsh — Mon, 02 Feb 2015 19:25:20 GMT

try this

%macro printz(patient=);

proc print data = PT;

where patient = "&patient";

var patient AGE_DERIVED_FUL AGE_DERIVED_UNIT_FUL LstChg_Ts;

run;

%mend printz;

%printz(patient=10011001)

Re: Hi! Does anybody have a clue why this error appeared?

freezingswallow — Mon, 02 Feb 2015 19:47:55 GMT

Thank you! It works!

Re: Hi! Does anybody have a clue why this error appeared?

freezingswallow — Mon, 02 Feb 2015 19:48:43 GMT

Thanks! Yes, patient is a numeric variable and after the correction it works!