proc append base=db.acct (TPT=YES MULTISTMT=YES TPT_PACKMAXIMUM=YES
keep=x y z) data=curr_acct;
run;
I am getting the below error-
NOTE: Appending WORK.CURR_ACCT to db.acct.
NOTE: BASE data set does not exist. DATA file is being copied to BASE file.
NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables.
WARNING: Engine TERADATA does not support SORTEDBY operations. SORTEDBY information cannot be copied.
There are several aspects that Teradata dataset behave different as to SAS datasets.
See SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Fifth Edition (Maximizing Teradata Load Performance)
First create the data set in Teradata with 0 observations. Take care to define a primary index (in Teradata context) on a suited variable or use no primary index.
Then append all data to that dataset.
A Teradata dataset does not support all kind of SAS dataset options. A fixed ordering in TD does not exist (SQL RDBMS). Do not think in ordering physical data anymore.
When you need an ordered list you need to specify that ordered when retrieving the data.
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.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.