I have a SAS coding issue which I am hoping someone can assist with.   My job is using the following instruction to create a SAS macro variable called &init_valueAMPEPCNT : -   proc sql; select TOTAL_CR_CNT into :init_valueAMPEPCNT from perm.recordsAMPEP3; where file_id = 'EFTAMPNZ'; quit;   Problem is, the job returns a condition code of RC=4.   This is what is returned: -   149 proc sql; 150 select TOTAL_CR_CNT into :init_valueAMPEPCNT from perm.recordsAMPEP3; 151 where file_id = 'EFTAMPNZ'; WARNING: This SAS global statement is not supported in PROC SQL. It has been ignored. 152 quit;   I am wanting a clean run of RC=0.   Referring to documentation on the internet I think our version of SQL may not support this representation (with the colon  :🙂 to signify a macro variable).   I'm wondering if there is an alternative way of coding this short of not using SQL at all and going with SAS code only. ... View more