Date:         Fri, 9 Dec 2005 11:07:27 -0500
Reply-To:     Jim Groeneveld <jim1stat@YAHOO.CO.UK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jim Groeneveld <jim1stat@YAHOO.CO.UK>
Subject:      Re: Weired "Expecting a name" error on PROC IMPORT
Comments: To: joystar.jin@GMAIL.COM

Hi Mark,

That error message often appears in the log way after the real error.
Please also send that part of the log to SAS-L where the error emerges
firstly and the underlining of the error in the program line.

Only then we can help you further. This is an example of too less info.

Regards - Jim.
--
Y. (Jim) Groeneveld, MSc., Biostatistician, Vitatron b.v., NL
Jim.Groeneveld_AT_Vitatron.com (replace _AT_ by AT sign)
http://www.vitatron.com, http://home.hccnet.nl/jim.groeneveld

My computer regards me as its master, but I seem to be its slave.

[common disclaimer]

On Fri, 9 Dec 2005 07:29:19 -0800, Mark <joystar.jin@GMAIL.COM> wrote:

>I am using SAS 8. Sometimes I got weird error from PROC IMPORT like
>below.
>It always says "ERROR 22-322: Expecting a name". From my observation,
>this error
>tends to happen when the path of the file is long OR the name of the
>excel file is long.
>
>I can't figure out. Does anyone has similar experience? Your help is
>appreciated.
>
>proc import  datafile='c:\temp\a\b\c\d\abc_cde_fgh_123.xls'
>                out=work.abc dbms=excel replace;
>          getnames=yes;
>run;
>
>ERROR 22-322: Expecting a name.
>ERROR 76-322: Syntax error, statement will be ignored.
>ERROR: Import unsuccessful.  See SAS Log for details.
>
>Thanks,
>
>Mark