Desktop productivity for business analysts and programmers

How to Export CSV to Teradata

Reply
Frequent Contributor
Posts: 90

How to Export CSV to Teradata

Hello,

I've a CSV file that needs to be exported to a Teradata table. How to do that? Any example code?

PROC EXPORT seems to only work for Access MDB.

PROC SQL; UPDATE statement doesn't seem to work.

Can give any directions?
Super Contributor
Super Contributor
Posts: 3,174

Re: How to Export CSV to Teradata

What code did you try? Please share the code and the related SAS log output for review/feedback. The SAS support http://support.sas.com/ has SAS-hosted documentation on SAS/Access for Relational Databases, with specific reference to Teradata -- found with a Google advanced search argument, such as:

access teradata export site:sas.com


Also, there are considerations about your SAS version, OS platform, and other related SAS processing (remote/local) environment.

Scott Barry
SBBWorks, Inc.



What's New in SAS/ACCESS 9.0, 9.1, 9.1.2, and 9.1.3 Interfaces to Relational Databases
http://support.sas.com/documentation/whatsnew/91x/acreldbwhatsnew900.htm
Ask a Question
Discussion stats
  • 1 reply
  • 418 views
  • 0 likes
  • 2 in conversation