topic 49: LINE and COLUMN cannot be determined. when creating a macro variable with proc sql in SAS Programming

49: LINE and COLUMN cannot be determined. when creating a macro variable with proc sql

proctice — Tue, 27 Mar 2018 23:37:47 GMT

So, I am trying to create a macro variable to store a list of codes that I will use in an in statement, but it is missing the first and last quotation mark which I will add later, but just trying to %put &icd causes the line and column error. Any suggestions?

proc sql;
select icd_code into :icd separated by "','" from ds ;
quit;

%let pq = %str(%(%');
%let qp = %str(%'%));

if icd in &pq&icd&qp then etc. etc.

Re: 49: LINE and COLUMN cannot be determined. when creating a macro variable with proc sql

Astounding — Wed, 28 Mar 2018 00:03:33 GMT

Make it easy instead of making it difficult:

proc sql;
select quote(icd_code) into :icd separated by ' ' from ds ;
quit;

if icd in (&icd) then

Re: 49: LINE and COLUMN cannot be determined. when creating a macro variable with proc sql

ChrisNZ — Wed, 28 Mar 2018 02:50:48 GMT

proc sql;
select quote(trim(icd_code)) into :icd separated by ' ' from ds ;
quit;