Prev: Duplicate Observations
Next: SAS Technical support
From: V G on 19 Jun 2010 22:18
Hi,

I am new to SAS 9.1, and in attempting to import an Excel file, I get
an error message in the Log that Excel is not valid for DBMS. It makes
no sense.

Please assist with the following code:

proc import DATAFILE= "C:\Documents and Settings\gshrivi\My Documents\V
\Test.xls"

OUT= WORK.SAS_Import_Test

DBMS=Excel;

sheet='Data';

getnames=no;
run;

Thanks
From: Arthur Tabachneck on 20 Jun 2010 08:02
VG,

Do you licence SAS/ACCESS for PC file formats?

Art
-------------
On Jun 19, 10:18 pm, V G <vidya.seat...(a)gmail.com> wrote:
> Hi,
>
> I am new to SAS 9.1, and in attempting to import an Excel file, I get
> an error message in the Log that Excel is not valid for DBMS. It makes
> no sense.
>
> Please assist with the following code:
>
> proc import DATAFILE= "C:\Documents and Settings\gshrivi\My Documents\V
> \Test.xls"
>
>      OUT= WORK.SAS_Import_Test
>
>          DBMS=Excel;
>
>      sheet='Data';
>
>      getnames=no;
> run;
>
> Thanks

From: Bakary on 21 Jun 2010 04:53
On Jun 20, 2:02 pm, Arthur Tabachneck <art...(a)netscape.net> wrote:
> VG,
>
> Do you licence SAS/ACCESS for PC file formats?
>
> Art
> -------------
> On Jun 19, 10:18 pm, V G <vidya.seat...(a)gmail.com> wrote:
>
>
>
> > Hi,
>
> > I am new to SAS 9.1, and in attempting to import an Excel file, I get
> > an error message in the Log that Excel is not valid for DBMS. It makes
> > no sense.
>
> > Please assist with the following code:
>
dear,
try this lines;
*************************************
proc import OUT= WORK.SAS_Import_Test
DATAFILE= "C:\Documents and Settings\gshrivi\My Documents\V\Test.xls"
DBMS=EXCEL2000 REPLACE;
sheet='"data";
getnames=no;
run;
************************************

>

> > proc import DATAFILE= "C:\Documents and Settings\gshrivi\My Documents\V
> > \Test.xls"
>
> >      OUT= WORK.SAS_Import_Test
>
> >          DBMS=Excel;
>
> >      sheet='Data';
>
> >      getnames=no;
> > run;
>
> > Thanks

 | 
Pages: 1
Prev: Duplicate Observations
Next: SAS Technical support