08-10-2017 09:08 AM
I have the SAS code:
CREATE TABLE WORK.CLAIMS_&lob AS
FROM &lib..FACETS_CLAIMS t1
WHERE t1.SERVICE_FROM_DATE >= '1Jun2016:0:0:0'dt
AND t1.SERVICE_FROM_DATE <= '31Jul2017:0:0:0'dt
coudl not find what is wrong, no error message, but no result ....
could not resolve, please advise. thank you.
1 ! ;*";*/;quit;run;
NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space
between a quoted string and the succeeding identifier is recommended.
08-10-2017 09:14 AM
08-10-2017 09:23 AM
Not enough information to make any diagnosis here. The log snippet indicates unbalanced quotes. You could simplfy your code somewhat also to:
%macro liblonname (lib=,lob=); data claims_&lob. (keep=lob--medicare_indicator); set &lib..facets_claims; where '01JUN2017'd <= datepart(service_from_date) <= '31JUL2017'd and medicare_indicator="N"; run; %mend liblobname;
Although that whole code could be dropped in favour of putting all &lobs in one dataset and putting & lob as a column, then using by group processing which is both faster and easier to code. Not entirely sure why the whole macro part is there at all, you create a table called lob but never filter on it?
08-10-2017 09:56 AM