Character Year-Mon to Number Mon-Year

[Almighty]

Hi all,

Could you please let me know how to convert character year-month to number MonYear.  The sample data below.

Pt No.          date_have(character)          Date_need(numberic)

1001               2001-10                              OCT2001

1002               2010-08                              AUG2010

1003               2009-01                              JAN2009

Thanks in advance

[slchen · Accepted solution]

data want;
  set have;
  date_need=input(date_have,anydtdte7.);
  format date_need monyy7.;
  run;