topic HOW TO CREATE A USER DEFINED LIBRARY AND KEEP USING IT WITHOUT REFERENCING IT EACH TIME IN THE CODE in New SAS User

HOW TO CREATE A USER DEFINED LIBRARY AND KEEP USING IT WITHOUT REFERENCING IT EACH TIME IN THE CODE

d6k5d3 — Wed, 17 Apr 2019 05:13:26 GMT

I am sorry for coming up with this most basic question. So far I have been working with Work library because of which I have not bothered about creating my own library. However, my recent codes take a long time to execute because of the volume of data, and each time I open SAS I need to run them all.

So my question is after creating my library by

LIBNAME ZZZ 'mydata/myfile/...';

what should I do so that I don't need to write 'ZZZ' in my code over and over again. For example:

PROC IMPORT DATA= ZZZ.YYY...

Thus I will have reference ZZZ every time. I want to get rid of this referencing.

Much thanks. Regards.

Re: HOW TO CREATE A USER DEFINED LIBRARY AND KEEP USING IT WITHOUT REFERENCING IT EACH TIME IN THE C

Kurt_Bremser — Wed, 17 Apr 2019 06:26:43 GMT

The only library you do not need to reference is WORK. Anytime you use a one-level dataset name, it will automatically be assumed to be in WORK.

All other libraries have to be explicitly named.

If you want library names to be dynamic, you can use a macro variable, so you need to change the name in only one place in your code.

Re: HOW TO CREATE A USER DEFINED LIBRARY AND KEEP USING IT WITHOUT REFERENCING IT EACH TIME IN THE C

PaigeMiller — Wed, 17 Apr 2019 12:18:16 GMT

Your question and your example don't seem to fit together.

To create a user defined library and have it available every single time you launch SAS, put the LIBNAME statement in your AUTOEXEC file.

However,

PROC IMPORT DATA= ZZZ.YYY...

is invalid syntax and does not fit with the title, because PROC IMPORT must point (with the DATAFILE= option, not the DATA= option which does not exist) to an actual file and not to a SAS data set, so a libname is not needed for this; you need an actual file name that DATAFILE= points to. You could use a macro variable here, said macro variable could be defined in your AUTOEXEC.

Re: HOW TO CREATE A USER DEFINED LIBRARY AND KEEP USING IT WITHOUT REFERENCING IT EACH TIME IN THE C

Ksharp — Wed, 17 Apr 2019 13:15:04 GMT

options user= 'mydata/myfile/...';


/*Then no need ZZZ. */

PROC IMPORT DATA= YYY...