Reg: Format for Macro Variable

[R_Win]

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

[LinusH]

You have to explicitly specify the format with into: clause:

select max(dt1) format=ddmmyy10. into: max_dt from l;

/Linus

[milts]

Hi,

LinusH's example is correct. You might want to check your table again.

[R_Win]

Thqs Linus it worked