DATA Step, Macro, Functions and more

data import error

Reply
New Contributor
Posts: 2

data import error

I am having an error when trying to import the Excel file in SAS.

SAS error.png

Super User
Posts: 19,770

Re: data import error

Posted in reply to villa131982

We (at least me) can't see that image at all.

Please post the code you've used and the error as text.

New Contributor
Posts: 2

Re: data import error

Thanks

This is the error.

ERROR: Connect: Clase no registrada
ERROR: Error in the LIBNAME statement.

I am not using code but importing the data as SAS allows to do it now.

Super User
Posts: 19,770

Re: data import error

Posted in reply to villa131982

Try a standard proc import.

 

proc import out=want datafile='path to xlsx file' dbms=XLSX replace;
run;
Super User
Posts: 11,343

Re: data import error

Posted in reply to villa131982

It is better to copy the text from the log and paste that here as text. The picture is too small to read.

Ask a Question
Discussion stats
  • 4 replies
  • 271 views
  • 0 likes
  • 3 in conversation