How can I show the date in the format of date9 in this SQL process?

Question

After I run this SAS SQL process. The date variable "EXVISDAT" showed in the results in a numerical way. How can I change the code to let the date variable "EXVISDAT" show in format of "date9."？

proc sql;
    create table test2 as
    select VISIT, Targetdays, Targetdays + '01JUL2019'd - 1 as EXVISDAT
    from data_in.chrono_visits_lts14424
    order by Targetdays
    ;
quit;

Answer 1

You can read about it in documentation.

In yours case, query will look like:

proc sql;
    create table test2 as
    select VISIT, Targetdays, Targetdays + '01JUL2019'd - 1 as EXVISDAT format=date9.
    from data_in.chrono_visits_lts14424
    order by Targetdays
    ;
quit;