Hi All,
I got an error when using TPT in DS2 data step, the coding and error are below:
proc ds2;
data TD.TEST(TPT=YES FASTLOAD=YES TPT_MAX_SESSIONS=4);
method run();
set test.data1;
end;
enddata;
run;
ERROR: Compilation error.
ERROR: Syntax error or access violation TPT
ERROR: Unable to execute CREATE TABLE statement for table TD.TEST.
I checked the same DS2 step works without TPT, see coding below:
proc ds2;
data TD.TEST1;
method run();
set test.data1;
end;
enddata;
run;
What's the correct syntax to apply TPT is DS2 step? Thank you!
Jade
this is very interesting. I have not used proc DS2. can you do try tpt in libname statemnt as something shown below.
libname tera teradata user=testuser pw=testpw TPT=YES;
Thank you for the suggestion! Tried to add TPT in the libname statement, then try the coding again, unfortunately still get the same error
Right, I feel the TPT is not compatible with PROC DS2.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.