How to convert a character date into a numeric date?

[5062917]

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 🙂 

[novinosrin]

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;

[ballardw]

---

@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.