SAS can't read / import MS-Excel file

gerben_umcg — Thu, 02 Jan 2020 13:49:45 GMT

Hi.

Today I installed SAS 9.4 at the laptop of a customer.

And I tryed to read a MS-Excel file.

I got the next error message:

-=-=-=- * start error message * -=-=-=-

NOTE: SAS (r) Proprietary Software 9.4 (TS1M0)

Licensed to UNIV. MED. CENTR. GRONINGEN / SURFDIENSTEN, Site 70129971.

NOTE: This session is executing on the X64_7PRO platform.

NOTE: Updated analytical products:

SAS/STAT 12.3 (maintenance)

SAS/ETS 12.3 (maintenance)

SAS/OR 12.3 (maintenance)

SAS/IML 12.3 (maintenance)

SAS/QC 12.3 (maintenance)

NOTE: Additional host information:

X64_7PRO WIN 6.1.7601 Service Pack 1 Workstation

NOTE: SAS initialization used:

real time 4.22 seconds

cpu time 2.51 seconds

ERROR: Connect: Klasse is niet geregistreerd

ERROR: Error in the LIBNAME statement.

Connection Failed. See log for details.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE IMPORT used (Total process time):

real time 1.55 seconds

cpu time 0.84 seconds

ERROR: Connect: Klasse is niet geregistreerd

ERROR: Error in the LIBNAME statement.

NOTE: Unable to open parameter catalog: SASUSER.PARMS.PARMS.SLIST in update mode. Temporary

parameter values will be saved to WORK.PARMS.PARMS.SLIST.

ERROR: File is in use, \\xxx\xxx\xxx\Map1.csv.

ERROR: Import unsuccessful. See SAS Log for details.

-=-=-=- * end error message * -=-=-=-

What can be the sulotion for it?

Kind regards,

Gerben Veenstra.

Re: SAS can't read / import MS-Excel file

Tom — Thu, 02 Jan 2020 13:56:29 GMT

Your error message does not say anything about any Excel files. It does say that the CSV file you are trying to read is already open by some other process. Close that process and try again. Note that to read a CSV file there is no need to use PROC IMPORT as a simple data step can easily read a delimited text file.

Re: SAS can't read / import MS-Excel file

mkeintz — Thu, 02 Jan 2020 23:15:01 GMT

Windows 7?

Microsoft support for windows 7 will end Jan 14th. I presume that applies in every country.

topic Re: SAS can't read / import MS-Excel file in New SAS User

SAS can't read / import MS-Excel file

Re: SAS can't read / import MS-Excel file

Re: SAS can't read / import MS-Excel file