Date:         Tue, 25 Oct 2005 13:44:18 +0100
Reply-To:     ben.powell@cla.co.uk
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ben Powell <Ben.powell@CLA.CO.UK>
Organization: cla
Subject:      Re: Delete an excel file in the 'c: dir' from sas - how to?
Comments: To: Hari Nath <hari_s_nath@YAHOO.COM>
In-Reply-To:  <200510251218.j9PAk1Q2032577@malibu.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

Rtfm :-)

-----Original Message-----
From: Hari Nath [mailto:hari_s_nath@YAHOO.COM]
Sent: 25 October 2005 13:19
To: SAS-L@LISTSERV.UGA.EDU; Ben.powell@CLA.CO.UK
Subject: Re: Delete an excel file in the 'c: dir' from sas - how to?


Ben,
 Thats interesting. Could u tell me where can i find information about the
command in windows/dos that works in sas.

thanks


On Tue, 25 Oct 2005 08:53:52 +0100, Ben Powell <Ben.powell@CLA.CO.UK> wrote:

>With the X command in windows you can use most if not all dos commands.
>Adding the sas option xmin will prevent the command window from popping
>up.
>
>HTH.
>
>-----Original Message-----
>From: Hari Nath [mailto:hari_s_nath@YAHOO.COM]
>Sent: 24 October 2005 16:59
>To: SAS-L@LISTSERV.UGA.EDU; ben.powell@CLA.CO.UK
>Subject: Re: Delete an excel file in the 'c: dir' from sas - how to?
>
>
>Ben,
> Thanks for your code. I didnt knew that there was a system option that
>would do the work more simple. That was very helpful. Thanks again hari
>
>On Mon, 24 Oct 2005 11:41:41 -0400, ben.powell@CLA.CO.UK wrote:
>
>>Do you need to test for existence?
>>
>>option noxwait;
>>x 'del c:\temp\test.xls';
>>
>>On Mon, 24 Oct 2005 08:16:04 -0400, Hari Nath <hari_s_nath@YAHOO.COM>
>wrote:
>>
>>>Hi all,
>>>    I need to check the existence of an excel file and if the excel
>>>file exists, then I have to delete that everytime the program is run.
>>>Lets say the excel file is stored in the directory 'C:\TEMP' and lets
>>>say the name of the excel file TEST.XLS
>>>
>>>I beleive that it can checked with %SYSFUNC() macro, but I havent
>>>used it. Can somebody help me with this. Iam using sas 9.1.3 WINDOWS
>>>XP and EXCEL 2000.
>>>
>>>Thanks all,
>>>hari