topic Re: SAS Date issue in SAS Programming

SAS Date issue

Jyuen204 — Wed, 10 Jun 2020 15:20:33 GMT

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'

Re: SAS Date issue

smantha — Wed, 10 Jun 2020 15:24:26 GMT

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

Re: SAS Date issue

mklangley — Wed, 10 Jun 2020 15:25:07 GMT

MAX(XDATE) as XDATE format mmddyyd10.

Re: SAS Date issue

ballardw — Wed, 10 Jun 2020 15:36:51 GMT

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.

Re: SAS Date issue

Jyuen204 — Wed, 10 Jun 2020 15:43:17 GMT

Thank you Thank you!