Hi
SCL functions SAS Table
APPEND
Appends a new row to a SAS table
ATTRC and ATTRN
Return the value of an attribute for a SAS table
CLOSE
Closes a SAS table
CONTENTS
Displays the attributes of a SAS table
CUROBS
Returns the number of the current row in a SAS table
DATALISTC and DATALISTN
Displays a selection list window that contains the values of particular columns from rows in a SAS table and returns user selections
DELOBS
Deletes a row from a SAS table
DROPNOTE
Deletes a note marker from either a SAS table or an external file
DSID
Searches for a SAS table name and returns the table identifier
DSNAME
Returns the SAS table name that is associated with a table identifier
EXIST
Verifies the existence of a member of a SAS data library
FETCH
Reads the next nondeleted row from a SAS table into the Table Data Vector (TDV)
FETCHOBS
Reads a specified row from a SAS table into the Table Data Vector (TDV)
FSEDIT
Displays a SAS table by row
FSVIEW
Displays a SAS table in tabular format
GETVARC and GETVARN
Assign the value of a SAS table column to an SCL variable
GETVARF
Assigns the formatted value of a SAS table column to a character SCL variable
ICCREATE
Creates integrity constraints on a SAS table
ICDELETE
Drops an integrity constraint from a SAS table
ICDESCRIBE
Obtains the attributes for all existing integrity constraints within a specified SAS table
ICREATE
Creates an index for a SAS table
ICTYPE
Returns the type of integrity constraint that is assigned to a SAS table
ICVALUE
Returns the column names or the condition associated with an integrity constraint
IDELETE
Deletes an index from a SAS table
IMPORT
Creates a SAS table from an external file
INITROW
Initializes the Table Data Vector (TDV) for a SAS table to missing values
IOPTION
Returns options for index columns and key columns
ISINDEX
Returns the type of index for a SAS table column
IVARLIST
Returns the column names for an index key
KEYCOUNT
Returns the number of rows that meet the criteria specified by an index key
LIBLIST
Displays a host selection window that lists the currently assigned librefs, and returns user's selections
LIBNAME
Assigns or deassigns a libref for a SAS data library
LIBREF
Verifies that a libref has been assigned
LOCATEC and LOCATEN
Search a SAS table for a row that contains a specified value
LOCK
Locks or unlocks a SAS table or a SAS catalog entry
NEW
Defines a new SAS table interactively
NEWVAR
Adds a column to a new SAS table
NOTE
Returns an identifier for the current row of a SAS table
OBSINFO
Returns information about the current row in an FSEDIT application
OPEN
Opens a SAS table
POINT
Locates a row that is identified by the NOTE function
PUTVARC and PUTVARN
Write a value to the Table Data Vector (TDV) for a SAS table
REWIND
Positions the table pointer at the beginning of a SAS table
SET
Links SAS table columns to SCL variables of the same name and data type
SETKEY
Defines an index key for retrieving rows from a SAS table
SORT
Sorts a SAS table by one or more columns
UNLOCK
Releases a lock on the current row
UPDATE
Writes values from the Table Data Vector (TDV) to the current row in a SAS table
VARLIST
Displays a dialog window that lists the columns in a SAS table, and returns the user's selections
WHERE
Applies a WHERE clause to a SAS table
M.