Specifies the file name to which the DBMS driver manager writes trace information.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| CONNECT statement | |
| Category: | Data Set Control |
| Default: | none |
| Restriction: | PostgreSQL, Yellowbrick: This option is valid only on a Windows platform. |
| Interaction: | TRACEFILE= is used only when TRACE=YES. |
| Data source: | Amazon Redshift, Aster, Google BigQuery, Greenplum, HAWQ, Impala, Microsoft SQL Server, Netezza, ODBC, PostgreSQL, SAP HANA, SAP IQ, Snowflake, Vertica, Yellowbrick |
| Notes: | Support for Yellowbrick was added in SAS 9.4M7. |
| As of a December 2025 update on SAS 9.4M9, this option is no longer used for Google BigQuery and is silently ignored. | |
| See: | TRACE= LIBNAME option |
If you specify a file name without a path, the SAS trace file is stored with your data files. If you specify a directory, enclose the fully qualified file name in single quotation marks.
If you do not specify the TRACEFILE= option, output is directed to a default file.
Google BigQuery: If you do not specify TRACEFILE=, output is directed to the tstrace.txt file.