10-26-2017 03:10 PM
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
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?
10-26-2017 04:31 PM
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.
Hope that helps.