I am submitting the following code using a prompt in Enterprise Guide 7.13 HF5 being sent to process on a Solaris 64-bit 9.4M2 Unix SAS server:
%put &libby;
libname pully &libby;
The prompt appears to be resolving for the put statement but something weird is happening for the libname statement giving me the following log:
39
40 %put &libby;
"/sas/data/research/Retirement/Permanent Datasets/"
41
42 libname pully &libby;
ERROR: Libref in LIBNAME statement must be followed either by quoted string or engine name or semicolon; """ found.
ERROR: Error in the LIBNAME statement.
Can anyone explain why this is not working?
-Shaun
Thank you for the suggestions. They led me to the answer as found in another posting https://communities.sas.com/t5/SAS-Enterprise-Guide/Syntax-Error-Quotes-in-Macro-Parameter-Generated...
The solution was to add the %unquote to the code as follows:
%put &libby;
libname pully %unquote(&libby);
This is apparently due to Enterprise Guide adding something to the prompt as can be seen in another line of the log that I missed:
10 %LET libby = %nrstr(%")/sas/data/research/Retirement/Permanent Datasets/%nrstr(%");
I tried your code, and it worked fine for me.
My suspicion is that there's an unprintable character in your macro variable contents somewhere, I would suspect right after the initial double quote from what your log is saying.
Tom
Thank you for the suggestions. They led me to the answer as found in another posting https://communities.sas.com/t5/SAS-Enterprise-Guide/Syntax-Error-Quotes-in-Macro-Parameter-Generated...
The solution was to add the %unquote to the code as follows:
%put &libby;
libname pully %unquote(&libby);
This is apparently due to Enterprise Guide adding something to the prompt as can be seen in another line of the log that I missed:
10 %LET libby = %nrstr(%")/sas/data/research/Retirement/Permanent Datasets/%nrstr(%");
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.