topic Re: Defining Libraries one time in a sas file with multiple pograms. in SAS Programming

Defining Libraries one time in a sas file with multiple pograms.

seamoh — Sat, 30 May 2020 00:15:14 GMT

Hi all of my friends, hope all of you are very well. I have one sas file with multiple program and I need the following programs for every of my program written in it.

libname Learn '/folders/myfolders/60864_example/Learning';
libname CharData '/folders/myfolders/Dataset/CharDataset';

libname Learn '/folders/myfolders/60864_example/Learning';
libname CharData '/folders/myfolders/Dataset/CharDataset';

libname Learn '/folders/myfolders/60864_example/Learning';
libname CharData '/folders/myfolders/Dataset/CharDataset';

Then for each program I have to put these two libraries above the program for example

"libname Learn '/folders/myfolders/60864_example/Learning';"
"libname CharData '/folders/myfolders/Dataset/CharDataset';"
"proc print data=Learn.phone obs='5';"
run;

I would like to define these two libraries once at the top of the sas file and it would work for all the program written in that file.

Thank you very much, I am looking forward for your descent answers.

Re: Defining Libraries one time in a sas file with multiple pograms.

ghosh — Sat, 30 May 2020 00:45:37 GMT

check out this paper

https://pauldickman.com/sastips/autocall/

Re: Defining Libraries one time in a sas file with multiple pograms.

seamoh — Sat, 30 May 2020 20:29:59 GMT

Hi and ghosh, and thank you very much for the reply

what is your idea about this

libname Learn '/folders/myfolders/60864_example/Learning';
options fmtsearch=(learn);

I put these two lines of cose at the first of the sas files and run it once and I think it works for the rest of the programs on the file.

Please tell me your idea ,

Thank you very much

Re: Defining Libraries one time in a sas file with multiple pograms.

ghosh — Sat, 30 May 2020 20:35:59 GMT

You can write your libname as follows:

libname Learn '~/60864_example/Learning';

This was your code is portable assuming the /60864_example/Learning part of your folder is the same on the other computer

Re: Defining Libraries one time in a sas file with multiple pograms.

PaigeMiller — Sat, 30 May 2020 21:19:46 GMT

Put these LIBNAME statements into your AUTOEXEC file and then you don't even need them at the top of each program you write.

Re: Defining Libraries one time in a sas file with multiple pograms.

seamoh — Sat, 30 May 2020 22:44:09 GMT

Hello PageMiller, this is what ghosh suggest me in his first reply. would you please tell me where may I find the Autoexec file? Thank you again PageMiller and ghosh, deeply appreciated of both of you my friends.

Re: Defining Libraries one time in a sas file with multiple pograms.

ghosh — Sat, 30 May 2020 22:55:23 GMT

looks like you are using SAS UE. On the top right of the screen there is a menu before the ?

you can edit the autoexec.sas from there

Re: Defining Libraries one time in a sas file with multiple pograms.

PaigeMiller — Sat, 30 May 2020 23:02:08 GMT

In SAS, run this command

%put %sysfunc(getoption(autoexec));