topic Re: How to convert a character date into a numeric date? in SAS Studio

How to convert a character date into a numeric date?

5062917 — Sun, 21 Oct 2018 00:16:47 GMT

Hi,

I have a dataset where dates are stored as a character in the format, MMM DD YYYY, 00:00, e.g."Jun 26 2015, 08:38" or "Apr 9 2015, 20:15". Is there any way to turn this into a numeric date?

Thanks in advance 🙂

Re: How to convert a character date into a numeric date?

novinosrin — Sun, 21 Oct 2018 00:48:02 GMT

data have;
k="Apr 9 2015, 20:15  ";
output;
k="Jun 26 2015, 08:38";
output;
run;
data want;
set have;
k1=input(k,anydtdtm21.);
format k1 datetime20.;
run;

Re: How to convert a character date into a numeric date?

ballardw — Mon, 22 Oct 2018 16:01:55 GMT

@5062917 wrote:

Hi,

I have a dataset where dates are stored as a character in the format, MMM DD YYYY, 00:00, e.g."Jun 26 2015, 08:38" or "Apr 9 2015, 20:15". Is there any way to turn this into a numeric date?

Thanks in advance 🙂

Date (day information only) or datetime which includes the time portion? SAS does treat those differently and is important to be precise.