topic Multiple format in character date to mm/dd/yyyy format in SAS Programming

Multiple format in character date to mm/dd/yyyy format

krishah_sas — Wed, 23 Nov 2016 18:14:06 GMT

Hello,

I have a character variable and it has two different formats for date:

2016-02-23

02/23/2016

How can I convert this inot single date format as 02/23/2016 for all the values.

Thank you.

Haikuo — Wed, 23 Nov 2016 19:04:34 GMT

If you only these two variations, then

data test;
input dt anydtdte20.;
format dt date9.;
cards;
2016-02-23
02/23/2016
;