changing character to date format

[ashishj816]

I have date in character format and i want to convert it into date format

Ex:-

date(In character)

2003-01

2006-11

2016-02

this is year and then month

i want to convert in date format like

date(In Date format)

Jan2003

Nov-2006

Feb2016

[RW9]

You can't directly.  SAS only treats full and valid dates as date values.  So what you need to do is to padd out what you have with day, then apply a format which only displays MM-YYYY - even though behind the scenes the date is complete:

data want;
  dt="2003-01";
  actual=input(cats(dt,"-01"),yymmdd10.);
  format actual mmyy8.;
run;

[Loko]

hello,

data have;
infile datalines;
input a $7.;
a=compress(a,'-');
b=input(a,yymmn6.);
format b monyy7.;
datalines;
2003-01
2006-11
2016-02
;

[Ksharp · Accepted solution]

data want;
  dt="2003-01";
  actual=input(dt,anydtdte.);
  format actual monyy7.;
run;

[ashishj816]

This is also working for me thanks.