BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I have come up against a problem that seems to have vexed other users
in the past and I was wondering if anyone had any new insights into a
solution.

The problem occurs when I am sorting a dataset that I have created in a previous DATA step. I am using the temporary WORK directory; I have not checked if the problem also occurs with a permanent directory. The sort will sometimes succeed but will sometimes fail with a message like

ERROR: Rename of temporary member for WORK.DONCOMP.DATA failed.
File may be found in C:\Users\rperry\AppData\Local\Temp\SAS Temporary
Files\_TD3956.

The file is still present in the SAS Temporary Files directory under the name "doncomp.sas7bdat.lck"

If I rerun the DATA step creating the DONCOMP file, it executes normally and the file is now back in the work directory as "doncomp.sas7bdat" (no "lck" suffix)

I am running SAS v9.1.3 SP4 (hotfix bundle E9BX04) under Windows Vista Business SP1, with 100 MB free on my HD, a 2.2 GHz Intel Duo processor and 4 GB RAM. The folder (SAS Temporary Files) has no locks on it as far as I can tell with folder properties. I am not working on a network nor accessing files over a network.

I have used a work-around suggested in another (non-SAS) forum: use the OUT= option with PROC SORT. With that, the code runs without errors.

I am curious why this error occurs as I have used SAS under various versions of Windows for >10y and do not recall such an error occurring in the past. Perhaps a resent hotfix bundle? (the latest is E9BX04, applied on Dec 29) SP4 was applied some weeks ago and PROC SORT worked without OUT=
without errors up until yesterday (Dec 30 2008).
Thanks
R Perry
23 REPLIES 23
Cynthia_sas
SAS Super FREQ
Hi:
If you go to support.sas.com and type this string in the search box at the top, right side of the web page (above the blue banner):
rename of temporary member failed

You will find that the first 4 or 5 hits are directly addressing this specific error message.

cynthia
deleted_user
Not applicable
Thanks for the reply. Before posting, I did the search you wisely suggested. However, the replies refer to working in networked environments, when disk space is low, or when a second certain software program is installed.

Please note that the problem occurs when working in a non-network environment (both SAS and the data folders exist on my C drive, the data folder has no limits to read or write access), with 100 GB free on my hard drive (recently defragmented) and the programs mentioned are not installed.

I therefore look forward to any insights that people might have into this problem and how to resolve it.
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Suggest you share a detailed SASLOG output with the DATA / PROC step(s) leading up to the error, to include the step that creates your SAS data file in question. You will want to ensure that all SAS source program (code) is visible in your posted SASLOG output for the forum subscribers' responses.

Scott Barry
SBBWorks, Inc.
Doc_Duke
Rhodochrosite | Level 12
Sometimes the free disk space can be deceptive. A simple sort requires over 4x the disk space of the original data set:

http://support.sas.com/kb/15/065.html

A long SAS job with lots of work data sets can eat up a lot of disk space; since the WORK library gets cleaned up when you exit SAS, you don't know the space that was being used.

You might want to try using the TAGSORT option. It requires one extra read of the dataset, but uses much less disk space.

That HotFix bundle is also just two weeks old, so it may have introduced that error as a side effect. It's rare with SAS, but I have had it happen.
deleted_user
Not applicable
Thanks to everyone for their comments. Here is an example of what is happening.

The log shows a lot of imports of smallish files, manipulations and concatenation of these files, and several sorts. Some sorts worked, others did not.

Best regards and bonne annee,
R Perry

1 PROC IMPORT OUT= WORK.GUE2001
2 DATAFILE= "C:\DonComp\GUE\Données de Consultation Externe District Guediawaye 2001
2 ! à 2007.xls"
3 DBMS=EXCEL REPLACE;
4 SHEET="'2001$'";
5 GETNAMES=YES;
6 MIXED=NO;
7 SCANTEXT=YES;
8 USEDATE=YES;
9 SCANTIME=YES;
10 RUN;

NOTE: WORK.GUE2001 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.43 seconds
cpu time 0.14 seconds


11
12 PROC IMPORT OUT= WORK.GUE2002
13 DATAFILE= "C:\DonComp\GUE\Données de Consultation Externe District Guediawaye 2001
13 ! à 2007.xls"
14 DBMS=EXCEL REPLACE;
15 SHEET="'2002$'";
16 GETNAMES=YES;
17 MIXED=NO;
18 SCANTEXT=YES;
19 USEDATE=YES;
20 SCANTIME=YES;
21 RUN;

NOTE: WORK.GUE2002 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.31 seconds
cpu time 0.12 seconds


22
23 PROC IMPORT OUT= WORK.GUE2003
24 DATAFILE= "C:\DonComp\GUE\Données de Consultation Externe District Guediawaye 2001
24 ! à 2007.xls"
25 DBMS=EXCEL REPLACE;
26 SHEET="'2003$'";
27 GETNAMES=YES;
28 MIXED=NO;
29 SCANTEXT=YES;
30 USEDATE=YES;
31 SCANTIME=YES;
32 RUN;

NOTE: WORK.GUE2003 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.42 seconds
cpu time 0.10 seconds


33
34 PROC IMPORT OUT= WORK.GUE2004
35 DATAFILE= "C:\DonComp\GUE\Données de Consultation Externe District Guediawaye 2001
35 ! à 2007.xls"
36 DBMS=EXCEL REPLACE;
37 SHEET="'2004$'";
38 GETNAMES=YES;
39 MIXED=NO;
40 SCANTEXT=YES;
41 USEDATE=YES;
42 SCANTIME=YES;
43 RUN;

NOTE: WORK.GUE2004 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.31 seconds
cpu time 0.10 seconds


44
45 PROC IMPORT OUT= WORK.GUE2005
46 DATAFILE= "C:\DonComp\GUE\Données de Consultation Externe District Guediawaye 2001
46 ! à 2007.xls"
47 DBMS=EXCEL REPLACE;
48 SHEET="'2005$'";
49 GETNAMES=YES;
50 MIXED=NO;
51 SCANTEXT=YES;
52 USEDATE=YES;
53 SCANTIME=YES;
54 RUN;

NOTE: WORK.GUE2005 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.31 seconds
cpu time 0.12 seconds


55
56 PROC IMPORT OUT= WORK.GUE2006
57 DATAFILE= "C:\DonComp\GUE\Données de Consultation Externe District Guediawaye 2001
57 ! à 2007.xls"
58 DBMS=EXCEL REPLACE;
59 SHEET="'2006$'";
60 GETNAMES=YES;
61 MIXED=NO;
62 SCANTEXT=YES;
63 USEDATE=YES;
64 SCANTIME=YES;
65 RUN;

NOTE: WORK.GUE2006 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.31 seconds
cpu time 0.12 seconds


66
67 PROC IMPORT OUT= WORK.GUE2007
68 DATAFILE= "C:\DonComp\GUE\Données de Consultation Externe District Guediawaye 2001
68 ! à 2007.xls"
69 DBMS=EXCEL REPLACE;
70 SHEET="'2007$'";
71 GETNAMES=YES;
72 MIXED=NO;
73 SCANTEXT=YES;
74 USEDATE=YES;
75 SCANTIME=YES;
76 RUN;

NOTE: WORK.GUE2007 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.40 seconds
cpu time 0.11 seconds


77
78 PROC IMPORT OUT= WORK.GUEH2001
79 DATAFILE= "C:\DonComp\GUE\Malades Hospitalisés Districts Guediawaye 2001 à
79 ! 2007.xls"
80 DBMS=EXCEL REPLACE;
81 SHEET="'2001$'";
82 GETNAMES=YES;
83 MIXED=NO;
84 SCANTEXT=YES;
85 USEDATE=YES;
86 SCANTIME=YES;
87 RUN;

NOTE: WORK.GUEH2001 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.31 seconds
cpu time 0.12 seconds


88
89 PROC IMPORT OUT= WORK.GUEH2002
90 DATAFILE= "C:\DonComp\GUE\Malades Hospitalisés Districts Guediawaye 2001 à
90 ! 2007.xls"
91 DBMS=EXCEL REPLACE;
92 SHEET="'2002$'";
93 GETNAMES=YES;
94 MIXED=NO;
95 SCANTEXT=YES;
96 USEDATE=YES;
97 SCANTIME=YES;
98 RUN;

NOTE: WORK.GUEH2002 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.31 seconds
cpu time 0.11 seconds


99
100 PROC IMPORT OUT= WORK.GUEH2003
101 DATAFILE= "C:\DonComp\GUE\Malades Hospitalisés Districts Guediawaye 2001 à
101! 2007.xls"
102 DBMS=EXCEL REPLACE;
103 SHEET="'2003$'";
104 GETNAMES=YES;
105 MIXED=NO;
106 SCANTEXT=YES;
107 USEDATE=YES;
108 SCANTIME=YES;
109 RUN;

NOTE: WORK.GUEH2003 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.37 seconds
cpu time 0.07 seconds


110
111 PROC IMPORT OUT= WORK.GUEH2004
112 DATAFILE= "C:\DonComp\GUE\Malades Hospitalisés Districts Guediawaye 2001 à
112! 2007.xls"
113 DBMS=EXCEL REPLACE;
114 SHEET="'2004$'";
115 GETNAMES=YES;
116 MIXED=NO;
117 SCANTEXT=YES;
118 USEDATE=YES;
119 SCANTIME=YES;
120 RUN;

NOTE: WORK.GUEH2004 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.31 seconds
cpu time 0.07 seconds


121
122 PROC IMPORT OUT= WORK.GUEH2005
123 DATAFILE= "C:\DonComp\GUE\Malades Hospitalisés Districts Guediawaye 2001 à
123! 2007.xls"
124 DBMS=EXCEL REPLACE;
125 SHEET="'2005$'";
126 GETNAMES=YES;
127 MIXED=NO;
128 SCANTEXT=YES;
129 USEDATE=YES;
130 SCANTIME=YES;
131 RUN;

NOTE: WORK.GUEH2005 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.43 seconds
cpu time 0.10 seconds


132
133 PROC IMPORT OUT= WORK.GUEH2006
134 DATAFILE= "C:\DonComp\GUE\Malades Hospitalisés Districts Guediawaye 2001 à
134! 2007.xls"
135 DBMS=EXCEL REPLACE;
136 SHEET="'2006$'";
137 GETNAMES=YES;
138 MIXED=NO;
139 SCANTEXT=YES;
140 USEDATE=YES;
141 SCANTIME=YES;
142 RUN;

NOTE: WORK.GUEH2006 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.35 seconds
cpu time 0.12 seconds


143
144 PROC IMPORT OUT= WORK.GUEH2007
145 DATAFILE= "C:\DonComp\GUE\Malades Hospitalisés Districts Guediawaye 2001 à
145! 2007.xls"
146 DBMS=EXCEL REPLACE;
147 SHEET="'2007$'";
148 GETNAMES=YES;
149 MIXED=NO;
150 SCANTEXT=YES;
151 USEDATE=YES;
152 SCANTIME=YES;
153 RUN;

NOTE: WORK.GUEH2007 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.29 seconds
cpu time 0.12 seconds


154
155 PROC IMPORT OUT= WORK.GUED2001
156 DATAFILE= "C:\DonComp\GUE\DECES en Hospitalisation District Guediawaye 2001 à
156! 2007.xls"
157 DBMS=EXCEL REPLACE;
158 SHEET="'2001$'";
159 GETNAMES=YES;
160 MIXED=NO;
161 SCANTEXT=YES;
162 USEDATE=YES;
163 SCANTIME=YES;
164 RUN;

NOTE: WORK.GUED2001 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.31 seconds
cpu time 0.10 seconds


165
166 PROC IMPORT OUT= WORK.GUED2002
167 DATAFILE= "C:\DonComp\GUE\DECES en Hospitalisation District Guediawaye 2001 à
167! 2007.xls"
168 DBMS=EXCEL REPLACE;
169 SHEET="'2002$'";
170 GETNAMES=YES;
171 MIXED=NO;
172 SCANTEXT=YES;
173 USEDATE=YES;
174 SCANTIME=YES;
175 RUN;

NOTE: WORK.GUED2002 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.31 seconds
cpu time 0.10 seconds


176
177 PROC IMPORT OUT= WORK.GUED2003
178 DATAFILE= "C:\DonComp\GUE\DECES en Hospitalisation District Guediawaye 2001 à
178! 2007.xls"
179 DBMS=EXCEL REPLACE;
180 SHEET="'2003$'";
181 GETNAMES=YES;
182 MIXED=NO;
183 SCANTEXT=YES;
184 USEDATE=YES;
185 SCANTIME=YES;
186 RUN;

NOTE: WORK.GUED2003 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.29 seconds
cpu time 0.07 seconds


187
188 PROC IMPORT OUT= WORK.GUED2004
189 DATAFILE= "C:\DonComp\GUE\DECES en Hospitalisation District Guediawaye 2001 à
189! 2007.xls"
190 DBMS=EXCEL REPLACE;
191 SHEET="'2004$'";
192 GETNAMES=YES;
193 MIXED=NO;
194 SCANTEXT=YES;
195 USEDATE=YES;
196 SCANTIME=YES;
197 RUN;

NOTE: WORK.GUED2004 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.32 seconds
cpu time 0.09 seconds


198
199 PROC IMPORT OUT= WORK.GUED2005
200 DATAFILE= "C:\DonComp\GUE\DECES en Hospitalisation District Guediawaye 2001 à
200! 2007.xls"
201 DBMS=EXCEL REPLACE;
202 SHEET="'2005$'";
203 GETNAMES=YES;
204 MIXED=NO;
205 SCANTEXT=YES;
206 USEDATE=YES;
207 SCANTIME=YES;
208 RUN;

NOTE: WORK.GUED2005 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.29 seconds
cpu time 0.10 seconds


209
210 PROC IMPORT OUT= WORK.GUED2006
211 DATAFILE= "C:\DonComp\GUE\DECES en Hospitalisation District Guediawaye 2001 à
211! 2007.xls"
212 DBMS=EXCEL REPLACE;
213 SHEET="'2006$'";
214 GETNAMES=YES;
215 MIXED=NO;
216 SCANTEXT=YES;
217 USEDATE=YES;
218 SCANTIME=YES;
219 RUN;

NOTE: WORK.GUED2006 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.35 seconds
cpu time 0.14 seconds


220
221 PROC IMPORT OUT= WORK.GUED2007
222 DATAFILE= "C:\DonComp\GUE\DECES en Hospitalisation District Guediawaye 2001 à
222! 2007.xls"
223 DBMS=EXCEL REPLACE;
224 SHEET="'2007$'";
225 GETNAMES=YES;
226 MIXED=NO;
227 SCANTEXT=YES;
228 USEDATE=YES;
229 SCANTIME=YES;
230 RUN;

NOTE: WORK.GUED2007 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.32 seconds
cpu time 0.11 seconds


231
232 DATA work.GUEM;
233 SET work.GUE2001 work.GUE2002 work.GUE2003 work.GUE2004 work.GUE2005 work.GUE2006 work.GUE2007;
234 IF annee NE .;
235 LENGTH datatype $6;
236 LABEL toutcausu5 = "<5a Consultants toutes causes confondues"
237 paluclinu5 = "<5a Cas de paludisme clinic"
238 paluconfu5 = "<5a Paludisme confirmé"
239 toutcausFE = "FE Consultants toutes causes confondues"
240 paluclinFE = "FE Cas de paludisme clinic"
241 paluconfFE = "FE Paludisme confirmé"
242 toutcaus5p = "5+ Consultants toutes causes confondues"
243 paluclin5p = "5+ Cas de paludisme clinic"
244 paluconf5p = "5+ Paludisme confirmé"
245 toutcaus = "Total Consultants toutes causes confondues"
246 paluclin = "Total Cas de paludisme clinic"
247 paluconf = "Total Paludisme confirmé"
248 formsan = "Nbre de formations sanitaires ayant notifiés"
249 trim = "Trimestre";
250
251 IF trimestre NE " " THEN DO;
252 trim = INPUT(SUBSTR(trimestre,LENGTH(trimestre),1),F2.0);
253 MOIS = (trim - 1) * 3 + 2;
254 END;
255 ELSE trim = 0;
256
257 datatype = "OPD MM";
258 toutcausu5 = Moins_de_5_ans;
259 paluclinu5 = F4;
260 paluconfu5 = F5;
261 toutcaus5p = __ans_et_Plus_exclauant_les_femm;
262 paluclin5p = F7;
263 paluconf5p = F8;
264 toutcausFE = Femmes_enceintes;
265 paluclinFE = F10;
266 paluconfFE = F11;
267 toutcaus = Tout_groupe;
268 paluclin = F13;
269 paluconf = F14;
270 formsan = Nbre_de_formations_sanitaires_ay;
271
272 Gupaluclinu5 = paluclinu5;
273 Gupaluconfu5 = paluconfu5;
274 GutoutcausFE = toutcausFE;
275 GupaluclinFE = paluclinFE;
276 GupaluconfFE = paluconfFE;
277 Gutoutcaus5p = toutcaus5p;
278 Gupaluclin5p = paluclin5p;
279 Gupaluconf5p = paluconf5p;
280 Gutoutcaus = toutcaus;
281 Gupaluclin = paluclin;
282 Gupaluconf = paluconf;
283 Guformsan = formsan;
284 Gutrim = trim;
285
286 DROP trimestre Moins_de_5_ans F4 F5 Femmes_enceintes F7 F8 __ans_et_Plus_exclauant_les_femm F10
286! F11 Tout_groupe F13 F14
287 Nbre_de_formations_sanitaires_ay;
288
289 RUN;

NOTE: There were 5 observations read from the data set WORK.GUE2001.
NOTE: There were 5 observations read from the data set WORK.GUE2002.
NOTE: There were 13 observations read from the data set WORK.GUE2003.
NOTE: There were 13 observations read from the data set WORK.GUE2004.
NOTE: There were 13 observations read from the data set WORK.GUE2005.
NOTE: There were 13 observations read from the data set WORK.GUE2006.
NOTE: There were 13 observations read from the data set WORK.GUE2007.
NOTE: The data set WORK.GUEM has 68 observations and 30 variables.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.06 seconds


290
291 DATA work.GUEH;
292 SET work.GUEH2001 work.GUEH2002 work.GUEH2003 work.GUEH2004 work.GUEH2005 work.GUEH2006
292! work.GUEH2007;
293 IF annee NE .;
294
295 LENGTH datatype $6;
296 LABEL Htoutcausu5 = "<5a Hosp Consultants toutes causes confondues"
297 Hpaluclinu5 = "<5a Hosp Cas de paludisme clinic"
298 Hpaluconfu5 = "<5a Hosp Paludisme confirmé"
299 HtoutcausFE = "FE Hosp Consultants toutes causes confondues"
300 HpaluclinFE = "FE Hosp Cas de paludisme clinic"
301 HpaluconfFE = "FE Hosp Paludisme confirmé"
302 Htoutcaus5p = "5+ Hosp Consultants toutes causes confondues"
303 Hpaluclin5p = "5+ Hosp Cas de paludisme clinic"
304 Hpaluconf5p = "5+ Hosp Paludisme confirmé"
305 Htoutcaus = "Total Hosp Consultants toutes causes confondues"
306 Hpaluclin = "Total Hosp Cas de paludisme clinic"
307 Hpaluconf = "Total Hosp Paludisme confirmé"
308 Hformsan = "Nbre de Hosp ayant notifiés";
309
310 Htoutcausu5 = Moins_de_5_ans;
311 Hpaluclinu5 = F4;
312 Hpaluconfu5 = F5;
313 Htoutcaus5p = __ans_et_Plus_excluant_les_femme;
314 Hpaluclin5p = F7;
315 Hpaluconf5p = F8;
316 HtoutcausFE = Femmes_enceintes;
317 HpaluclinFE = F10;
318 HpaluconfFE = F11;
319 Htoutcaus = Tout_groupe;
320 Hpaluclin = F13;
321 Hpaluconf = F14;
322 Hformsan = nhifacrep;
323
324 GuHtoutcausu5 = Htoutcausu5;
325 GuHpaluclinu5 = Hpaluclinu5;
326 GuHpaluconfu5 = Hpaluconfu5;
327 GuHtoutcausFE = HtoutcausFE;
328 GuHpaluclinFE = HpaluclinFE;
329 GuHpaluconfFE = HpaluconfFE;
330 GuHtoutcaus5p = Htoutcaus5p;
331 GuHpaluclin5p = Hpaluclin5p;
332 GuHpaluconf5p = Hpaluconf5p;
333 GuHtoutcaus = Htoutcaus;
334 GuHpaluclin = Hpaluclin;
335 GuHpaluconf = Hpaluconf;
336 GuHformsan = Hformsan;
337
338 datatype = "HOSPMM";
339
340 DROP Moins_de_5_ans F4 F5 Femmes_enceintes F7 F8 __ans_et_Plus_excluant_les_femme F10 F11
340! Tout_groupe F13 F14
341 nhifacrep;
342
343 RUN;

NOTE: There were 13 observations read from the data set WORK.GUEH2001.
NOTE: There were 13 observations read from the data set WORK.GUEH2002.
NOTE: There were 13 observations read from the data set WORK.GUEH2003.
NOTE: There were 13 observations read from the data set WORK.GUEH2004.
NOTE: There were 13 observations read from the data set WORK.GUEH2005.
NOTE: There were 13 observations read from the data set WORK.GUEH2006.
NOTE: There were 13 observations read from the data set WORK.GUEH2007.
NOTE: The data set WORK.GUEH has 84 observations and 29 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds


344
345 DATA work.GUED;
346 SET work.GUED2001 work.GUED2002 work.GUED2003 work.GUED2004 work.GUED2005 work.GUED2006
346! work.GUED2007;
347 IF annee NE .;
348
349 LENGTH datatype $6;
350 LABEL Dtoutcausu5 = "<5a Deces toutes causes confondues"
351 Dpaluu5 = "<5a Deces pour paludisme"
352 DtoutcausFE = "FE Deces toutes causes confondues"
353 DpaluFE = "FE Deces pour paludisme"
354 Dtoutcaus5p = "5+ Deces toutes causes confondues"
355 Dpalu5p = "5+ Deces pour paludisme"
356 Dtoutcaus = "Total Deces toutes causes confondues"
357 Dpalu = "Total Deces pour paludisme"
358 Dformsan = "Nbre de Hosp ayant notifiés";
359
360 Dtoutcausu5 = Moins_de_5_ans;
361 Dpaluu5 = F4;
362 Dtoutcaus5p = __ans_et_Plus_Excluant_les_femme;
363 Dpalu5p = F6;
364 DtoutcausFE = Femmes_enceintes;
365 DpaluFE = F8;
366 Dtoutcaus = Tout_groupe;
367 Dpalu = F10;
368 Dformsan = Nbre_de_Formation_sanitaire_ayan;
369
370 GuDtoutcausu5 = Dtoutcausu5;
371 GuDpaluu5 = Dpaluu5;
372 GuDtoutcaus5p = Dtoutcaus5p;
373 GuDpalu5p = Dpalu5p;
374 GuDtoutcaus = Dtoutcaus;
375 GuDpalu = Dpalu;
376 GuDformsan = Dformsan;
377
378 datatype = "Deces";
379
380 DROP Moins_de_5_ans F4 Femmes_enceintes F6 __ans_et_Plus_Excluant_les_femme F8 Tout_groupe F10
381 Nbre_de_Formation_sanitaire_ayan;
382
383 RUN;

NOTE: There were 13 observations read from the data set WORK.GUED2001.
NOTE: There were 13 observations read from the data set WORK.GUED2002.
NOTE: There were 13 observations read from the data set WORK.GUED2003.
NOTE: There were 13 observations read from the data set WORK.GUED2004.
NOTE: There were 13 observations read from the data set WORK.GUED2005.
NOTE: There were 13 observations read from the data set WORK.GUED2006.
NOTE: There were 13 observations read from the data set WORK.GUED2007.
NOTE: The data set WORK.GUED has 84 observations and 19 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds


384
385 PROC SORT DATA=work.GUEM;
386 BY annee mois;
387 RUN;

NOTE: There were 68 observations read from the data set WORK.GUEM.
NOTE: The data set WORK.GUEM has 68 observations and 30 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds


388
389 PROC SORT DATA=work.GUEH;
390 BY annee mois;
391 RUN;

NOTE: There were 84 observations read from the data set WORK.GUEH.
NOTE: The data set WORK.GUEH has 84 observations and 29 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds


392
393 PROC SORT DATA=work.GUED;
394 BY annee mois;
395 RUN;

NOTE: There were 84 observations read from the data set WORK.GUED.
NOTE: The data set WORK.GUED has 84 observations and 19 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds


396
397 DATA work.GUE;
398 MERGE work.GUEM work.GUEH work.GUED;
399 BY annee mois;
400 LENGTH district $20;
401 LABEL district = "District sanitaire"
402 intervent = "Intervention (1)IRS (2)LLIN";
403 intervent = 2;
404
405 district = "Geudiawaye";
406 numpostes = 11;
407 numhosp = 1;
408 *poptot2006 = 285747;
409 *popU52006 = 57149;
410 *popFE2006 = 10287;
411
412 DROP datatype Gupaluclinu5
413 Gupaluconfu5
414 GutoutcausFE
415 GupaluclinFE
416 GupaluconfFE
417 Gutoutcaus5p
418 Gupaluclin5p
419 Gupaluconf5p
420 Gutoutcaus
421 Gupaluclin
422 Gupaluconf
423 Guformsan
424 Gutrim
425 GuHtoutcausu5
426 GuHpaluclinu5
427 GuHpaluconfu5
428 GuHtoutcausFE
429 GuHpaluclinFE
430 GuHpaluconfFE
431 GuHtoutcaus5p
432 GuHpaluclin5p
433 GuHpaluconf5p
434 GuHtoutcaus
435 GuHpaluclin
436 GuHpaluconf
437 GuHformsan
438 GuDtoutcausu5
439 GuDpaluu5
440 GuDtoutcaus5p
441 GuDpalu5p
442 GuDtoutcaus
443 GuDpalu
444 GuDformsan;
445 RUN;

NOTE: There were 68 observations read from the data set WORK.GUEM.
NOTE: There were 84 observations read from the data set WORK.GUEH.
NOTE: There were 84 observations read from the data set WORK.GUED.
NOTE: The data set WORK.GUE has 84 observations and 42 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds


446
447 PROC SORT DATA=work.distsanpop;
ERROR: File WORK.DISTSANPOP.DATA does not exist.
448 BY year;
449 RUN;

NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

450


451 DATA work.GUEyr;
452 MERGE work.distsanpop (RENAME=(year=annee) WHERE=(district="Guédiawaye"))
453 work.GUE (IN=havedata);
ERROR: File WORK.DISTSANPOP.DATA does not exist.
454 BY annee;
455 popU5 = distpop * 0.19;
456 popFE = distpop * 0.036;
457
458 IF havedata;
459
460 RUN;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.GUEYR may be incomplete. When this step was stopped there were 0
observations and 45 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
deleted_user
Not applicable
My apologies that the previous post did not include the error in question and failed for another reason related to some changes I made to get around the error.

I have a program that includes several program files similar to the one I just posted. Running individual programs seems to work, but when I run the "parent" program that includes the others, sorts begin to fail. The log file for that run is a bit challenging as it is quite long, even when the included program code is hidden.

Below is the log file for the program I previously posted, this time "included". The sort for "GUEH" failed.

Thanks
R Perry

2406 %INCLUDE 'C:\DonComp\old versions\GUE3.sas';

NOTE: WORK.GUE2001 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.29 seconds
cpu time 0.09 seconds


( more imports )


NOTE: WORK.GUED2007 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.34 seconds
cpu time 0.09 seconds



NOTE: There were 5 observations read from the data set WORK.GUE2001.
NOTE: There were 5 observations read from the data set WORK.GUE2002.
NOTE: There were 13 observations read from the data set WORK.GUE2003.
NOTE: There were 13 observations read from the data set WORK.GUE2004.
NOTE: There were 13 observations read from the data set WORK.GUE2005.
NOTE: There were 13 observations read from the data set WORK.GUE2006.
NOTE: There were 13 observations read from the data set WORK.GUE2007.
NOTE: The data set WORK.GUEM has 68 observations and 30 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds



NOTE: There were 13 observations read from the data set WORK.GUEH2001.
NOTE: There were 13 observations read from the data set WORK.GUEH2002.
NOTE: There were 13 observations read from the data set WORK.GUEH2003.
NOTE: There were 13 observations read from the data set WORK.GUEH2004.
NOTE: There were 13 observations read from the data set WORK.GUEH2005.
NOTE: There were 13 observations read from the data set WORK.GUEH2006.
NOTE: There were 13 observations read from the data set WORK.GUEH2007.
NOTE: The data set WORK.GUEH has 84 observations and 29 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds



NOTE: There were 13 observations read from the data set WORK.GUED2001.
NOTE: There were 13 observations read from the data set WORK.GUED2002.
NOTE: There were 13 observations read from the data set WORK.GUED2003.
NOTE: There were 13 observations read from the data set WORK.GUED2004.
NOTE: There were 13 observations read from the data set WORK.GUED2005.
NOTE: There were 13 observations read from the data set WORK.GUED2006.
NOTE: There were 13 observations read from the data set WORK.GUED2007.
NOTE: The data set WORK.GUED has 84 observations and 19 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds



NOTE: There were 68 observations read from the data set WORK.GUEM.
NOTE: The data set WORK.GUEM has 68 observations and 30 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds



NOTE: There were 84 observations read from the data set WORK.GUEH.
NOTE: The data set WORK.GUEH has 84 observations and 29 variables.
ERROR: Rename of temporary member for WORK.GUEH.DATA failed.
File may be found in C:\Users\rperry\AppData\Local\Temp\SAS Temporary Files\_TD12228.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds




NOTE: There were 84 observations read from the data set WORK.GUED.
NOTE: The data set WORK.GUED has 84 observations and 19 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds


ERROR: User does not have appropriate authorization level for file WORK.GUEH.DATA.

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.GUE may be incomplete. When this step was stopped there were 0
observations and 29 variables.
WARNING: Data set WORK.GUE was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds



NOTE: Input data set is already sorted, no sorting done.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds



NOTE: There were 7 observations read from the data set WORK.DISTSANPOP.
WHERE district='Guédiawaye';
NOTE: There were 84 observations read from the data set WORK.GUE.
NOTE: The data set WORK.GUEYR has 84 observations and 45 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds



NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
16 at 2900:17 16 at 2901:19 16 at 2902:19 16 at 2904:23
NOTE: There were 84 observations read from the data set WORK.GUEYR.
NOTE: The data set WORK.GUETR has 84 observations and 31 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Again, it would be best if you provided the SASLOG with the imbedded (compiled and executed) SAS code (step by step) for a fair and objective review. Your last SASLOG only provided the SAS notes and errors. Clearly, the steps that do not fail and do not involve the SAS file in question can be suppressed, trusting your own desk-checking techniques.

Scott Barry
SBBWorks, Inc.
deleted_user
Not applicable
Thanks for the reply and I will try again to include the appropriate code.
Below is an example ... the import statements after the first are not included. The program imports 21 datasets, groups them into 3 new datasets, and sorts each one. 2 sorts succeed, one fails.

Thanks again
R Perry

4114 +PROC IMPORT OUT= WORK.GUE2001
4115 + DATAFILE= "C:\DonComp\GUE\Données de Consultation Externe District Guediawaye 2001
4115!+ à 2007.xls"
4116 + DBMS=EXCEL REPLACE;
4117 + SHEET="'2001$'";
4118 + GETNAMES=YES;
4119 + MIXED=NO;
4120 + SCANTEXT=YES;
4121 + USEDATE=YES;
4122 + SCANTIME=YES;
4123 +RUN;

NOTE: WORK.GUE2001 was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.26 seconds
cpu time 0.07 seconds


...

4344 +
4345 +DATA work.GUEM;
4346 +SET work.GUE2001 work.GUE2002 work.GUE2003 work.GUE2004 work.GUE2005 work.GUE2006 work.GUE2007
4346!+;

...

4401 +
4402 +RUN;

NOTE: There were 5 observations read from the data set WORK.GUE2001.
NOTE: There were 5 observations read from the data set WORK.GUE2002.
NOTE: There were 13 observations read from the data set WORK.GUE2003.
NOTE: There were 13 observations read from the data set WORK.GUE2004.
NOTE: There were 13 observations read from the data set WORK.GUE2005.
NOTE: There were 13 observations read from the data set WORK.GUE2006.
NOTE: There were 13 observations read from the data set WORK.GUE2007.
NOTE: The data set WORK.GUEM has 68 observations and 30 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds


4403 +
4404 +DATA work.GUEH;
4405 +SET work.GUEH2001 work.GUEH2002 work.GUEH2003 work.GUEH2004 work.GUEH2005 work.GUEH2006
4405!+work.GUEH2007;

...

4455 +
4456 +RUN;

NOTE: There were 13 observations read from the data set WORK.GUEH2001.
NOTE: There were 13 observations read from the data set WORK.GUEH2002.
NOTE: There were 13 observations read from the data set WORK.GUEH2003.
NOTE: There were 13 observations read from the data set WORK.GUEH2004.
NOTE: There were 13 observations read from the data set WORK.GUEH2005.
NOTE: There were 13 observations read from the data set WORK.GUEH2006.
NOTE: There were 13 observations read from the data set WORK.GUEH2007.
NOTE: The data set WORK.GUEH has 84 observations and 29 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds


4457 +
4458 +DATA work.GUED;
4459 +SET work.GUED2001 work.GUED2002 work.GUED2003 work.GUED2004 work.GUED2005 work.GUED2006
4459!+work.GUED2007;
4460 +IF annee NE .;
4461 +

...


4495 +
4496 +RUN;

NOTE: There were 13 observations read from the data set WORK.GUED2001.
NOTE: There were 13 observations read from the data set WORK.GUED2002.
NOTE: There were 13 observations read from the data set WORK.GUED2003.
NOTE: There were 13 observations read from the data set WORK.GUED2004.
NOTE: There were 13 observations read from the data set WORK.GUED2005.
NOTE: There were 13 observations read from the data set WORK.GUED2006.
NOTE: There were 13 observations read from the data set WORK.GUED2007.
NOTE: The data set WORK.GUED has 84 observations and 19 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds


4497 +
4498 +PROC SORT DATA=work.GUEM;
4499 +BY annee mois;
4500 +RUN;

NOTE: There were 68 observations read from the data set WORK.GUEM.
NOTE: The data set WORK.GUEM has 68 observations and 30 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds


4501 +
4502 +PROC SORT DATA=work.GUEH;
4503 +BY annee mois;
4504 +RUN;

NOTE: There were 84 observations read from the data set WORK.GUEH.
NOTE: The data set WORK.GUEH has 84 observations and 29 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds


4505 +
4506 +PROC SORT DATA=work.GUED;
4507 +BY annee mois;
4508 +RUN;

NOTE: There were 84 observations read from the data set WORK.GUED.
NOTE: The data set WORK.GUED has 84 observations and 19 variables.
ERROR: Rename of temporary member for WORK.GUED.DATA failed.
File may be found in C:\Users\rperry\AppData\Local\Temp\SAS Temporary Files\_TD3792.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

4509 +
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
So, your original post shows a different SAS file named in the error message. After searching the SAS support website http://support.sas.com/ using your error symptom, I found reference to DiskKeeper software (possibly not the only problem source -- could be another utility product), which may be running on your system, contributing to the problem. If this problem just starting occurring recently, you may want to investigate OS or application/utility changes that could be an influence.

Try mapping another physical drive and using it for the output destination, rather than the C:\ system work defalut location. After several runs, if no similar occurs, you may have some info to help debug the error.

Scott Barry
SBBWorks, Inc.

Problem Note 31295: If Diskeeper software and SAS® software are both running on your machine, you might receive WORK.TEMP.DATA errors

http://support.sas.com/kb/31/295.html
deleted_user
Not applicable
Thanks for the reply. Please note that the software in question (Diskeeper) is not installed on my computer; I have not installed other utility products in the last few weeks.
The suggestion to map another physical drive is an interesting one; I have created an alternative work directory that is in another folder on my C drive and made that the library used in all data steps and sorts. That change does not stop these errors from occurring with roughly 1/3 - 1/4 of the sorts I run. The error occurs at different points with each run of the program.
Even with the original work directory, no "rename of temp member xxx failed" errors occurred when the code gives the sorted file a new name using the OUT= option.
Thanks again and best regards,
R Perry
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
You may also want to check your hard drive for errors. And the idea of mapping an alternate drive for WORK, related to a physical drive, if it is available to you -- possibly even a network-connected drive/folder location.

Scott Barry
SBBWorks, Inc.
deleted_user
Not applicable
Thanks again for the help. The hard drive has no errors. I am not working on a network so have no network-connected location; I could try on a hard drive connected through USB.
Thanks and I would be grateful for any other observations / thoughts that people have.
Best regards,
R Perry
deleted_user
Not applicable
any anti-virus software running ?

Many of these have auto-update features which can change their nature, including how they handle files.

PeterC
deleted_user
Not applicable
Just to support you - i have the same problem, 1 out of 4 times i get these strange errors.

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!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 23 replies
  • 23806 views
  • 1 like
  • 10 in conversation