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

[freezingswallow]

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?

[SASKiwi · Accepted solution]

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;

[freezingswallow]

Thank you! It works!

[ftsh]

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)

[freezingswallow]

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