SAS_DBMS_AUTOMETADATA= LIBNAME Statement Option

Specifies whether to transfer data types and character-set metadata from input to output for DATA step processing.

Valid in:	SAS/ACCESS LIBNAME statement
Category:	Data Set Control
Default:	NO
Interaction:	Use the SAS_DBMS_AUTOMETADATA environment variable for the entire SAS session.
Data source:	Teradata
Note:	Support for this LIBNAME option was added for SAS 9.4.
Examples:	Specify the LIBNAME option: `libname tdlib teradata user=myuser1 pass=mypwd1 SAS_DBMS_AUTOMETADATA=YES;`
	Specify the environment variable on PC hosts: `SAS_DBMS_AUTOMETADATA 1`
	Export the environment variable on UNIX hosts [Bourne and Korn shells]: `SAS_DBMS_AUTOMETADATA=1 export SAS_DBMS_AUTOMETADATA`
	Export the environment variable on UNIX hosts [C shell]: `export SAS_DBMS_AUTOMETADATA=1`
	Specify the environment variable at SAS invocation for PC, UNIX, and z/OS hosts: `sas -set SAS_DBMS_AUTOMETADATA 1`

Syntax

SAS_DBMS_AUTOMETADATA=YES | NO

Last updated: February 3, 2026