Prev: Can ODS create Excel output?
Next: Regarding Graph output
From: mark on 3 Mar 2010 21:41
I use the code below and get error in log.

PROC IMPORT OUT=WORK.laptopdata
DATAFILE = "C:\laptop_review.xls"
DBMS=EXCEL REPLACE;
RANGE="Review$";
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
proc print data = laptopdata;
RUN;

The log -


385 PROC IMPORT OUT=WORK.laptopdata
386 DATAFILE = "C:\laptop_review.xls"

--------------------------------------------
49
NOTE 49-169: The meaning of an identifier after a quoted string may
change in a future SAS release.
Inserting white space between a quoted string and the
succeeding identifier is
recommended.

Kindly guide,
markc
From: bigD on 3 Mar 2010 22:16
It's a note, not an error. Was your data imported?

The quoted string warning comes up a lot.

On Mar 3, 9:41 pm, mark <mark.chas...(a)yahoo.in> wrote:
> I use the code below and get error in log.
>
> PROC IMPORT OUT=WORK.laptopdata
>             DATAFILE = "C:\laptop_review.xls"
>             DBMS=EXCEL REPLACE;
>      RANGE="Review$";
>      GETNAMES=YES;
>      MIXED=NO;
>      SCANTEXT=YES;
>      USEDATE=YES;
>      SCANTIME=YES;
> proc print data = laptopdata;
> RUN;
>
> The log -
>
> 385  PROC IMPORT OUT=WORK.laptopdata
> 386              DATAFILE = "C:\laptop_review.xls"
>
> --------------------------------------------
>                                                  49
> NOTE 49-169: The meaning of an identifier after a quoted string may
> change in a future SAS release.
>              Inserting white space between a quoted string and the
> succeeding identifier is
>              recommended.
>
> Kindly guide,
> markc

From: Joe Matise on 4 Mar 2010 11:50
My vote is you have something wrong before it - usually that means to me
that there was an unbalanced quotation mark before it and so it considers
the C to be after the end of a string.

-Joe

On Wed, Mar 3, 2010 at 8:41 PM, mark <mark.chase91(a)yahoo.in> wrote:

> I use the code below and get error in log.
>
> PROC IMPORT OUT=WORK.laptopdata
> DATAFILE = "C:\laptop_review.xls"
> DBMS=EXCEL REPLACE;
> RANGE="Review$";
> GETNAMES=YES;
> MIXED=NO;
> SCANTEXT=YES;
> USEDATE=YES;
> SCANTIME=YES;
> proc print data = laptopdata;
> RUN;
>
> The log -
>
>
> 385 PROC IMPORT OUT=WORK.laptopdata
> 386 DATAFILE = "C:\laptop_review.xls"
>
> --------------------------------------------
> 49
> NOTE 49-169: The meaning of an identifier after a quoted string may
> change in a future SAS release.
> Inserting white space between a quoted string and the
> succeeding identifier is
> recommended.
>
> Kindly guide,
> markc
>
From: Katy Seib on 4 Mar 2010 11:47
For what it's worth, I import large excel spreadsheets into SAS weekly and
since I started saving as csv file for importing, any problems with import
have all but disappeared. The Excel to SAS transfer does not seem to do
well with missing data and is terrible at guessing the correct format for
dates. I format my dates in excel (MM/DD/YYYY), save as csv and then import
and get MUCH better results. It's a little bit extra work but can save a
lot of cleanup in SAS.

Katy

On Wed, Mar 3, 2010 at 9:41 PM, mark <mark.chase91(a)yahoo.in> wrote:

> I use the code below and get error in log.
>
> PROC IMPORT OUT=WORK.laptopdata
> DATAFILE = "C:\laptop_review.xls"
> DBMS=EXCEL REPLACE;
> RANGE="Review$";
> GETNAMES=YES;
> MIXED=NO;
> SCANTEXT=YES;
> USEDATE=YES;
> SCANTIME=YES;
> proc print data = laptopdata;
> RUN;
>
> The log -
>
>
> 385 PROC IMPORT OUT=WORK.laptopdata
> 386 DATAFILE = "C:\laptop_review.xls"
>
> --------------------------------------------
> 49
> NOTE 49-169: The meaning of an identifier after a quoted string may
> change in a future SAS release.
> Inserting white space between a quoted string and the
> succeeding identifier is
> recommended.
>
> Kindly guide,
> markc
>
 | 
Pages: 1
Prev: Can ODS create Excel output?
Next: Regarding Graph output