topic SAS Date format in SAS Programming

SAS Date format

zimcom — Fri, 30 Aug 2019 16:30:07 GMT

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

Re: SAS Date format

novinosrin — Fri, 30 Aug 2019 16:38:13 GMT

Try

date11.;



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

Re: SAS Date format

zimcom — Fri, 30 Aug 2019 16:39:15 GMT

THANK YOU !!
Have a great weekend!

Re: SAS Date format

Jagadishkatam — Fri, 30 Aug 2019 16:39:22 GMT

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
;

Re: SAS Date format

zimcom — Fri, 30 Aug 2019 16:41:11 GMT

date11.;

works perfect!

Thank you!

Re: SAS Date format

Jagadishkatam — Fri, 30 Aug 2019 16:42:52 GMT

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

Re: SAS Date format

ballardw — Fri, 30 Aug 2019 20:19:52 GMT

@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.