SAS Date issue

[Jyuen204]

I have a volatile table built wilh a set of values
ID           XDATE

123        02APR2020

234        06FEB2020

234        03MAR2020
.....

I am querying the Max date grouped by the ID
PROC SQL;
select ID, MAX(XDATE) as XDATE from TABLE1
group by ID;
run;

I get the result as 
ID         XDATE
123      22007
234      22046
345      21970

How do i get a date output like '12-31-2999'

[smantha · Accepted solution]

PROC SQL;
select ID, MAX(XDATE) as XDATE format=mmddyy10. from TABLE1
group by ID;
run;

[Jyuen204]

Thank you Thank you!

[mklangley]

MAX(XDATE) as XDATE format mmddyyd10.

[ballardw]

In SQL when you use a function with AS NEWVARIABLE then the result will use the default numeric format, which is BEST because you did not tell SAS you wanted a different one.