11-05-2014 01:54 PM
proc append base=db.acct (TPT=YES MULTISTMT=YES TPT_PACKMAXIMUM=YES
keep=x y z) data=curr_acct;
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.
11-05-2014 02:30 PM
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.