Date: Mon, 8 Feb 1999 23:42:53 -0500
Reply-To: Hai-Bin Shu <hshu@STAT.PURDUE.EDU>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Hai-Bin Shu <hshu@STAT.PURDUE.EDU>
Organization: Purdue University
Subject: Re: PROC DBLOAD with EXCEL
Content-Type: TEXT/PLAIN; charset=US-ASCII
The naming convention follows that under DOS.
On Mon, 8 Feb 1999, Christopher Sigouin wrote:
> HI I'm having trouble with deleting an excel file with 6.12 windows 95.
> I realize the existing file must first be deleted before it can be
> created again.
> The program will create the test.xls file the first time the program is
> run but will not delete the file when I run the program again.
> Here is the code:
> options noxwait;
> x 'del c:\my documents\public health\test.xls';
> proc dbload dmbs=excel data=qual;
> path='c:\my documents\public health\test.xls';
> The above program works when the directory has no blanks in it, that is,
> c:\temp\test.xls INSTEAD OF c:\my documents\public health\test.xls
> Is there some way of accessing a directory with the spaces in it??