Date:         Sun, 4 Mar 2001 12:03:48 +0100
Reply-To:     Lex Jansen <l.jansen@LEX-JANSEN.DEMON.NL>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Lex Jansen <l.jansen@LEX-JANSEN.DEMON.NL>
Subject:      Re: Delete files from SAS

Try this:

data _null_;
length fname $200;
  fname="tempfile";
  rc=filename(fname,"c:\temp\deleteme.xls");
  if rc = 0 and fexist(fname) then rc=fdelete(fname);
  rc=filename(fname);
run;

or in a macro:

%let rc=%sysfunc(filename(fname,c:\temp\deleteme.xls));
%if &rc = 0 and %sysfunc(fexist(&fname))
    %then  %let rc = %sysfunc(fdelete(&fname));
    %else %put %sysfunc(sysmsg());
%let rc=%sysfunc(filename(fname,''));

Lex Jansen


<b_branford@nospam.yahoo.com> wrote in message
news:97sbon$gnt$1@news.netmar.com...
> hi,
>
> Is it possible for me to delete a file on Windows from my SAS session.  I
use
> Proc DBload to create an excel file from a SAS file. However, if the
original
> file exists, I have to manually remove it.
>
> Thanks.
>
> brad
>
>
>  -----  Posted via NewsOne.Net: Free (anonymous) Usenet News via the
eb  -----
>   http://newsone.net/ -- Free reading and anonymous posting to 60,000+
groups
>    NewsOne.Net prohibits users from posting spam.  If this or other posts
> made through NewsOne.Net violate posting guidelines, email
abuse@newsone.net