data l;
input dt $ 1-20;
dt1=input(dt,ddmmyy10.);
format dt1 ddmmyy10.;
cards;
13/01/2011
12/02/2009
15/02/2009
run;
proc print;
run;
proc sql;
select max(dt1)into :max_dt from l;
quit;
The macro variables max_dt is resoving to 18640 but i want to get the date format like this 3/01/2011
as i want to add this macro variable to the output file with the date if it is showing as 18640
it is problem for me or it can show as 03_jan_2011
You have to explicitly specify the format with into: clause:
select max(dt1) format=ddmmyy10. into: max_dt from l;
/Linus
Hi,
LinusH's example is correct. You might want to check your table again.
Thqs Linus it worked
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.