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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.