search: Search support.sas.com KNOWLEDGE BASE     System Requirements     Install Center     Product Documentation     Papers     Samples & SAS Notes     Focus Areas SUPPORT     License Assistance     Administrator Services     Downloads & Hot Fixes LEARNING CENTER     Bookstore     Training     Certification     SAS Learning Edition     Higher Education Resources     SAS OnDemand For Academics COMMUNITY     User Groups     Events     E-Newsletters

• Print |
• E-mail  |
• Bookmark

Overview

SAS Web Report Studio enables you to include seven dynamic text items in a header or footer (for a list, see SAS Note 20902). One way to add other dynamic text items to a header or footer is to place a Text object just below the header or just above the footer. Text objects can display measure and prompt values.

This sample explains how you can use SAS^® Information Studio in order to create a measure data item that represents today's date. That measure is then inserted into a Text object that is placed directly beneath the report's header. In this way, it appears that today's date is part of the report's header. As the input table for the information map, this sample uses the INVOICE table, which is one of the sample tables included with SAS.

Create a Data Item for Today's Date

1. Open SAS Information Map Studio and insert the data items from the INVOICE table.
2. Select Insert→Data Item to open the Data Item Properties dialog box.
3. Enter a name for the new data item that will be today's date. This sample uses Today's Date.
4. Click Edit to open the Expression Editor dialog box, and then specify these settings:
1. For Type, select Date.
2. From the Functions tab, select Date and Time to display a list of functions on the right.
3. Select the Today() function and click Add to Expression.

Note: The TODAY function produces the current date in the form of a SAS date value, which is the number of days since January 1, 1960.



4. Click OK to return to the Data Item Properties dialog box.
5. Click the Classifications/Formats tab, and then specify these settings:
1. Select Measure.
2. Click Clear All to remove all selected aggregation types, and then select only Defined in expression.
3. Beneath Formatting, select Date/Time as the format type and then select DATE.



6. Click OK.
7. Save the information map.

Create the Report Header

1. Open SAS Web Report Studio and select the information map that you just created. Make sure that you select the measure that represents today's date.
2. Click Header and enter some text in the Edit Header dialog box. In this sample, the text is Aquatic Sports Equipment Purchases.



3. Click OK to return to the layout.

Insert Today's Date into a Text Object

1. Insert a Text object in the first cell in the layout beneath the header.
2. Click Edit Text to open the Edit Text dialog box.
3. Type some text in the box such as Today's Date.
4. Select the measure that represents today's date from the Measure value drop-down list, and then click Insert.



5. Click OK to return to the layout.

Insert a Table but Hide Today's Date

1. Insert a table beneath the Text object.
2. Use the table's toolbar to open the Table Data dialog box.
3. Select the measure that represents today's date and move it to Hidden.

This what the layout looks like.

View the Report

Click View Report to display the report.

Change the Format of the Date

1. Return to the Edit Report view and click Define next to the measure that represents today's date.
2. In the Define a Format dialog box, change the type of format to Date.
3. In the Date options box, select the new format that you want to apply. In this sample, the format is June 26, 2002.



4. Click OK and then view the report again.

Alternatives: Other Date Functions

The DATETIME function produces the current date and time of day as a SAS value that represents the number of seconds between January 1, 1960 and the current time. The TIME function produces the current time of day as a SAS time value. To create data items that represent the current date and time and the current time, follow the steps for creating today's date, but use these settings:

Setting	Current Time	Current Date and Time
Function	TIME()	DATETIME()
Formatting	Date/Time and TIME	Date/Time and DATETIME

Additional Documentation

For a list of available documentation for SAS Information Map Studio, see http://support.sas.com/documentation/onlinedoc/ims/index.html

For a list of available documentation for SAS Web Report Studio, see http://support.sas.com/documentation/onlinedoc/wrs/index.html

---

This sample explains how to create a measure data item that represents today's date. That measure is then inserted into a Text object that is placed directly beneath the report header. In this way, it appears that today's date is part of the report's header. This sample uses the INVOICE table.

Type:	Sample
Topic:	Data Management ==> Data Sources ==> Information map Query and Reporting ==> Interactive Querying Query and Reporting SAS Reference ==> Functions ==> Date and Time ==> DATE SAS Reference ==> Functions ==> Date and Time ==> DATETIME SAS Reference ==> Functions ==> Date and Time ==> TIME SAS Reference ==> Functions ==> Date and Time ==> TODAY

Date Modified:	2008-05-09 10:58:19
Date Created:	2008-05-06 16:03:53

Operating System and Release Information

Product Family	Product	Host	Product Release		SAS Release
			Starting	Ending	Starting	Ending
SAS System	SAS Information Map Studio	Microsoft® Windows® for x64	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Advanced Server	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Datacenter Server	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Server	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Professional	3.1		9.1 TS1M3 SP4
		Microsoft Windows NT Workstation	3.1		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Datacenter Edition	3.1		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Enterprise Edition	3.1		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Standard Edition	3.1		9.1 TS1M3 SP4
		Microsoft Windows XP Professional	3.1		9.1 TS1M3 SP4
SAS System	SAS Web Report Studio	Microsoft® Windows® for x64	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Advanced Server	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Datacenter Server	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Server	3.1		9.1 TS1M3 SP4
		Microsoft Windows 2000 Professional	3.1		9.1 TS1M3 SP4
		Microsoft Windows NT Workstation	3.1		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Datacenter Edition	3.1		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Enterprise Edition	3.1		9.1 TS1M3 SP4
		Microsoft Windows Server 2003 Standard Edition	3.1		9.1 TS1M3 SP4
		Microsoft Windows XP Professional	3.1		9.1 TS1M3 SP4
		64-bit Enabled AIX	3.1		9.1 TS1M3 SP4
		64-bit Enabled Solaris	3.1		9.1 TS1M3 SP4
		HP-UX IPF	3.1		9.1 TS1M3 SP4