convert date

[hk2013]

I have date in DDMMYYYY (29mar2018) format and i want to convert it to MMM-YYYY (Mar-2018) 

[TomKari]

data Example;
	length OutDate $8;
	InDate = "29mar2018";
	SASDateValue = input(InDate, date9.);
	format SASDateValue date9.;
	OutDate = put(SASDateValue, monname3.)||"-"||put(SASDateValue, year4.);
run;

[ballardw]

SAS allows for the creation of your own date formats using the picture statement in proc format:

proc format library=work;
picture mymonyy (default=8)
low-high ='%b-%Y' (datatype=date);
run;

If the value is an actual SAS date valued numeric then use the mymonyy. format for any procedure to display the value.

Note that in the code aboe the %b and %Y are case sensitive. Capitalization of the month will depend on your Local setting any you may want to try %3B if %b doesn't look the way you want.