Hello @Rajesh3030 and welcome to the SAS Support Communities!
This might be due to different settings of the REPLACE system option. You can see in the log below how it works:
1 /* Check setting of REPLACE system option */
2
3 proc options option=replace;
4 run;
SAS (r) Proprietary Software Release 9.4 TS1M5
REPLACE Enables replacement of permanent SAS data sets.
NOTE: PROCEDURE OPTIONS used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
5
6 libname ct 'C:\Temp';
NOTE: Libref CT was successfully assigned as follows:
Engine: V9
Physical Name: C:\Temp
7
8 /* Create permanent dataset */
9
10 data ct.test;
11 set sashelp.heart(obs=4);
12 run;
NOTE: There were 4 observations read from the data set SASHELP.HEART.
NOTE: The data set CT.TEST has 4 observations and 17 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.03 seconds
13
14 /* Replace it */
15
16 proc sort data=sashelp.class(obs=3) out=ct.test;
17 by age;
18 run;
NOTE: There were 3 observations read from the data set SASHELP.CLASS.
NOTE: SAS sort was used.
NOTE: The data set CT.TEST has 3 observations and 5 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
19
20 options noreplace;
21
22 /* Now this fails to replace it (in spite of the subsequent NOTE in the log) */
23
24 data ct.test;
25 x=1;
26 run;
NOTE: The data set CT.TEST has 1 observations and 1 variables.
WARNING: Data set CT.TEST was not replaced because of NOREPLACE option.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
27
28 /* Use dataset option REPLACE= to override the system option */
29
30 proc summary data=sashelp.cars;
31 var weight;
32 output out=ct.test(replace=yes);
33 run;
NOTE: Multiple concurrent threads will be used to summarize data.
NOTE: There were 428 observations read from the data set SASHELP.CARS.
NOTE: The data set CT.TEST has 5 observations and 4 variables.
NOTE: PROCEDURE SUMMARY used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
... View more
