topic Re: WARNING: This SAS global statement is not supported in PROC SQL. It has been ignored. in SAS Programming

WARNING: This SAS global statement is not supported in PROC SQL. It has been ignored.

clmeyer — Wed, 20 Feb 2019 22:06:25 GMT

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.

Re: WARNING: This SAS global statement is not supported in PROC SQL. It has been ignored.

PGStats — Wed, 20 Feb 2019 22:08:48 GMT

remove the semicolon before the where clause.

Re: WARNING: This SAS global statement is not supported in PROC SQL. It has been ignored.

novinosrin — Wed, 20 Feb 2019 22:09:03 GMT

Are you sure whether your proc sql syntax is correct, i see one error

select TOTAL_CR_CNT into :init_valueAMPEPCNT from perm.recordsAMPEP3; /*shouldn't be semicolon here*/

The syntax should ideally be



proc sql;

select TOTAL_CR_CNT into :init_valueAMPEPCNT from perm.recordsAMPEP3

where file_id = 'EFTAMPNZ';

quit;

Re: WARNING: This SAS global statement is not supported in PROC SQL. It has been ignored.

novinosrin — Wed, 20 Feb 2019 22:09:44 GMT

Oops sorry sir @PGStats for the duplication. I didn;t see your post.

Re: WARNING: This SAS global statement is not supported in PROC SQL. It has been ignored.

clmeyer — Wed, 20 Feb 2019 22:19:40 GMT

Removed the semi-colon and it worked!!! Thanks very much for a quick response.