SAS Date format

[zimcom]

Hi all,

Is there a SAS format to make the date appearing as shown below:

04-Sep-2017

14-Jun-2015

21-May-2016

Thanks

zimcom

[novinosrin · Accepted solution]

Try

date11.;

data test;
input date :date11.;
format date date11.;
cards;
04-Sep-2017
14-Jun-2015
21-May-2016
;

[zimcom]

THANK YOU !!
Have a great weekend!

[Jagadishkatam]

I checked but not sure if there is any such format, but if you need the date in that format probably you can try the below code with prxchange function which generates a character variable of date in the expected format.

data have;
input date:date10.;
new=prxchange('s/(\d{1,2})(\w{3})(\d{4})/$1-$2-$3/',-1,strip(put(date,date9.)));
format date date9.;
cards;
04-Sep-2017
14-Jun-2015
21-May-2016
;

[zimcom]

date11.;

works perfect!

Thank you! 

[Jagadishkatam]

Its interesting, I never used it.
Thanks to @novinosrin now i know when to use it.

[ballardw]

---

@Jagadishkatam wrote:

I checked but not sure if there is any such format, but if you need the date in that format probably you can try the below code with prxchange function which generates a character variable of date in the expected format.

data have;
input date:date10.;
new=prxchange('s/(\d{1,2})(\w{3})(\d{4})/$1-$2-$3/',-1,strip(put(date,date9.)));
format date date9.;
cards;
04-Sep-2017
14-Jun-2015
21-May-2016
;

---

This looks like a case of using a tool one is more familiar with. Proc Format has a lot of options for making custom formats if one such as Date11 didn't work. Consider if the OP had wanted @ characters instead of dashes [admittedly not a likely need but to illustrate]:

proc format library=work;
Picture mydatefmt (default=11)
  low-high= '%0d@%b@%Y' (datatype=date);
run;

data _null_;
   x='23JAN2019'd;
   put x= mydatefmt.;
run;

So with the available format we don't have to modify the data set, just use the new format for the procedure output.