I received the error message "ERROR: Expected open parenthesis after macro function name not found" very randomly. I have no macro functions in my code, at all. I checked and I had a couple "%" in some of my comments that I was keeping notes in, but since they were commented out SAS shouldn't have touched that.
I was importing another file and then ran my whole program and got this message. Now none of my code is running, even simple LIBNAME statements. I tried closing the program and reopening it and that didn't work. What is happening??
Here is the import code I ran if that is relevant at all:
PROC IMPORT
DATAFILE= " .csv"
OUT= Capimpt.Workingdata
REPLACE
DBMS= CSV;
GUESSINGROWS= 3000;
RUN;
Without you sharing the SAS code and SAS log there isn't much we can say.
IF you share a SAS log then please from a new SAS session so that no "left-overs" impact the result.
In case your actual code really looks like above then that wouldn't work.
It doesn't actually look like that, I had to censor the pathway name due to HIPAA restrictions. I've tried it with multiple lines of code. This is what I get each time. This specific example is from my first line of code (the X's are indicating censored info, hopefully that makes it more clear, it's nothing different from a normal LIBNAME statement)
LIBNAME CapSrc "XXXXXXXXXXXXXXx";
Restart your SAS session. Something has rendered unstable. That "something" is likely what ever triggered SAS to think you have a macro function call somewhere.
When you run code and nothing happens, then SAVE the code and restart SAS as the program is not unstable.
Without an exact example of the comment you mentioned with a % can't say if that was the issue.
If your file names or paths have % or & characters then that is suboptimal and you should consider removing them.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.