Write tera query in sas

Ronein — Wed, 30 Mar 2022 06:08:34 GMT

Hello

I have a query tat someone wrote and run it on teradata.

My task is to run this query in SAS.

Please find the general form of the query that was run on teradata

/***Query that was run on teradata**/
CREATE VOLATILE TABLE  ttt  AS (
SELECT
FROM  
WHERE		
  )
WITH DATA  PRIMARY INDEX (Branch_Cust_IP) ON COMMIT PRESERVE ROWS;

I have tried to convert the query to sas environment and run it in SAS.

Please see the general form of the query that I run in sas

proc sql;
create table ttt  (index=(Branch_Cust_IP/unique)) AS
SELECT
FROM 
where    
;
quit;

I get an error

ERROR: Duplicate values not allowed on index Branch_Cust_IP for file ttt.
NOTE: Compressing data set WORK.ttt decreased size by 40.21 percent. 
      Compressed is 127453 pages; un-compressed would require 213157 pages.
ERROR: Index creation failed for one or more indexes.

My question- How can I solve the problem. Please note that in teradata it is running well.

Please also note that my connection from sas to teradata base is done by adding TeraData. before the table name (The admin person created this connection between sas and tera so in this issue it is working well)

Re: Write tera query in sas

Ronein — Wed, 30 Mar 2022 06:25:20 GMT

I found the solution

Need to write

create table ttt  (index=(Branch_Cust_IP)) AS

instead of

create table ttt  (index=(Branch_Cust_IP/unique)) AS

topic Write tera query in sas in SAS Programming

Write tera query in sas

Re: Write tera query in sas