topic Re: Help with macro error in SAS Programming

Help with macro error

sasgorilla — Fri, 14 Mar 2025 02:39:22 GMT

When I run a proc arima it works fine. See log below.

When I run as a macro, it doesn't. I can't figure out why...

Here is the macro:

Here is the error when I run the macro.

Any ideas why this is happening?

Re: Help with macro error

ballardw — Fri, 14 Mar 2025 05:21:54 GMT

Please, please, PLEASE paste log and code entries as text in text boxes opened on the forum with the </> icon that appears above the main message windows.

It is quite often much easier to COPY - Edit - Paste suggested fixes to code. The more stuff that requires typing from scratch the less likely you are to get complete working code.

When debugging MACRO generated code then set OPTIONS MPRINT; before running the macro.

In this case, you have placed the value of the Type variable in the WHERE statement inside single quotes. Macro variables inside single quotes do not resolve at all. You must use double quotes

where type = "&type";

Re: Help with macro error

sasgorilla — Fri, 14 Mar 2025 05:39:27 GMT

Thank you!

And sorry about the images! I was working in an external environment without online access and where I could not copy and paste the code.