topic Re: How to assign permanent lib and use SET statement.. in SAS Programming

How to assign permanent lib and use SET statement..

zhangyu027 — Tue, 19 Mar 2019 20:26:51 GMT

May I ask how to assign a permanent lib to data? Thanks.

Re: How to assign permanent lib and use SET statement..

PeterClemmensen — Tue, 19 Mar 2019 20:32:59 GMT

Welcome to the SAS Communities 🙂

What version of SAS do you use?

Re: How to assign permanent lib and use SET statement..

PeterClemmensen — Tue, 19 Mar 2019 20:38:41 GMT

If you are on 9.x, then click the 'New Library' Button at the top ribbon to get the below window. Then choose the 'Enable at startup' box and fill in the rest accordingly.

Re: How to assign permanent lib and use SET statement..

Nasya — Tue, 19 Mar 2019 20:40:00 GMT

Hi,

The following is an example of the LIBNAME statement and SET statement that is used with a DATA step:

libname pdata 'your-data-library';  
data ds1; 
   set pdata;
   by ID;
run;

proc print data = ds1; 
run;

Here, PDATA,DS1 and ID are used generically.

Hope this helps.

Regards,

Nasya

Re: How to assign permanent lib and use SET statement..

SharonZS — Tue, 19 Mar 2019 21:33:36 GMT

Hi,

In order to create and save a permanent SAS data file in a library you'll want to use the following syntax:

libname pdata 'your-data-library'; /*Path for where you want to store data set/where your data is located*/

data pdata.ds1; /* New permanent SAS data file stored in pdata library. */

set ds1; /* temporary SAS data file*/
run;

Re: How to assign permanent lib and use SET statement..

Kurt_Bremser — Wed, 20 Mar 2019 07:50:55 GMT

You define the library reference with a libname statement. In order for a library to be "permanent" (available for use everytime a new SAS session starts), you need to have it somewhere in the structures that could be called "part of the autoexec process". Depending on your SAS setup, this could be

a statement in one of the autoexec.sas files that are called when the SAS session starts. A BI Server has multiple such files with inheritance.
a definition in SAS metadata (in a BI Server environment).
a statement executed whenever you connect to a SAS server from Enterprise Guide.
a statement executed whenever code is sent to the SAS server.
a statement in an "Autoexec" process flow in a SAS Enterprise Guide project file.

(this list is not complete by far)

Re: How to assign permanent lib and use SET statement..

andreas_lds — Wed, 20 Mar 2019 07:54:58 GMT

@Nasya: two errors in your code:
"Set psdata" references the dataset psdata in the work library.
"data = ds1" also processes work.ds1.