SQL_FUNCTIONS_COPY= LIBNAME Statement Option

Writes the function associated with this particular LIBNAME statement to a SAS data set or the SAS log.

Valid in: SAS/ACCESS LIBNAME statement
Category: Data Set Control
Default: none
Restrictions: You must specify a two-part data set name, such as <libref.member> or an error results.
<libref.member> must be a SAS data set. It is not checked to make sure that it is assigned to the default Base SAS engine.
Data source: Amazon Redshift, Aster, DB2 under UNIX and PC Hosts, DB2 under z/OS, Google BigQuery, Greenplum, Hadoop, HAWQ, Impala, JDBC, Microsoft SQL Server, MySQL, Netezza, ODBC, Oracle, PostgreSQL, SAP ASE, SAP HANA, SAP IQ, Snowflake, Spark, Teradata, Vertica, Yellowbrick
Notes: Support for Spark was added in SAS 9.4M7.
Support for Yellowbrick was added in SAS 9.4M7.
See: SQL_FUNCTIONS= LIBNAME option

Table of Contents

Syntax

SQL_FUNCTIONS_COPY=libref.member | SASLOG

Syntax Description

libref.member

writes the current in-memory function list to a user-specified SAS data set for this particular LIBNAME statement.

SASLOG

writes the current in-memory function list to the SAS log for this particular LIBNAME statement.

Last updated: February 3, 2026