topic Re: Libname Not Resolving Using Enterprise Guide Prompt in SAS Enterprise Guide

Libname Not Resolving Using Enterprise Guide Prompt

ICI_SAS_Admins — Thu, 30 Nov 2017 15:54:46 GMT

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

Re: Libname Not Resolving Using Enterprise Guide Prompt

TomKari — Thu, 30 Nov 2017 16:07:02 GMT

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

Re: Libname Not Resolving Using Enterprise Guide Prompt

ICI_SAS_Admins — Thu, 30 Nov 2017 19:00:15 GMT

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-by-EG-Prompt/td-p/394370

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(%");