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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.