help with date format

[tonywu]

hi guys,

Hope you could help with this simple request.

So basically I want to extract the minimum date in an existing SAS dataset.

I used following to extract it, however the date format is not desired. It is different from original data source.

Any idea on how i could extract the the ddmmyyy format?

Thanks in advance.

tonywu_0-1619162081300.pngtonywu_1-1619162091239.png

[japelin]

Try to specify the format like this

proc sql;
  create table sample as 
    select var format=date9. from test;
quit;

[tonywu]

thanks mate, it worked!

[tonywu]

thanks mate, it worked!

[Kurt_Bremser]

Add a format definition

min(from_date) as min_from format=yymmdd10.