Hi,
I want to create volatile table in teradata using SAS dataset.
I tried varios options but still stuck!
SAS support documentation gives information only about creating Volatile tables and not for creating volatile tables using SAS datasets!
1> Does anyone know how this can be done by Libname? What options do i need to specify?
2> By Pass-thru, I tried this =
proc sql;
CONNECT to teradata(user='XXX' pw='YYY' server=XX connection=global);
execute (CREATE VOLATILE TABLE temp1 (
UNIQUE_ID char(10) NOT NULL
)
ON COMMIT PRESERVE ROWS) by teradata;
quit;
But after this, Insert does not work. Pass Thru Insert requires only Literal values.
I also tried =>
Create volatile table as (select * from sas_dataset)
But this also does not work. I am running SAS on production server (& not on my local machine). So, SAS does not recognize sas_dataset inside CONNECT statement !
I would be very much thankful for suggestions ??!!
... View more