topic Re: Getting _Temp Library Error in SAS Studio

Getting _Temp Library Error

Brownisiak69 — Thu, 01 Jun 2023 18:26:52 GMT

Hi,

I face difficulties while working on SAS Studio, when I was running a query for a particular dataset on my studio it automatically creates a _TEM Library and if I delete then it automatically increasing like _Temp1, _Temp2, _Temp3, _Temp4, etc.

Please refer to the screenshot and guide to resolve this
Thanks.

Re: Getting _Temp Library Error

Reeza — Thu, 01 Jun 2023 18:29:44 GMT

Can you please show the log? Is there anything in there about the library creation?

Re: Getting _Temp Library Error

Brownisiak69 — Thu, 01 Jun 2023 18:51:13 GMT

Thanks For your Response

I didn't find any error in log please check below logs.

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
68
69 DATA PRACTICE.diabetes_data;
70 SET PRACTICE.diabetes_data;
71 IF age LE 50;
72 RUN;

NOTE: There were 63769 observations read from the data set PRACTICE.DIABETES_DATA.
NOTE: The data set PRACTICE.DIABETES_DATA has 39342 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
user cpu time 0.00 seconds
system cpu time 0.01 seconds
memory 3554.93k
OS Memory 25256.00k
Timestamp 01/06/2023 06:38:30 PM
Step Count 96 Switch Count 4
Page Faults 0
Page Reclaims 648
Page Swaps 0
Voluntary Context Switches 80
Involuntary Context Switches 0
Block Input Operations 9984
Block Output Operations 6408

73
74 PROC PRINT DATA=PRACTICE.diabetes_data;
75 RUN;

NOTE: There were 39342 observations read from the data set PRACTICE.DIABETES_DATA.
NOTE: PROCEDURE PRINT used (Total process time):
real time 56.64 seconds
user cpu time 56.63 seconds
system cpu time 0.02 seconds
memory 2592.15k
OS Memory 23460.00k
Timestamp 01/06/2023 06:39:27 PM
Step Count 97 Switch Count 1
Page Faults 0
Page Reclaims 280
Page Swaps 0
Voluntary Context Switches 27
Involuntary Context Switches 35
Block Input Operations 6432
Block Output Operations 23480

76
77 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
87

Re: Getting _Temp Library Error

ballardw — Thu, 01 Jun 2023 19:59:13 GMT

This code:

69 DATA PRACTICE.diabetes_data;
70 SET PRACTICE.diabetes_data;
71 IF age LE 50;
72 RUN;

Should completely replace the Practice.diabetes_data. If you get a log like this when rerunning the code:

NOTE: There were 63769 observations read from the data set PRACTICE.DIABETES_DATA.
NOTE: The data set PRACTICE.DIABETES_DATA has 39342 observations and 9 variables.

Then there is a lot you are not sharing. The second time you would have 38342 in the "read from" part of the log. If you don't then likely your issue is from a different part of your code.

The times I have seen _temp libraries like that created are when doing something like clicking on a SAS data set file from outside of SAS. When a file is associated with SAS then a library is created is by SAS so that it can use that set. To create multiple libraries in the same session just click on the same set repeatedly without closing SAS.

When you close the SAS session the libraries should go away.

Re: Getting _Temp Library Error

Reeza — Thu, 01 Jun 2023 20:24:02 GMT

Good call, I get that when I open a data set through the Servers Files and Folders pane, not the library pane!