topic SAS is ignoring the NOREPLACE option in SAS Programming

SAS is ignoring the NOREPLACE option

_Altons_ — Thu, 28 May 2009 09:55:25 GMT

Hi All,

I am having problems with the noreplace option, I've nearly wiped out the whole sashelp library so I made a copy of sashelp.shoes and tried one more time to check whether the noreplace was working or not. Still not working and I wonder why!

Please find below the log. Thanks in advance for helping me out with this matter.

108 data shoes;
109 set sashelp.shoes;
110 run;

NOTE: There were 395 observations read from the data set SASHELP.SHOES.
NOTE: The data set WORK.SHOES has 395 observations and 7 variables.
NOTE: Compressing data set WORK.SHOES decreased size by 0.00 percent.
Compressed is 5 pages; un-compressed would require 5 pages.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

111 options obs=0 noreplace;
112 proc sort data=shoes; by region;run;

NOTE: Input data set is empty.
NOTE: The data set WORK.SHOES has 0 observations and 7 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds

Re: SAS is ignoring the NOREPLACE option

sbb — Thu, 28 May 2009 11:52:43 GMT

Here's the DOC link for SAS 9.2 -- the reference to "temporary SAS data sets" may be a tad vague though. From the SORT DOC:

Note: If the SAS system option NOREPLACE is in effect, then you cannot replace an original permanent data set with a sorted version. You must either use the OUT= option or specify the SAS system option REPLACE in an OPTIONS statement. The SAS system option NOREPLACE does not affect temporary SAS data sets.

Scott Barry
SBBWorks, Inc.

SORT PROCEDURE: Results: SORT Procedure - see NOTE at bottom of section (pasted above):
http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/a002473664.htm

Re: SAS is ignoring the NOREPLACE option

_Altons_ — Thu, 28 May 2009 14:50:02 GMT

Thanks!

But now I wonder how I could rewrite sashelp.class and other data sets in the sashelp library?

Re: SAS is ignoring the NOREPLACE option

sbb — Thu, 28 May 2009 15:36:35 GMT

Contact your SAS Admin, identify a suitable backup-copy, and request a restore be performed.

Scott Barry
SBBWorks, Inc.