USEDATE SCANTIME when importing Excel

[ysk]

Hi there,

I'm currently using 64-bit SAS and trying to import 32-bit Excel (xlsx) file.

Previously when using 32-bit SAS i was able to import using a code similar to below.

PROC IMPORT OUT= test
DATAFILE= "c:\test.xlsx"
DBMS=xlsx REPLACE;
GETNAMES=YES;
MIXED=YES;
USEDATE=YES;
SCANTIME=YES;
RUN;

But now that i have changed to 64bit system i can no longer keep the GETNAMES, MIXED, USEDATE, SCANTIME features this ultimately changes the formatting of the date fields so i have to add manual lines of codes to change it.

Is there a way to use the same code as shown above in 64 bit system? 

Thanks

[Damo]

Hi @ysk

Sorry I can't test that for you but you may find some useful information with those links.

Did you get a chance to read Microsoft Excel Workbook Files? 

Maybe you can use DBMS=EXCEL. Maybe.

SAS PC Files Server might be what you need in the end.

You can install it from your depot or you can download the package it from https://support.sas.com/downloads/package.htm?pid=753.

Then the page to use is Importing and Exporting Microsoft Office Files When SAS 9.4 and the SAS PC Files Server Are on the S....

Hope that helps.

Cheers,
Damo