Basically, yes. If you are have a connection to a Teradata data source using the SAS LIBNAME mechanism, you can use the "dbcreate_table_opts" SAS data set option to specify any table create option. For example:
I'd further recommend that you look up the "dbtype" SAS data set option if you choose to do this. That lets you explicitly define the column data types.
Of course, doing it this way only makes sense if your DB2 library is NOT in the same Teradata environment. In other words, if you're creating a Teradata table from a Teradata table, it's much better to use SAS's "pass-thru" facility, with which you can submit normal Teradata SQL:
proc sql; connect to teradata (user="&terauser" password="&terapass" mode=teradata); execute ( /* Your original code follows */ CREATE SET TABLE db1.table1 AS (SELECT name, ssn, address FROM db2.customers) WITH DATA UNIQUE PRIMARY INDEX (ssn) ) by teradata; quit;