topic Re: Error Code in New SAS User

Error Code

steph_ — Thu, 05 Aug 2021 15:24:44 GMT

Hello!

I am trying to run a code that pulls in a large amount of data from a macros statement. It's not working and I keep getting these errors

ERROR: CLI prepare error: Unable to retrieve error message. SQL statement: SELECT * FROM....

Any suggestion of how to fix this? My understanding of SAS is limited so basic language would be appreciated.

Thanks!

Re: Error Code

Reeza — Thu, 05 Aug 2021 15:28:14 GMT

Yeah, we can't help with what you've posted here either.
Please post more of the code and log.

When running macros, make sure to use the debugging options:

options mprint symbolgen;

Re: Error Code

steph_ — Mon, 09 Aug 2021 17:42:44 GMT

Do you know what that specific error code generally means?

I did use options mprint symbolgen;

Re: Error Code

Reeza — Mon, 09 Aug 2021 18:09:56 GMT

It means your SQL isn't valid typically. Since you show nothing else, I can't really guess why beyond that.

Re: Error Code

Patrick — Tue, 10 Aug 2021 04:36:53 GMT

Add the following options on the top of the code, run it and then share the SAS log with us (please as an attachment and not just copy/past into the body of the conversation).

Before attaching the log: Make sure you browse over it and remove anything confidential/internal from it.