topic Re: help with date format in SAS Programming

help with date format

tonywu — Fri, 23 Apr 2021 07:15:24 GMT

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.

japelin — Fri, 23 Apr 2021 07:23:43 GMT

Try to specify the format like this

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

Kurt_Bremser — Fri, 23 Apr 2021 07:26:00 GMT

Add a format definition

min(from_date) as min_from format=yymmdd10.

tonywu — Sat, 24 Apr 2021 08:03:13 GMT

thanks mate, it worked!

tonywu — Sat, 24 Apr 2021 08:03:42 GMT

thanks mate, it worked!