topic Re: My dataset do not get stored in the permanent library i created in New SAS User

My dataset do not get stored in the permanent library i created

Banke — Tue, 07 Sep 2021 18:24:58 GMT

Hello SAS community,

i observed that despite suceesfully creating a permanent library for my dataset (the file gets saved in it too), when i work with the dataset e.g keep only some variables, my new dataset gets stored in the work folder and not my permanent library. What can i do please?

this is the program i used to create a new library

*CONVERTING MEPS DATA TO SAS FORMAT;
LIBNAME WEEK2 'C:\Users\HP SPECTRE\Documents\My SAS work\MEPS15';
FILENAME HI81 'C:\Users\HP SPECTRE\Documents\My SAS work\H181SSP\H181.SSP';
PROC XCOPY IN=HI81 OUT=WEEK2 IMPORT;
RUN;

after this, the data H181 appears in my WEEK2 folder in SAS but if i work on the file

e.g keep so variables

DATA KEEP;
SET WEEK2.H181;
KEEP dupersid age15x sex region15 racethx cpsfamid famid15;
RUN;

the output is saved in my work folder not the WEEK2 library, this is the log:

DATA KEEP;
548 SET WEEK2.H181;
549 KEEP dupersid age15x sex region15 racethx cpsfamid famid15;
550 RUN;

NOTE: There were 35427 observations read from the data set WEEK2.H181.
NOTE: The data set WORK.KEEP has 35427 observations and 7 variables.
NOTE: DATA statement used (Total process time):
real time 0.51 seconds
cpu time 0.37 seconds

i expect that it should get saved in the WEEK2 library i created, not the work folder.

can anyone please help with this?
thanks

Re: My dataset do not get stored in the permanent library i created

PaigeMiller — Tue, 07 Sep 2021 18:37:46 GMT

To save a data set in the WEEK2 library, you need to use a two-part name, with WEEK2. as the first part.

So you want to start the DATA step with

DATA WEEK2.KEEP;

Re: My dataset do not get stored in the permanent library i created

Banke — Wed, 08 Sep 2021 01:23:14 GMT

thank you, it worked

however when i closed the SAS session and reopened my folder was no longer there.

can you please share a simple SAS program to save a large excel file permanently?

thanks

Re: My dataset do not get stored in the permanent library i created

Kurt_Bremser — Wed, 08 Sep 2021 08:16:24 GMT

You need to run the LIBNAME statement every time you started a new SAS session.

To avoid this, you need to include the LIBNAME in your autoexec (autoexec code in Enterprise Guide or SAS Studio, or autoexec.sas file of the SAS installation itself).

Re: My dataset do not get stored in the permanent library i created

Banke — Wed, 08 Sep 2021 16:05:22 GMT

Thanks, how can i do this please? include the libname in autoexec.sas file of the SAS installation itself?

Re: My dataset do not get stored in the permanent library i created

Kurt_Bremser — Wed, 08 Sep 2021 16:53:31 GMT

Where you put it depends on the way you use SAS.

Is it a single-workstation setup on Windows, or a client-server setup?

If the latter, how do you access it, with Enterprise Guide or SAS Studio?

And it is impirtant to know the scope where the library should be available. All users, or just you? And for just a single project, or every time SAS is used?

Re: My dataset do not get stored in the permanent library i created

Banke — Wed, 08 Sep 2021 17:07:48 GMT

it is a single-workstation setup on Windows, i installed it. my university has the license

i work directly on it. i have attached a snapshot of the interface. i am not sure whether it is studio or enterprise guide

i am the only user and i use it for my class projects

Re: My dataset do not get stored in the permanent library i created

Kurt_Bremser — Wed, 08 Sep 2021 19:04:21 GMT

You would know if you used Enterprise Guide, because you would start that application, not SAS itself.

So I take it you use the native Display Manager UI, and simply start SAS 9.4.

You can locate the autoexec.sas file in the SAS installation directory and insert the LIBNAME statement there.

Re: My dataset do not get stored in the permanent library i created

Banke — Wed, 08 Sep 2021 20:36:58 GMT

Thank you. this is what my interface looks like

Re: My dataset do not get stored in the permanent library i created

Banke — Wed, 08 Sep 2021 20:39:34 GMT

MY APP IS SAS 9.4 (UNICODE SUPPORT)

Re: My dataset do not get stored in the permanent library i created

SASKiwi — Wed, 08 Sep 2021 20:42:12 GMT

You are using the SAS Windowing Environment, not SAS Enterprise Guide or SAS Studio.

Re: My dataset do not get stored in the permanent library i created

Banke — Wed, 08 Sep 2021 20:43:48 GMT

is SAS studio or enterprise easier to use? i am a new SAS user and encountering lots of issues

Re: My dataset do not get stored in the permanent library i created

Kurt_Bremser — Thu, 09 Sep 2021 05:36:50 GMT

If Enterprise Guide is included in your package, I would use it. The wizards for most procedures are quite handy to explore the procedures. It also allows selective "autoexec" code (sent before every submission, when a project is opened, or when a connection to a SAS process is established).

Re: My dataset do not get stored in the permanent library i created

Kurt_Bremser — Thu, 09 Sep 2021 05:43:18 GMT

Right-click on the app icon, and select Properties. Then you can see the complete command used to start the SAS session.

Usually, this command has a -autoexec option that contains the path to the autoexec.sas file, where you can insert the statement.