BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi Everyone,
I'm trying to find a way to copy a record that is being submitted to a table to a second table through SCL and have not been able to find the function. Could anyone point me in the right direction to find what I'm looking for? I'm trying to set up a process to add the current record being submitted to a second table so that the triggered records are the only things on this second table.
Thanks in advance.
1 REPLY 1
deleted_user
Not applicable
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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 602 views
  • 0 likes
  • 1 in conversation