Create Multiset Table from SAS

Third Party Software
Enthusiast

Create Multiset Table from SAS

I am using SAS in an ETL step, to transfer data from a SAS server to Teradata. In short, this looks like:

 

PROC SQL;

   CREATE TABLE teradataLibName.newTableName AS

   SELECT blah FROM blah;

QUIT;

 

This works. Now I need to make it a MULTISET table for efficiency purposes. I can not simply write "CREATE MULTISET TABLE" as we would do outside SAS's "proc sql" procedure.

 

Do you know how I can do it?

 

Thanks

 

 

2 REPLIES
Junior Supporter

Re: Create Multiset Table from SAS

Hi.

 

If you change session mode to ANSI (instead of Teradata) CREATE TABLE (without MULTISET) will result in a MULTISET TABLE created.

 

HTH.

 

Cheers.

 

Carlos.

Junior Supporter

Re: Create Multiset Table from SAS

To create any kind of table, you can want follow these 3 strategies,

1.You need to use explicit pass through, if all the tables are in teradata.

2. I think your DBA creates the default  to set or multiset and at my client site it is multiset, so someone can talk to him.

3. Create a multiset empty table either in sql assistant/bteq or using explicit pass through and in next step  then insert data into the table.