Desktop productivity for business analysts and programmers

convert date

Reply
Contributor
Posts: 30

convert date

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

PROC Star
Posts: 1,265

Re: convert date

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

Re: convert date

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.

Ask a Question
Discussion stats
  • 2 replies
  • 112 views
  • 0 likes
  • 3 in conversation