Sample 41169: Creating the indicator data object based on a SQL query of SASHELP.CLASS for use with the SAS® BI Dashboard 4.3 sample indicators
 |  |  |  |
Overview
In preparation for creating the SAS BI Dashboard 4.3 sample indicators, this sample explains how to create the indicator data object based on a SQL query of SASHELP.CLASS.
Create the indicator data object
- In SAS BI Dashboard, select File ► New ► Indicator Data to open the Create Indicator Data dialog box.
- For the name, enter
Sample sashelp.class. - Click OK and the Indicator Data editor appears. In the Indicator Data editor, complete the following steps:
- Select SQL Query from the Data source list.
- Type the following into the SQL Query box:
- Click Apply Query Changes.
select * from sashelp.class
At this point, the Indicator Data editor should look like the following display.
Save the indicator data object
Note: If you have not created the sample folder structure, see SAS Note 41188.
- Select File ► Save.
- Navigate to Shared Data/BID Samples/Data, and save the indicator data object.
Next steps
Depending on what you want to do next, click one of the following links.
- Use this indicator data object in an indicator
- Create another indicator data object
- Create a range
- Return to the main SAS BI Dashboard sample note
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.
In preparation for creating the BI Dashboard 4.3 sample indicators, this sample explains how to create the indicator data object based on a SQL query of SASHELP.CLASS.
| Type: | Sample |
| Date Modified: | 2011-01-24 10:37:02 |
| Date Created: | 2010-10-07 15:34:19 |
Operating System and Release Information
| Product Family | Product | Host | Product Release | SAS Release | ||
| Starting | Ending | Starting | Ending | |||
| SAS System | SAS BI Dashboard | z/OS | 4.3 | 9.2 TS2M3 | ||
| Microsoft® Windows® for x64 | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Standard Edition | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 for x64 | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2008 | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2008 for x64 | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows XP Professional | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Enterprise 32 bit | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Enterprise x64 | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Home Premium 32 bit | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Home Premium x64 | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Professional 32 bit | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Professional x64 | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Ultimate 32 bit | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Ultimate x64 | 4.3 | 9.2 TS2M3 | ||||
| Windows Vista | 4.3 | 9.2 TS2M3 | ||||
| Windows Vista for x64 | 4.3 | 9.2 TS2M3 | ||||
| 64-bit Enabled AIX | 4.3 | 9.2 TS2M3 | ||||
| 64-bit Enabled Solaris | 4.3 | 9.2 TS2M3 | ||||
| HP-UX IPF | 4.3 | 9.2 TS2M3 | ||||
| Linux for x64 | 4.3 | 9.2 TS2M3 | ||||
| Solaris for x64 | 4.3 | 9.2 TS2M3 | ||||