topic proc report date format in SAS Programming

proc report date format

radha009 — Tue, 15 May 2018 17:38:25 GMT

my date field displays as , in proc report i want to

define date / display format=DDMMYY10.;

expecting display in 05/16/2018 format

Date

16MAY18:16:00:00

16MAY18:20:00:00

17MAY18:10:00:00

PaigeMiller — Tue, 15 May 2018 17:53:50 GMT

Show us the entire PROC REPORT code. Show us the SASLOG. Show us the entire PROC REPORT output.

Tom — Tue, 15 May 2018 18:34:05 GMT

The FORMAT DDMMYY. works on DATE values. But it looks like you want to display DATETIME values.

Dates are stored as number of days and datetime is stored as a number of seconds.

If you try to display a date using a datetime format it will look like your values are from early in 1960.

If you try to display a datetime value using a date format then you will probably get an error since the year value will be more than 4 digits ong!

What values are in your actual data? If they are dates why would you want to add/display a time part?