topic Format date to date format in SAS Procedures

Format date to date format

BETO — Tue, 28 Oct 2014 20:34:37 GMT

I'm need to convert a col that should be date..

Date

0929

1014

1015

I would need to convert the date. to format

Date

09/29/14

10/14/14

10/15/14

Thank You

stat_sas — Tue, 28 Oct 2014 20:48:57 GMT

data have;

input date $;

new_date=mdy(substr(date,1,2),substr(date,3,4),2014);

format new_date MMDDYY.;

datalines;

0929

1014

1015

;