I want to split a column namely InvoiceDate which contains information of both time and date into two columsn namely Date and TIme by using SAS Enterprise Guide.
Post test data in the form of a datastep, we cannot see what you are using. I am going to asume this variable is a dateteime variable in which case:
data want;
set have;
dt=datepart(datetime_variable);
tm=timepart(datetime_variable);
format dt date9. tm time5.;
run;
2025 SAS Hackathon: There is still time!
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!