SAS Component Language Dictionary

FSEDIT

Displays a SAS table by row

Category:

SAS Table

Syntax
Details
Examples
See Also

Syntax

CALL FSEDIT(table-name<,screen-name
<,open-mode<,row-number>>>);

table-name

is the SAS table to display, in the form <libref.>member-name<(data-set-options)>. If you omit the libref, the default WORK library is used.

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=. See SAS Language Reference: Dictionary for a list of SAS data set options and their descriptions.

Type: Character

screen-name

is a SCREEN entry for the FSEDIT session. (Screen entries are SAS catalog entries of type SCREEN that define custom features for the FSEDIT session.) For screen-name, use the form <libref.>catalog-name<.entry-name<.SCREEN>>. A one- or two-level name is interpreted as a catalog name, and the default screen entry name, FSEDIT.SCREEN, is assumed. (A one-level name is interpreted as a catalog in the default SAS data library, WORK.) If the specified catalog does not already exist, it is created.

If the screen entry does not already exist, a new screen entry is not created unless the user issues a MODIFY command during the FSEDIT session.

If you want to use predefined SAS table labels, use an equal sign (=) for screen-name. (A modified SCREEN entry is not saved.) Column names are used for any fields that lack labels.

Type: Character

open-mode

specifies the type of access to the SAS table:

'ADD': adds a new blank row to the table, then opens the FSEDIT window with the new row displayed for editing.
'BROWSE': opens the FSBROWSE window for reading rows.
'EDIT': opens the FSEDIT window for editing rows. (This is the default.)
'NEW': opens the FSEDIT NEW window for creating the specified SAS table as a new table, then opens the FSEDIT window for entering values into the new table.

Type: Character

row-number

is the first row to be displayed when the FSEDIT or FSBROWSE window is opened. This argument is ignored unless the value of open-mode is 'EDIT' or 'BROWSE'.

Type: Numeric

Details

The FSEDIT routine calls the FSEDIT procedure, which opens the FSEDIT window to display the specified SAS table. You can specify BROWSE for open-mode to open the FSBROWSE window for browsing the table instead. You can optionally specify the name of a screen entry to provide a custom display and the number of the row to be displayed when the window is opened.

If you want to specify open-mode or row-number but do not want to specify a screen entry, use a null string ('') for screen-name.

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

Examples

Open a SAS table named PERSONAL (in the default SAS data library WORK) for editing:
```
call fsedit('personal');
```
Open the SAS table PERSONAL in the library MASTER for editing, using a custom SCREEN entry named PER1 in the catalog MASTER.DISPLAY:
```
call fsedit ('master.personal','master.display.per1');
```
Open a SAS table named MASTER.PERSONAL for browsing, using the default FSBROWSE window display:
```
call fsedit('master.personal',' ','browse');
```
To display the predefined labels that are associated with the SAS table columns instead of the column names, specify an equal sign (=) for the screen-name argument, as in the following example:
```
call fsedit('master.personal','=','browse');
```

Specify SAS data set options by enclosing them within parentheses immediately following the SAS table name in the table-name argument, as in the following examples.

Open a SAS table named MASTER.PERSONAL and subset the rows based on the value that is entered for the numeric column SCRNUM:
```
call fsedit('master.personal(where=(num='||
             put(scrnum,5.)||'))');
```
Open a SAS table named MASTER.PERSONAL and subset the rows based on the value that is entered for the character column SCRNAME:
```
call fsedit('master.personal(where=(name='||
             quote(scrname)||'))');
```