topic ODS Proc report in New SAS User

ODS Proc report

DLROW — Mon, 07 Jan 2019 01:15:52 GMT

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;

Re: ODS Proc report

Reeza — Mon, 07 Jan 2019 02:49:20 GMT

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;

Re: ODS Proc report

Cynthia_sas — Mon, 07 Jan 2019 03:04:07 GMT

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

Re: ODS Proc report

DLROW — Mon, 07 Jan 2019 14:41:59 GMT

Thank you, Cynthia. It works.