BookmarkSubscribeRSS Feed
Navin2015
Calcite | Level 5

I do have a base SAS 9.4 installed on my computer . looks like there are some restrictions to it. I have been trying to import the excel files into the SAS but it is not letting me do it. I tried using older excel format 2003-007 and also tried using latest excel 2013. none of them work.

here is the log.

NOTE: Additional host information:

X64_7PRO WIN 6.1.7601 Service Pack 1 Workstation

NOTE: SAS initialization used:

      real time           1.33 seconds

      cpu time            0.56 seconds

1

2

3    libname xdb excel "C:\Users\nabinneupane\Desktop\IP.xlsx";

ERROR: The EXCEL engine cannot be found.

ERROR: Error in the LIBNAME statement.

4

5    PROC IMPORT OUT= WORK.EMPLOYEE

6                DATAFILE= "C:\Users\nabinneupane\Desktop\IP.xlsx"

7                DBMS=xlsx REPLACE ;

ERROR: DBMS type XLSX not valid for import.

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

NOTE: PROCEDURE IMPORT used (Total process tiing eceme):

      real time           0.00 seconds

      cpu time            0.00 seconds

8    GETNAMES=YES;

9    MIXED=NO;

10   SCANTEXT=YES;

11   USEDATE=YES;

12   SCANTIME=YES;

13   RUN;

7 REPLIES 7
Reeza
Super User

Do you have SAS/Access licensed and installed?

Try running the following to see what's installed and included in your version of SAS.

proc setinit; run;

and/or

proc productstatus; run;

Navin2015
Calcite | Level 5

I did and this is what it was on the log file.

Grace Period:  45 days (ending 29OCT2015).

Warning Period: 45 days (ending 13DEC2015).

System birthday:   27NOV2014.

Operating System:   WX64_WKS.

Product expiration dates:

---Base SAS Software

      14SEP2015

---SAS/STAT

      14SEP2015

---SAS/GRAPH

      14SEP2015

---SAS/Secure 168-bit

      14SEP2015

---SAS/Secure Windows

      14SEP2015

---SAS Enterprise Guide

      14SEP2015

---SAS Workspace Server for Local Access

      14SEP2015

---High Performance Suite

      14SEP2015

but I was able to export from SAS to Excel not just been able to import excel files.

Ksharp
Super User

DBMS=excelcs    ?

DBMS=xls    ?

Jagadishkatam
Amethyst | Level 16

Hi Reeza,

I was earlier aware of proc setinit, but product status is something i came to know from you. Thanks for that.

i tried to run proc productstatus;run; however just a small correction:smileysilly:, it is product_status.

Thanks,

Jag

Thanks,
Jag
Kurt_Bremser
Super User

Save the Excel spreadsheet as .csv and import that.

- you don't need any additional SAS license (saves $$$)

- importing in a data step gives you more control over the data, a structural change will generate an error

- the data step is completely platform-independent, you only have to look at the charsets when you transfer data between platforms

overmar
Obsidian | Level 7

Navin,

I had the same problem with 9.3, but it resolved with 9.4, but only when the SAS/Microsoft Office Plugin was properly installed. At the moment the issue that you likely are currently having though is you need to use dbms=excel.

Hope this helps

jakarman
Barite | Level 11

I do not see the access to pcfiles product.

Without that one many of the interfaces to excel will not be there.

There are some work arround but the Libname excel engine and proc import will not operate on native excel

---->-- ja karman --<-----

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 7 replies
  • 2604 views
  • 0 likes
  • 7 in conversation