topic Date format in SAS Programming

Date format

Sathish_jammy — Wed, 18 Jul 2018 10:44:10 GMT

Hi community,

In the given table few of dates are not convert to the actual column pls help me to resolve it.

data dos;
set proj.saswrk;
diab_date = input(strip(diab_dateonset),mmddyy10.);
format diab_date mmddyy10.;
run;

Diab_dateonset - varchar datatype

PaigeMiller — Wed, 18 Jul 2018 10:51:55 GMT

You want ddmmyy format and informat.

You can't use format or informat mmddyy because some of your date values begin with 14 or 25 and there's no month 14 or 25.

Sathish_jammy — Wed, 18 Jul 2018 10:59:04 GMT

Ohw !...

Thank you buddy!

Reeza — Wed, 18 Jul 2018 16:11:34 GMT

@Sathish_jammy Please mark @PaigeMiller answer as the solution, so others know this is solved.

Sathish_jammy — Thu, 19 Jul 2018 04:09:23 GMT

Sorry!