Help using Base SAS procedures

Teradata load error

Reply
Contributor
Posts: 31

Teradata load error

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.

Trusted Advisor
Posts: 3,214

Re: Teradata load error

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.

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 1 reply
  • 402 views
  • 0 likes
  • 2 in conversation