Using SAS Tables

Introduction to Using SAS Tables in SCL Programs

SCL provides a group of features that can read or manipulate data stored in SAS tables. For example, you may want an SCL program to update one or more SAS tables, based on user transactions from a single user interface. For a data entry and retrieval system, you may want to use a secondary table to supplement the primary table. You might use the secondary table as a lookup table for sophisticated error checking and field validation. In addition, you may want to manipulate SAS tables to perform tasks like the following:

displaying table values in a window
creating a new table
copying, renaming, sorting, or deleting a table
indexing a SAS table.

Many functions that perform SAS table operations return a SAS software return code, called sysrc. SAS System Return Codes contains a list of return codes with a section for operations that are most commonly performed on SAS tables. You can check for these codes to write sophisticated error checking for your SCL programs.

The following sections describe the tasks that SCL programs can perform on SAS tables, along with summary information about the SCL function or routine to use to perform that task. These functions and routines are described in SAS Component Language Dictionary.

Top of Page