topic Having trouble creating a date variable to use in report headings in SAS Enterprise Guide

Having trouble creating a date variable to use in report headings

Dick_Shryock — Tue, 28 Jun 2011 21:09:45 GMT

Hi,

I would like to add a date to my reports both in the heading and the file name when I export them. Can someone help.

Thanks,

-d

Having trouble creating a date variable to use in report headings

Patrick — Wed, 29 Jun 2011 00:29:45 GMT

You could use syntax like below:

title "This report created on %sysfunc(today(),yymmddn8.)";
proc print data=sashelp.class;
run;

%put &sysdate;

title "This report created on %sysfunc(today(),yymmddn8.)";
proc print data=sashelp.class;
run;

There is also an automatic macro var &sysdate which could be used. Just be aware that the value of this var is the date of when you started your session - and with some people having sessions open for days the value of this var can become a bit "outdated".

Having trouble creating a date variable to use in report headings

Dick_Shryock — Wed, 29 Jun 2011 10:27:46 GMT

Patrick, that was helpful but not exactly what I'm looking for (poorly worded question). I have a variable named RptDate that I want to use in the report heading. It could be any date or date range it is text.

I have tried "Emergency Department data for " &RptDate and "Emergency Department data for &RptDate" and both just produce the literal &RptDate.

I'm missing somthing very fundament here, but can't seem to put my finger on it.

Thanks,

-d

Having trouble creating a date variable to use in report headings

manojinpec — Wed, 29 Jun 2011 13:20:14 GMT

Most likely the rptdate is not resolving . Could you please share the code where rptdate is declared or if log can be shared.

Having trouble creating a date variable to use in report headings

Doc_Duke — Wed, 29 Jun 2011 13:44:50 GMT

Dick,

If RptDate is a data value that you are reading in, then you need to use the CALL SYMPUT or CALL SYMPUTX macro functions to assign the data value to a macro variable's value and then use the macro variable in the TITLE statement.

This works if you have one value for RptDate for the entire report. Otherwise, you will need to either bust the report apart so there are multiple reports (one for each RptDate) or use the BY capability for the TITLE statements to insert the BY-variable into the Title. (Output data set names can use MACRO variables, but not the BY functionality).

Doc Muhlbaier

Duke

Having trouble creating a date variable to use in report headings

Patrick — Thu, 30 Jun 2011 01:07:43 GMT

You have to share some sample code/explain your data better in order to give you a good answer.

May be below sample is helpful for you:

data have;
   set sashelp.class;
   retain rptdate;
   rptdate='01JAN2011 - 10Jan2011';
run;

options nobyline;
title "RPTDATE has value #BYVAL(rptdate)";
proc print data=have;
by rptdate;
run;

HTH

Patrick