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 =
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;
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 ??!!
You may find information at the SAS support website http://support.sas.com/ and do a search on your topic, or as I did, you will find the Google advanced search argument will generate some DOC results found at the SAS site: