proc report date format

[radha009]

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

17MAY18:10:00:00

17MAY18:10:00:00

[PaigeMiller]

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

[Tom]

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?