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 )
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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.