Error Code

[steph_]

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!

[Reeza]

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;

[steph_]

Do you know what that specific error code generally means?

I did use options mprint symbolgen;

[Reeza]

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

[Patrick]

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.