topic convert date in SAS Enterprise Guide

convert date

hk2013 — Mon, 02 Apr 2018 18:50:12 GMT

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

Re: convert date

TomKari — Mon, 02 Apr 2018 19:39:52 GMT

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

Re: convert date

ballardw — Tue, 03 Apr 2018 16:04:49 GMT

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.