BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
noemi_b
Obsidian | Level 7
 
 

 Hi all,

I am using SAS University Edition v.9.4.


I have this error coming out everytime I try to perform the following code- that is, a simple outliers detection with residuals. I know lots of you will tell me that it is due to the file size. However, I tried to run exactly the same code yesterday and it was working. What happened today?

 

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
61
62 proc reg data=churn.bank_churn PLOTS(MAXPOINTS=none);
63 model churn= Address_id_Ano
64 Customer_id_Ano
65 Distance_Closest_branch
66 Distance_home_branch
67 Earning_Cust12M
68 Earning_Fam12M
69 LTV_current
70 Latitude_Ano
71 Longitude_Ano
72 Month
73 RD_CUST_YEARS
74 RD_RESTGLD
75 Teller_trans_3m_last
76 account_basic_sum
77 account_save
78 account_save_transaction
79 account_savings_volume
80 atm_transaction
81 basic_bank_attrdb
82 basic_bank_attrkr
83 basic_bank_bal_ult
84 basic_bank_crbal_avg
85 basic_bank_crbal_max
86 basic_bank_crbal_min
87 basic_bank_days_cr
88 basic_bank_days_db
89 basic_bank_dball_max
90 basic_bank_dbbal_avg
91 basic_bank_dbbal_max
92 basic_bank_dbbal_min
93 basic_bank_dbomakbas
94 basic_bank_kromakbas
95 basic_bank_utilized
96 basic_banking
97 credit_card
98 credit_card_transaction
99 csi
100 customer_age
101 customer_status_Numeric
102 customer_trans_count
103 day_to_day_finance
104 dialogue_with_advisor
105 ebank_0
106 family_id_Ano
107 first_account_open
108 home_finance
109 insurance
110 investments
111 loan_home
112 loan_home_volume
113 logons
114 meeting_n
115 meeting_with_client
116 num_adults
117 num_kids
118 overdraft_facility_sum
119 pension
120 personal_lending
121 savings
122 secure_message_sent
123 teller_dialogue
124 volume_investments
125 volume_loans
126 volume_pension_lifeins
127 volume_savings ;
128 output out=outliers.bank_outliers_r (keep= churn Address_id_Ano
129 Customer_id_Ano
130 Distance_Closest_branch
131 Distance_home_branch
132 Earning_Cust12M
133 Earning_Fam12M
134 LTV_current
135 Latitude_Ano
136 Longitude_Ano
137 Month
138 RD_CUST_YEARS
139 RD_RESTGLD
140 Teller_trans_3m_last
141 account_basic_sum
142 account_save
143 account_save_transaction
144 account_savings_volume
145 atm_transaction
146 basic_bank_attrdb
147 basic_bank_attrkr
148 basic_bank_bal_ult
149 basic_bank_crbal_avg
150 basic_bank_crbal_max
151 basic_bank_crbal_min
152 basic_bank_days_cr
153 basic_bank_days_db
154 basic_bank_dball_max
155 basic_bank_dbbal_avg
156 basic_bank_dbbal_max
157 basic_bank_dbbal_min
158 basic_bank_dbomakbas
159 basic_bank_kromakbas
160 basic_bank_utilized
161 basic_banking
162 churn
163 credit_card
164 credit_card_transaction
165 csi
166 customer_age
167 customer_status_Numeric
168 customer_trans_count
169 day_to_day_finance
170 dialogue_with_advisor
171 ebank_0
172 family_id_Ano
173 first_account_open
174 home_finance
175 insurance
176 investments
177 loan_home
178 loan_home_volume
179 logons
180 meeting_n
181 meeting_with_client
182 num_adults
183 num_kids
184 overdraft_facility_sum
185 pension
186 personal_lending
187 savings
188 secure_message_sent
189 teller_dialogue
190 volume_investments
191 volume_loans
192 volume_pension_lifeins
193 volume_savings r) rstudent=r;
194 run;
 
ERROR: Insufficient space in file WORK._DOCTMP000000000000000000003.DATA.
ERROR: No observations have been read from data set WORK._DOCTMP000000000000000000003.
ERROR: No observations have been read from data set .' WORK.SASTMP-00000001303DATA
DATA3.ITEMSTOR is in use by you in resource environment __ODS_DOCMAN.`z��
@�A�����ȩ����z����z���'n.
ERROR: No observations have been read from data set .' WORK.SASTMP-00000001303DATA
DATA3.ITEMSTOR is in use by you in resource environment __ODS_DOCMAN.`z��
@�A�����ȩ����z����z���'n.
NOTE: The SAS System stopped processing this step because of errors.
 
WARNING: The data set OUTLIERS.DANSKE_BANK_OUTLIERS_R may be incomplete. When this step was stopped there were 0 observations and
0 variables.
WARNING: Data set OUTLIERS.DANSKE_BANK_OUTLIERS_R was not replaced because this step was stopped.
NOTE: PROCEDURE REG used (Total process time):
real time 1:16.39
cpu time 1:04.52
 
195 quit;
196
197 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
210

 

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

Yes it's due to the file size and limitations on SAS UE. Some how it doesn't seem to 'clean up' files properly if there was an interruption or the process cancelled.  You can redirect your work library to overcome this, but you may need to reinstall SAS UE first. I know someone on here managed to figure out how to clear the library but it wasn't a straightforward process. 

 

If you create a folder somewhere on your computer, you can set up a shared drive to it and then use the following code to redirect all files to the library. When a user library is defined it becomes the default library instead of WORK.

 

libname user '/folders/myshortcuts/SASTemp/';

View solution in original post

1 REPLY 1
Reeza
Super User

Yes it's due to the file size and limitations on SAS UE. Some how it doesn't seem to 'clean up' files properly if there was an interruption or the process cancelled.  You can redirect your work library to overcome this, but you may need to reinstall SAS UE first. I know someone on here managed to figure out how to clear the library but it wasn't a straightforward process. 

 

If you create a folder somewhere on your computer, you can set up a shared drive to it and then use the following code to redirect all files to the library. When a user library is defined it becomes the default library instead of WORK.

 

libname user '/folders/myshortcuts/SASTemp/';

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 1720 views
  • 1 like
  • 2 in conversation