sas Enterprise Guide 7.1 (64 Bit)

don21 — Thu, 31 May 2018 11:50:19 GMT

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

Re: sas Enterprise Guide 7.1 (64 Bit)

Kurt_Bremser — Thu, 31 May 2018 13:00:32 GMT

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

topic Re: sas Enterprise Guide 7.1 (64 Bit) in All Things Community

sas Enterprise Guide 7.1 (64 Bit)

Re: sas Enterprise Guide 7.1 (64 Bit)