SAS Component Language Dictionary

FSVIEW

Displays a SAS table in tabular format

Category:

SAS Table

Syntax
Details
Examples
See Also

Syntax

CALL FSVIEW(table-name<,open-mode
<,formula-entry<,options>>>);

table-name

is the SAS table to be displayed. Use the format <libref.>member-name<(data-set options)>. If the libref is omitted, the default SAS data library, WORK, is assumed. You can add a list of SAS data set options in parentheses following the table name. All data set options are valid except FIRSTOBS= and OBS=. Refer to SAS Language Reference: Dictionary for a list of SAS data set options and their descriptions.

Type: Character

open-mode

specifies the type of access to the SAS table:

'ADD': Add a new blank row to the table, and then open the FSVIEW window with the new row displayed for editing.
'BROWSE': Open the FSVIEW window for reading rows. (This is the default.)
'EDIT': Open the FSVIEW window for editing rows.
'NEW': Open the FSVIEW NEW window for creating the specified SAS table as a new table, then open the FSVIEW window for entering values into the new table.

Type: Character

formula-entry

is the FORMULA catalog entry that defines custom features for the FSVIEW session or that controls the display and behavior of the session.

Specify this argument as <libref.>catalog-name<.entry-name<.FORMULA>>. A one- or two-level name is interpreted as a catalog name, and the default formula entry name is assumed. The default formula entry name is the same as the member name of the table specified in the table-name argument. (A one-level name is assumed to refer to a catalog in the default SAS data library, WORK.) If the specified catalog does not exist, it is created. If the specified formula entry does not already exist, a new formula entry is created.

Type: Character

options

specifies whether to disable certain FSVIEW window commands for the duration of the FSVIEW session. Separate multiple options with blanks.

'BRONLY': disables the MODIFY command so that only browsing is allowed and 'EDIT' and 'ADD' modes are ignored.
'NOADD': disables the ADD command so that new rows cannot be added to the table.
'NODELETE': disables the DELETE command so that rows cannot be deleted.

Type: Character

Details

The FSVIEW routine calls the FSVIEW procedure, which opens the FSVIEW window to display the specified SAS table. By default, the SAS table is opened for browsing. You can use the open-mode argument to specify that the table should instead be opened for editing. You can also specify a formula entry and other options for the FSVIEW session.

If you specify NEW for the open-mode argument, the FSVIEW NEW window is opened for the user to define a new SAS table before the FSVIEW window is opened to enter values for that table.

You can specify SAS data set options by enclosing them within parentheses immediately following the SAS table name in the table-name argument, as in the second example in the "Examples" section.

If you want to specify the options argument but do not want to specify a formula entry, then use a null string ('') for the formula-name argument.

To specify multiple values for the options argument, separate the values with blanks.

In order to use the FSVIEW routine, SAS/FSP Software must be installed. For more information about the commands that are available in the FSVIEW procedure, see the SAS/FSP Procedures Guide.

Examples

Browse a SAS table named PERSONAL in the default SAS data library WORK:
```
call fsview('personal');
```
Edit a SAS table named PERSONAL in the library MASTER. Only those rows in which the SITE column has the value 5 are displayed.
```
call fsview
('master.personal(where=(site=5))','edit');
```
Edit a SAS table named PERSONAL in the library MASTER. Rows cannot be added or deleted during the FSVIEW session.
```
call fsview
('master.personal','edit','','noadd nodelete');
```