topic Splitting one column into two in SAS Enterprise Guide

Splitting one column into two

sheren_deep1 — Tue, 13 Jun 2017 09:01:42 GMT

Hi,

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.

Can someone help on how to do this?

Thanks

Re: Splitting one column into two

RW9 — Tue, 13 Jun 2017 09:28:10 GMT

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;