topic Re: proc contents in teradata in SAS Enterprise Guide

proc contents in teradata

new_sas_user_4 — Tue, 11 Mar 2025 13:53:59 GMT

what is the way to see column names and their type(character or numeric) when using Teradata passthrough.

PROC SQL;
CONNECT TO TERADATA(USER="new_sas_user_4" PASSWORD="xxxx" );
create table a as select * from connection to teradata(
proc contents data= database_name.table_name

);
disconnect from teradata;
quit;

this is not working 😕

Re: proc contents in teradata

Tom — Tue, 11 Mar 2025 14:00:16 GMT

That is a question for Teradata forum. All of the code inside the () after the FROM CONNECTION TO xxx needs to be valid syntax for the foreign database.

https://stackoverflow.com/questions/49013777/how-to-list-the-columns-of-a-table-in-teradata-sql

Basically run a query against the metadata view

dbc.columnsV

Re: proc contents in teradata

Ksharp — Wed, 12 Mar 2025 02:29:48 GMT

Here is an example for ODBC. But the same thing should be done for TD.

Also you could try SQLColumns(,"dbo")

/*
https://www.connectionstrings.com/
https://www.connectionstrings.com/microsoft-odbc-driver-13-for-sql-server/
https://communities.sas.com/t5/Administration-and-Deployment/Tables-not-shown-up/m-p/939847#M28853
*/


proc sql;
connect to odbc as MyODBCName (dsn="MyODBCName" user="username" password="password");
select * from connection to MyODBCName (
ODBC::SQLTables(,"dbo")
)
;
disconnect from MyODBCName ;
quit;

Re: proc contents in teradata

Patrick — Wed, 12 Mar 2025 06:29:06 GMT

what is the way to see column names and their type(character or numeric) when using Teradata passthrough.

Do you want to see the Teradata data types or to what they map on the SAS side?
If it's just on the SAS side (character or numeric) then use a libname and then Proc Contents.

libname mytera teradata <connection info>.
proc contents data=mytera.<table name>;
run;

If you want the actual Teradata data types then using SAS it must be via explicit SQL passthrough using Teradata specific syntax - for which you would need to ask in a Teradata forum.

Re: proc contents in teradata

new_sas_user_4 — Fri, 21 Mar 2025 13:34:51 GMT

I was able to see a sample of the rows from the teradata table using the below code....explicit passthrough.

PROC SQL;
CONNECT TO TERADATA(USER="username" PASSWORD="password" );
create table A2 as select * from connection to teradata(
SELECT
* from terdata_database.table_name sample 10

);
disconnect from teradata;
quit;