topic Re: importing from excel file in Microsoft Integration with SAS

importing from excel file

Dav1412 — Sat, 27 Feb 2016 15:42:22 GMT

PROC IMPORT OUT= WORK.EMPLOYEE
DATAFILE= "E:\LDATA\DATA.xlsx"
DBMS=EXCEL REPLACE ;
GETNAMES=YES;
MIXED=NO;
SCANTEXT=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;

ERROR: DBMS type EXCEL not valid for import.

anyone can help

Re: importing from excel file

Kurt_Bremser — Sat, 27 Feb 2016 17:08:26 GMT

To use this, you need SAS/ACCESS to PC Files

If you run SAS 9.4, try DBMS=XLSX.

Re: importing from excel file

Dav1412 — Sat, 27 Feb 2016 17:31:12 GMT

thanks for reply. still no luck. here is log below :-

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

56 PROC IMPORT OUT= WORK.EMPLOYEE

57 DATAFILE= "E:\LDATA\DATA1.xlsx"

58 DBMS=XLSX REPLACE ;

NOTE: The previous statement has been deleted.

59 GETNAMES=YES;

60 MIXED=NO;

_____

180

61 SCANTEXT=YES;

________

180

62 USEDATE=YES;

_______

180

63 SCANTIME=YES;

________

180

ERROR 180-322: Statement is not valid or it is used out of proper order.

64 RUN;

ERROR: Physical file does not exist, /opt/sasinside/SASConfig/Lev1/SASApp/E:\LDATA\/DATA1.xlsx.

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

NOTE: PROCEDURE IMPORT used (Total process time):

real time 0.01 seconds

cpu time 0.01 seconds

66 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

Re: importing from excel file

Reeza — Sat, 27 Feb 2016 17:42:43 GMT

It looks like your working on a Server. What type of SAS are you using, EG, Studio, On Demand?

Re: importing from excel file

Dav1412 — Sat, 27 Feb 2016 17:46:16 GMT

Using SAS studio.

Re: importing from excel file

Reeza — Sat, 27 Feb 2016 18:06:51 GMT

University Edition? Or with your own server?

If UE did you set up your shared drive as indicated in the instructions.

If so, place the file in the myfolders and reference it as '/folders/myfolders/myfile.xlsx' in your infile.

Re: importing from excel file

Reeza — Sat, 27 Feb 2016 18:06:51 GMT

University Edition? Or with your own server?

If UE did you set up your shared drive as indicated in the instructions.

If so, place the file in the myfolders and reference it as '/folders/myfolders/myfile.xlsx' in your infile.