Which works well, and the file is imported. However, the colums which are in time format in the excel file (yes, formated corectly in the excel file) are imported as date. Same thing happening with columns that are datetime in the excel file
Even if i try to set the data to a new set and force a format on these columns, it dosent work:
format op_date_time datetime21.;
format op_time time8.;
I guess one way to solve this is importing excel files using libname solution. But is there a way with proc import to instruct SAS to the time/datetime nature of some of the columns
Not within PROC IMPORT but within a libname you can use DBSASTYPE.
Try the XLSX engine if that's an option, available is SAS 9.3+
SAS INNOVATE 2024
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.