@Vic wrote:
sorry for the delay in reply. The dbsastype works fine with my SAS Base at work, but I do not use the proc import. Unfortunally it seems that dbsastype is not supported in the University Edition of SAS. Regards, Vic
The DBSASTYPE is not supportted for the XLSX engine. You can use it with the EXCEL engine (and ORACLE, TERADATA, etc).
But the SAS/Universtity Edition does not support the EXCEL engine because that requires actually running Microsoft's Jet Engine software which is not available on the Unix virtual machine where SAS is running (or any Unix machine that I know of).
If you have messy data in Excel files then convert them to CSV files and write your own data step to read them.
... View more