Getting _Temp Library Error

[Brownisiak69]

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.

[Reeza]

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

[Brownisiak69]

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

[ballardw]

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.

[Reeza]

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