topic Reg: Format for Macro Variable in SAS Programming

Reg: Format for Macro Variable

R_Win — Wed, 16 Nov 2011 09:34:21 GMT

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

Reg: Format for Macro Variable

LinusH — Wed, 16 Nov 2011 09:44:49 GMT

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

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

/Linus

Reg: Format for Macro Variable

milts — Wed, 16 Nov 2011 10:05:59 GMT

Hi,

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

Reg: Format for Macro Variable

R_Win — Wed, 16 Nov 2011 10:13:37 GMT

Thqs Linus it worked