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.
Try to specify the format like this
proc sql;
create table sample as
select var format=date9. from test;
quit;
thanks mate, it worked!
thanks mate, it worked!
Add a format definition
min(from_date) as min_from format=yymmdd10.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.