topic Re: error; library Apple does not exist. in SAS Programming

error; library Apple does not exist.

ekim46 — Wed, 15 Apr 2020 18:30:56 GMT

I wrote the below code but got an error like 'library Apple does not exist'. It seems that the macro variable was not recognized.... could you please help me to fix the error?

%MACRO CREATE(months);

LIBNAME APPLE&months "C:\FRUITS\APPLE&&months";

DATA season&months;

SET APPLE&months..good;

RUN;

%MEND CREATE;

%CREATE;

Re: error; library Apple does not exist.

Kurt_Bremser — Wed, 15 Apr 2020 18:38:18 GMT

You only need one ampersand when addressing macro variables.

Re: error; library Apple does not exist.

ekim46 — Wed, 15 Apr 2020 18:43:47 GMT

thanks! it does not still work..can you help me what I should try?

%MACRO CREATE(months);

LIBNAME APPLE&months "C:\FRUITS\APPLE&months";

DATA season&months;

SET APPLE&months..good;

RUN;

%MEND CREATE;

%CREATE;

Re: error; library Apple does not exist.

Tom — Wed, 15 Apr 2020 18:45:51 GMT

The way you have written that macro the value passed for MONTHS can have at the most only three characters. Otherwise the libref being defined will be longer than 8 characters.

But since you did not pass any value for MONTHS that is not the cause of the error.

The extra & is probably not the issue. That will just cause SAS to convert &&MONTHS to &MONTHS so it just adds a little extra work.

Sounds like the directory you are trying to reference does not exist. Do you really have a directory named:

"C:\FRUITS\APPLE"

on the machine where your SAS code is running?

Turn on the MPRINT option to see what SAS code the macro is generating.

Re: error; library Apple does not exist.

Tom — Wed, 15 Apr 2020 18:49:07 GMT

Normally you wouldn't add anything to the libref. The libref is already a place holder that pointer to the real directory. So if you have a series of directories named : APPLEJAN, APPLEFEB, APPLEMAR you could always use the libref APPLE to point to the specific one you want to use now rather than making multiple different librefs.

Re: error; library Apple does not exist.

ekim46 — Wed, 15 Apr 2020 18:50:58 GMT

yes i have the folder.Thanks!

Re: error; library Apple does not exist.

ekim46 — Wed, 15 Apr 2020 18:51:52 GMT

oh...i see... i sincerely appreciate your help!