this doesn't work when using it from UNIX sas. log says NOTE: Libref TEST12 was successfully assigned as follows: Engine: XLSX Physical Name: /xxxxx/yyyyy.xlsx 24 25 26 27 data sheet1; 28 29 set test12."Sheet1$"n(dbSASType=(HADMDTTM=datetime IADMDTTM=dateTime)); _________ 22 ERROR 22-7: Invalid option name DBSASTYPE. 30 31 run;
... View more