You'll get the "physical file does not exist" message if the Excel
spreadsheet is not open when you execute the SAS code.
Try opening the spreadsheet, and then executing the SAS code while the
spreadsheet is open.
"Jay Tanzman" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL
Jay Tanzman <[EMAIL PROTECTED]> wrote in message
news:<[EMAIL PROTECTED]>...
> Eric Miller wrote:
> >
> > Dear Friends,
> >
> > I had difficulty reading huge excel data into sas.
> > I tried the following code, but it always says "physical file does not
> > exist". I need your help.
> >
> > My
Eric Miller <[EMAIL PROTECTED]> wrote in message
news:<[EMAIL PROTECTED]>...
> Dear Friends,
>
> I had difficulty reading huge excel data into sas.
> I tried the following code, but it always says "physical file does not
> exist". I need your help.
>
> My code:
> ===
> filen
Eric Miller wrote:
>
> Dear Friends,
>
> I had difficulty reading huge excel data into sas.
> I tried the following code, but it always says "physical file does not
> exist". I need your help.
>
> My code:
> ===
> filename import dde 'excel|sheet1!r2c1:r379c15';
> data xra
