topic Re: proc sql giving error in SAS Programming

proc sql giving error

Aexor — Thu, 05 Jan 2023 20:07:02 GMT

Hi All,

Need help in below query. I am trying to create a macro in pass through query

proc sql;
connect to POSTGRES as ab(user="xxxx" password="abcde" );
select dim_cnt into :dimcnt from connection to ab
(select count(dimcnt) as dim_cnt from lib.tab);
disconnect from ef;
quit;
%put &dimcnt;

library connection worked but getting syntax error like below. Please help me in resolving this query

ERROR 79-322: Expecting a (.

84 disconnect from ef;
----------------------------------------------------
217
ERROR 217-322: Invalid statement due to first character being unprintable (hexadecimal representation:
C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0C2A0).
85 quit;

Re: proc sql giving error

PaigeMiller — Thu, 05 Jan 2023 19:13:38 GMT

Please show us the ENTIRE log for this PROC SQL. Please copy the log as text and paste it into the window that appears when you click on the </> icon.

Re: proc sql giving error

SASKiwi — Thu, 05 Jan 2023 19:59:28 GMT

Try removing your DISCONNECT statement. Looks like it contains an unprintable character typo. SAS will disconnect automatically with the QUIT statement anyway.

Re: proc sql giving error

ballardw — Thu, 05 Jan 2023 20:04:44 GMT

Unprintable character might be something that you didn't see when copy/paste from another document.

I would try deleting everything on the line before the "disconnect from ef;" If you still that error then delete everything to the semicolon on the previous line in case the offensive character(s) are appearing at the end of that line as well.

As may have been pointed out previously, the main message windows on this forum reformat text. So if you want us to actually see what was in your code or your log you need to open a text box using the </> icon above the message window and paste the text.

Re: proc sql giving error

Tom — Thu, 05 Jan 2023 20:30:19 GMT

'A0'x is a "non-breaking" space.

'C2A0'x is the same character in UTF-8 encoding.

Replace them with actual spaces instead. And actual space is '20'x .

Re: proc sql giving error

Reeza — Thu, 05 Jan 2023 20:41:50 GMT

This type of error can happen if you copy and paste the code from a browser or formatted document to a text file.