topic Re: put dates in titles in New SAS User

put dates in titles

mmea — Wed, 20 Jan 2021 08:45:27 GMT

I would like to put the current date in one title

currentdate +1 in the next title

currentdate+2 in the third title

I tried this

but it do not work;

%let day = %sysfunc(putn("&sysdate"d, ddmmyy10.));
%let day = &day;


title height=15pt color=Black  'TEST  &day &sysdate.';

title2 j=l color=gray  'TEST &day &sysdate+1 ';


proc report ..............

Re: put dates in titles

PeterClemmensen — Wed, 20 Jan 2021 08:55:20 GMT

See if you can use this as a template 🙂

%let day1 = %sysfunc(putn(%sysfunc(today())    , ddmmyy10.));
%let day2 = %sysfunc(putn(%sysfunc(today()) + 1, ddmmyy10.));
%let day3 = %sysfunc(putn(%sysfunc(today()) + 2, ddmmyy10.));

%put &day1. &day2. &day3.;

title  "&day1.";
title2 "&day2.";
title3 "&day3.";

proc report data=sashelp.class;
run;

title;

Re: put dates in titles

mmea — Wed, 20 Jan 2021 09:04:13 GMT



ods pdf notoc file="test_&todaysDate..pdf" ;
ods escapechar="^";


%let day1 = %sysfunc(putn(%sysfunc(today())    , ddmmyy10.));
%let day2 = %sysfunc(putn(%sysfunc(today()) + 1, ddmmyy10.));
%let day3 = %sysfunc(putn(%sysfunc(today()) + 2, ddmmyy10.));

%put &day1. &day2. &day3.;

title height=15pt color=Black  ' &day1.';
title2 j=l color=gray  ' &day1.';
title3 j=l color=gray  ' &day2.';
title4 j=l color=gray  ' &day3.';


options mprint;
title;


proc format;
    value colorf 0=#CBE5A1  1=#FFFF00  1-high = Firebrick;
run;

proc report data=Comp style(header) = {background = lightgray color = black};
	    columns hej nej leg day;
	    define hej /'hej ' group style(column)= [background = lightgray fontsize=2 font_weight = bold] style(header) = {background = lightgray frame=void};
		compute after region / style={bordertopcolor=black borderbottomcolor=black height=1px cellpadding=0};
        line ' '; 
        endcomp;
	    define nej / 'nej ' group style(column)= [background = lightgray fontsize=2] style(header) = {background = lightgray frame=void} ;
		define leg / 'leg ' group style(column)= [background = lightgray fontsize=2] style(header) = {background = lightgray frame=void};
		define day/' dage' group max style(column)= [background = lightgray fontsize=0.5 frame=void] style={background=colorf.} style(header) = {background = lightgray frame=void};
		
	run;


title;
ods pdf close;
ods _all_ close;

Re: put dates in titles

PeterClemmensen — Wed, 20 Jan 2021 09:06:35 GMT

I'm guessing there is a question here?

Remember to put macro variables in double quotation marks. Macro variables do not resolve in single quotation marks 🙂

Re: put dates in titles

Astounding — Wed, 20 Jan 2021 11:52:07 GMT

Use double quotes, not single quotes. Macro variable references in single quotes will not be resolved.

Re: put dates in titles

PeterClemmensen — Thu, 21 Jan 2021 12:20:23 GMT

@mmea Did this solve your problem?

Re: put dates in titles

mmea — Thu, 21 Jan 2021 12:21:44 GMT

YES - SORRY!