Setup for IT Service Vision

MVS Appendix 4: Alternate Data Browsing Method

Introduction
Viewing Data
- Prerequisites
- Actions

Introduction

You can use any of the data presentation tools available in the SAS System to examine your data. The example in this appendix describes how to use the PRINT procedure (which is in base SAS software) to view your data.

Viewing Data

Prerequisites

The IT Service Vision server software is running.

Actions

Display a table's data.
1. If you intend to print the results, you may want to clear previous output from the SAS OUTPUT window. If your OUTPUT window has a command line, type CLEAR and press ENTER or RETURN. If your OUTPUT window has pull-down menus, select Edit and Clear text.
  Note: For more about the SAS OUTPUT window and command lines and pull-down menus, see Shared Appendix 2: Navigating SAS Windows.
2. In your PROGRAM EDITOR window, type the following starting at the first line in the body of the window:
```
   proc print data=level.table;
   run;
```
  where level is detail, day, week, month, or year, and table is the name of the table whose data you want to view.
3. If your PROGRAM EDITOR window has a command line, type SUBMIT and press ENTER or RETURN. If your PROGRAM EDITOR window has pull-down menus, select Locals nd Submit.
  IT Service Vision displays the output in the OUTPUT WINDOW.
4. If you want to print the output in the OUTPUT window, the easiest method is to save it to a file first. If you have pull-down menus, select File, Save As..., and Write to File.... (If you have a command line, type COMMAND and then press ENTER or RETURN to get pull-down menus.) In the Enter external file to store text field, type in the fully qualified name (in single quotes) of the file to which you want to direct the report, and then select OK.
Display a subset of the data.
If the volume of output is too much, you can revise the program to limit the amount of data shown.
1. If you intend to print the results, you may want to clear previous output from the OUTPUT window. If your OUTPUT window has a command line, type CLEAR and press ENTER or RETURN. If your OUTPUT window has pull-down menus, select Edit and Clear text.
2. If your PROGRAM EDITOR window has a command line, type RECALL and press ENTER or RETURN. If your PROGRAM EDITOR window has pull-down menus, select Locals and Recall Text.
3. Overwrite part of the 00001 line number with i and press ENTER or RETURN. (If you do not have a line number, you can turn line numbers on with the NUMS ON command.) IT Service Vision inserts a line after the first line.
4. Add a statement that limits the data. For example,
  - If you want to limit the data to certain variables, type this on the new line:
```
   var variable1 variable2 ... variableN;
```
    where variables 1-N are the names of variables whose data you want to see.
    
    For example, the modified program might look like this:
```
   proc print data=detail.xty70;
      var machine datetime inavg inmax inmin ;
   run;
```
    Or, if you want to limit the listing to, say, twenty observations' worth of data, use this:
```
   proc print data=detail.xty70 obs=20;
      var machine datetime inavg inmax inmin ;
   run;
```
  - If you want to limit the data to certain machines, type this on the new line:
```
   where machine in ('machine1' 'machine2' ... 'machineN');
```
    where machines 1-N are the names of machines whose data you want to see.
    
    For example, the modified program might look like this:
```
   proc print data=detail.xty70;
      where machine in ('AR40');
   run;
```
    Or, if you want to limit the listing to, say, twenty observations' worth of data, use this:
```
   proc print data=detail.xty70 obs=20;
      where machine in ('AR40');
   run;
```
  - If you want to limit the data to certain times, type this on the new line:
```
   where 'ddmmmyy:hh:mm:ss.cc'dt < datetime < 'ddmmmyy:hh:mm:ss.cc'dt;
```
    where ddmmmyy:hh:mm:ss.cc represents the date (day, month, year) and time (hour, minute, second, and centisecond) of an endpoint of the range of data that you want to see.
    
    For example, the modified program might look like this:
```
   proc print data=detail.xty70;
      where '26nov95:00:00:00.00'dt < datetime < '26nov95:23:59:59.99'dt ;
   run;
```
    Or, if you want to limit the listing to, say, twenty observations' worth of data, use this:
```
   proc print data=detail.xty70 obs=20;
      where '26nov95:00:00:00.00'dt < datetime < '26nov95:23:59:59.99'dt ;
   run;
```
  You can combine these methods, too. For example, you could use a program that looks like this:
```
   proc print data=detail.xty70 obs=20;
      var machine datetime inavg inmax inmin ;
      where '26nov95:00:00:00.00'dt < datetime < '26nov95:23:59:59.99'dt
         and machine in ('AR40');
   run;
```
5. Submit the program again.
6. If you want to print the output in the OUTPUT window and you have pull-down menus, select File, Save As..., and Write to File.... (If you have a command line, type COMMAND and then press ENTER or RETURN to get pull-down menus.) In the Enter external file name to store text field, type in the fully qualified name of the file (in single quotes) to which you want to direct the report, and then select OK.

For more about the PRINT procedure and some of the statements that you can use in the PRINT procedure, see "The PRINT Procedure" in the SAS Procedures Guide in the documentation for your current SAS release.

For a list of the other statements that you can use in the PRINT procedure, see "SAS Statements Used with Procedures" in the SAS Procedures Guide in the documentation for your current SAS release.

For details on the statements, see SAS Language Statements in the SAS Language Reference documentation for your current SAS release.