topic Re: Rename of temporary member xxxx failed in SAS Programming

Rename of temporary member xxxx failed

deleted_user — Wed, 31 Dec 2008 22:03:34 GMT

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

Re: Rename of temporary member xxxx failed

Cynthia_sas — Thu, 01 Jan 2009 15:42:58 GMT

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

Re: Rename of temporary member xxxx failed

deleted_user — Thu, 01 Jan 2009 21:14:03 GMT

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.

Re: Rename of temporary member xxxx failed

sbb — Fri, 02 Jan 2009 00:15:25 GMT

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.

Re: Rename of temporary member xxxx failed

Doc_Duke — Fri, 02 Jan 2009 00:58:24 GMT

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.

Re: Rename of temporary member xxxx failed

deleted_user — Fri, 02 Jan 2009 10:00:00 GMT

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

Re: Rename of temporary member xxxx failed

deleted_user — Fri, 02 Jan 2009 10:19:02 GMT

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

Re: Rename of temporary member xxxx failed

sbb — Fri, 02 Jan 2009 13:57:40 GMT

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.

Re: Rename of temporary member xxxx failed

deleted_user — Fri, 02 Jan 2009 16:23:38 GMT

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 +

Re: Rename of temporary member xxxx failed

sbb — Fri, 02 Jan 2009 19:18:19 GMT

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

Re: Rename of temporary member xxxx failed

deleted_user — Sun, 04 Jan 2009 21:46:36 GMT

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

Re: Rename of temporary member xxxx failed

sbb — Mon, 05 Jan 2009 01:20:39 GMT

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.

Re: Rename of temporary member xxxx failed

deleted_user — Wed, 14 Jan 2009 10:49:48 GMT

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

Re: Rename of temporary member xxxx failed

deleted_user — Tue, 20 Jan 2009 09:59:07 GMT

any anti-virus software running ?

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

PeterC

Re: Rename of temporary member xxxx failed

deleted_user — Mon, 14 Sep 2009 21:21:06 GMT

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

Re: Rename of temporary member xxxx failed

Kastchei — Wed, 28 Jul 2010 23:01:06 GMT

I am also having this issue. It's gotten so that if I run any program of moderate length, it will fail. I have to run small sections at a time, which simply is not possible for programs I have which are over 2000 lines. Has there been any hotfix for this yet?

Re: Rename of temporary member xxxx failed

sbb — Thu, 29 Jul 2010 00:48:06 GMT

For these forums, it's best to own your personal posts, and add links to other prior posts.

More important, as was previously recommended, you will be best served here by sharing (pasting in your "new post") the SAS-generate log with all SAS code revealed.

Of course, an alternative to consider is open a SAS tech support track and provide them your details, as required.

Scott Barry
SBBWorks, Inc.

Re: Rename of temporary member xxxx failed

Kastchei — Thu, 29 Jul 2010 13:36:42 GMT

Thanks for the reply. Since the last post about this was 2 years ago, I was hoping that perhaps there was a hotfix. There's nothing special or constant about the code I have that creates this error, so posting a log isn't going to resolve anything. I was more just curious if there has been any official update, as opposed to finding a personal solution.

(I know the party-line with any kind of computer anomaly is to plug it in, reboot, defreg, check harddrive, check memory, virus scan, malware scan, etc. But, be assured there is nothing wrong with my computer or code. 😄 )

Re: Rename of temporary member xxxx failed

rickpaulos — Thu, 28 Feb 2013 19:50:56 GMT

2013 and I am having this same problem. XP SP3. SAS 9.3 TS Level 1MO.

My troubles started last year, possibly when a windows update was applied. (Automatic updates are required where I work). I've since removed SAS v9.1 and installed a newer version (9.3) but the problem continues. Other co-workers using win7 report no trouble. Makes me think it's XP related.

If I run my programs 1 data step or 1 proc at a time, all works fine. When I try to run my entire program in 1 submit, it generates the error most of the time but not always?. An immediate re-Submit may or may not generate the error. and so on.

No Diskeeper. No UNC's. Have full read/write/create/delete access to the temporary folder on my C drive. Plenty of disk space.

I opened up My Computer to monitor the files in the SAS created temporary folder which reveals the work.filename in question is still locked from the previous DATA step or data set modifying procedure. This is 100% consistent, locked file = error. It is like XP can't keep up with SAS creates/writes. I wonder if SAS is multi threading to speed up and is getting ahead of the operating system's writing and closing of the file before SAS tries to open it again. Is there an option to turn on/off multitasking? Or is there some XP setting to write files immediately instead of buffering writes? Note that SAS generates a random name for that temporary folder for each session so you can't make a shortcut for it.

To see the .lck filename extension added to the temporary work.filename you may need to change My Computer view settings:

My Computer, Tools, Folder Options, View tab, unselect "Hide extensions for known file types"

and to see the temp work folders:

My Computer, Tools, Folder Options, View tab, select "Display the contents of system folders"

I tried to use a "LOCK work.filename CLEAR" statement but the resulting SAS error suggest I can only unlock files that I locked, not files locked by SAS.

I added a RUN statement at the end of every DATA step so I can submit each data step or PROC separately for debugging.

The most reliable fix is to modify my programs so I create a new data set with each and every data step and proc sort.

Log from a recent failed run:

581 DATA a;

582 INFILE "m:\rpaulos\bone\data\wave123456\2013.02.21.summary.txt"

583 DLM="," DSD PAD MISSOVER FIRSTOBS=2 LRECL=5000;

584 INFORMAT today mmddyy10.;

585 FORMAT today mmddyy10.;

586 LENGTH DayOfWeek WeekDayend WamStartTime CSAfilename WamMode $ 15;

587 LENGTH WamSerial $ 20;

588 INPUT Id Wave Today DayOfWeek WeekDayEnd WamStartTime WamSerial WamMode

588! CsaFilename DayOn DayOff

589 ReadingCount DailySum TimeWorn TimeNotWorn

590 MovementsGt0 Movements0to99 MovementsGt99

591 SedentaryMovements LightMovements ModerateMovements

591! VigorousMovements ExtremeMovements

592 Average AverageGT0 AverageGT99

593 SedentarySum LightSum ModerateSum VigorousSum ExtremeSum

594 BoutSedentary10 BoutSedentary20 BoutModerate5 BoutModerate10

595 AMon AMoff AMsum AMTimeWorn AMTimeNotWorn

596 AMMovementsGT0 AMMovements0to99 AMMovementsGT99

597 AMSedentaryMovements AMLightMovements AMModerateMovements

597! AMVigorousMovements AMExtremeMovements

598 AMAverage AMAverageGT0 AMAverageGT99

599 AMSedentarySum AMLightSum AMModerateSum AMVigorousSum AMExtremeSum

600 MMon MMoff MMsum MMTimeWorn MMTimeNotWorn

601 MMMovementsGT0 MMMovements0to99 MMMovementsGT99

602 MMSedentaryMovements MMLightMovements MMModerateMovements

602! MMVigorousMovements MMExtremeMovements

603 MMAverage MMAverageGT0 MMAverageGT99 MMSedentarySum MMLightSum

603! MMModerateSum MMVigorousSum

604 MMExtremeSum

605 PMon PMoff PMsum PMTimeWorn PMTimeNotWorn

606 PMMovementsGT0 PMMovements0to99 PMMovementsGT99

607 PMSedentaryMovements PMLightMovements PMModerateMovements

607! PMVigorousMovements PMExtremeMovements

608 PMAverage PMAverageGT0 PMAverageGT99

609 PMSedentarySum PMLightSum PMModerateSum PMVigorousSum PMExtremeSum

609! ;

610 RUN;

NOTE: The infile "m:\rpaulos\bone\data\wave123456\2013.02.21.summary.txt" is:

Filename=m:\rpaulos\bone\data\wave123456\2013.02.21.summary.txt,

RECFM=V,LRECL=5000,File Size (bytes)=7077230,

Last Modified=21Feb2013:13:21:24,

Create Time=21Feb2013:13:15:36

NOTE: 12051 records were read from the infile

"m:\rpaulos\bone\data\wave123456\2013.02.21.summary.txt".

The minimum record length was 475.

The maximum record length was 638.

NOTE: The data set WORK.A has 12051 observations and 98 variables.

NOTE: DATA statement used (Total process time):

real time 2.56 seconds

cpu time 0.79 seconds

611 *** count number of days per subject & wave ***;

612 PROC SORT;

613 BY wave id DESCENDING today;

614 RUN;

NOTE: There were 12051 observations read from the data set WORK.A.

NOTE: The data set WORK.A has 12051 observations and 98 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.17 seconds

cpu time 0.17 seconds

615 DATA a;

616 SET a;

617 BY wave id;

618 RETAIN DayCount;

619 IF FIRST.id THEN DayCount = 0;

620 DayCount = Daycount + 1;

621 RUN;

NOTE: There were 12051 observations read from the data set WORK.A.

NOTE: The data set WORK.A has 12051 observations and 99 variables.

NOTE: DATA statement used (Total process time):

real time 0.15 seconds

cpu time 0.15 seconds

622 *** resort ***;

623 PROC SORT ;

624 BY wave id today;

625 RUN;

NOTE: There were 12051 observations read from the data set WORK.A.

NOTE: The data set WORK.A has 12051 observations and 99 variables.

NOTE: PROCEDURE SORT used (Total process time):

real time 0.78 seconds

cpu time 0.17 seconds

626 *** assign dayscount to all obs per person per wave ***;

627 DATA a;

628 SET a;

629 BY wave id;

630 RETAIN DaysCount;

631 IF first.id THEN DaysCount = dayCount;

632 RUN;

NOTE: There were 12051 observations read from the data set WORK.A.

NOTE: The data set WORK.A has 12051 observations and 100 variables.

ERROR: Rename of temporary member for WORK.A.DATA failed.

File may be found in C:\DOCUME~1\rpaulos\LOCALS~1\Temp\SAS Temporary

Files\_TD3436_PH-WL-2205-RP_.

NOTE: DATA statement used (Total process time):

real time 0.15 seconds

cpu time 0.15 seconds

Re: Rename of temporary member xxxx failed

SASKiwi — Thu, 28 Feb 2013 22:17:13 GMT

Have you gone through all of the SAS notes related to this problem? I found at least 8 with a simple search including this:

http://support.sas.com/kb/14/246.html - I assume you have Modify or Full Control access on your WORK folder.

Also I would recommend you raise a track with SAS Support.