Dataset creation does not warn existing table will be overwrittten

Rajesh3030 — Sat, 09 Oct 2021 07:30:16 GMT

I just swtiched to EG version of SAS, when ever i create the data set (not in work profile) under library space, i am not getting below warning like I had in Base SAS . There should be someway

Warning

Existing dataset already exist , you are to overwrite (something like this )

Re: Dataset creation does not warn existing table will be overwrittten

FreelanceReinh — Sat, 09 Oct 2021 08:25:23 GMT

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

topic Re: Dataset creation does not warn existing table will be overwrittten in SAS Programming

Dataset creation does not warn existing table will be overwrittten

Re: Dataset creation does not warn existing table will be overwrittten