DATA Step, Macro, Functions and more

Reg: Format for Macro Variable

Reply
Regular Contributor
Posts: 229

Reg: Format for Macro Variable

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

Super User
Posts: 5,257

Reg: Format for Macro Variable

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

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

/Linus

Data never sleeps
Super Contributor
Posts: 319

Reg: Format for Macro Variable

Hi,

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

Regular Contributor
Posts: 229

Reg: Format for Macro Variable

Thqs Linus it worked

Ask a Question
Discussion stats
  • 3 replies
  • 140 views
  • 0 likes
  • 3 in conversation