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?
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;
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;
Thank you! It works!
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)
Thanks! Yes, patient is a numeric variable and after the correction it works!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.