Community talk about communities.sas.com. Meta!

sas Enterprise Guide 7.1 (64 Bit)

Reply
Frequent Contributor
Posts: 79

sas Enterprise Guide 7.1 (64 Bit)

Hi, 

I got my system upgraded to windows 10 and sas upgraded to 9.4 and EG 7.1

 

I have got all the necessary plugins installed but when I try to run the below query it thorws the below error. xls or xlsx are not getting imported via query, but when I inport them from EG settings (file--> import file) it is getting imported:

 

Proc import datafile="c:\Users\ID\test\Sample.xlsx"

out=sample

DBMS=xlsx replace;

run;

 

ERROR: DBMS type XLSX is not valid for import

 

same error occured when used excel or excelcs. Please advise

Super User
Posts: 10,209

Re: sas Enterprise Guide 7.1 (64 Bit)

Do you have SAS/ACCESS to PC Files licensed and installed? Run proc setinit and proc product_status.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 1 reply
  • 131 views
  • 0 likes
  • 2 in conversation