Date Format

[sallyjo]

Hi, does anyone know how to format a SAS Date as MonDDYYYY, like JAN012018? 

[PeterClemmensen]

Not sure if there is one 'out of the box', but you can roll out your own like this

proc format; 
  picture dtfmt (default=9)
    low - high = '%b%D%Y' (datatype=date)
  ;
run;

data test;
    date='01jan2018'd;
    format date dtfmt.;
run;

[sallyjo]

Thanks! How do I put a space between each, so it looks like Mon DD YYYY, JAN 01 2018?

[PeterClemmensen]

no problem 🙂 Change the length from 9 to 11 and add the spaces like this

proc format; 
  picture dtfmt (default=11)
    low - high = '%b %D %Y' (datatype=date)
  ;
run;

data test;
    date='01jan2018'd;
    format date dtfmt.;
run;

[sallyjo]

Thanks!!!!

[PeterClemmensen · Accepted solution]

Anytime, glad to help 🙂 Please remember to mark the appropriate answer as an accepted solution. This helps future users navigate the community 

[ballardw]

---

@sallyjo wrote:
Thanks! How do I put a space between each, so it looks like Mon DD YYYY, JAN 01 2018?

---

There is the SAS supplied WORDDATE12. format that displays as Jan 1, 2018 if interested. Wider widths such as WORDDATE18. spell out the month to January 1, 2018. Of course if you don't want a comma this isn't the format for you.

[sallyjo]

Thanks!