Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

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:

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

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

Operating System and Release Information