Hello All, I've created the macro below, however when I run the very first SQL statement of my code I keep getting errors?? Macro below: %MACRO NEEDDT(PLM12019,BEGDATE,ENDDATE); %LET BEGDATE = MDY(12,31,2019); %LET ENDDATE = MDY(01,31,2020); %LET CYABSTR =PLM12020; /*use if pulling from a ASQ abstract*/ %LET PRABSTR =PLM12019; %MEND NEEDDT; My first SQL statement below: PROC SQL; create table r.originalPLMPOP as select PLDOCNUM AS CIDORNUM LABEL='CIDORNUM' FROM &PRABSTR WHERE EVNTTYPE='07'; /*Prison Population*/ QUIT; Errors below: PROC SQL; 10 ! create table r.originalPLMPOP as select 11 PLDOCNUM AS CIDORNUM LABEL='CIDORNUM' 12 FROM &PRABSTR WARNING: Apparent symbolic reference PRABSTR not resolved. 12 FROM &PRABSTR - 22 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, CONNECTION, DICTIONARY. 12 FROM &PRABSTR - 200 ERROR 200-322: The symbol is not recognized and will be ignored. 13 WHERE EVNTTYPE='07'; 13 ! /*Prison Population*/ 14 QUIT; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.01 seconds
... View more
