ODS Proc report

[DLROW]

Hi,

I need the date to be like 02Jan2018, but when I export to excel it is 2jan2018.  I am not using any date format because the data itself is in 02Jan2018 formatting. 

Proc report Data=date nowd;

define date / display "date";

run;

[Reeza]

How are you exporting your file to Excel? I suspect Excel is mangling it, so you'll need to force the format. There's different ways to do that, depending on how you're exporting your file.

---

@DLROW wrote:

Hi,

I need the date to be like 02Jan2018, but when I export to excel it is 2jan2018.  I am not using any date format because the data itself is in 02Jan2018 formatting. 

Proc report Data=date nowd;

define date / display "date";

run;

---

[Cynthia_sas · Accepted solution]

Hi:

  Even if you're using ODS EXCEL, you may still need to use TAGATTR in your PROC REPORT so you get the leading zero on the day part of the date, as shown below:

Hope this helps,

Cynthia

[DLROW]

Thank you, Cynthia. It works.