Hi @Jade_SAS
Question #1 - SAS cannot handle table names longer than 32 characters. This limit can be worked-around by creating a database view on the table and making the view name 32 characters long, or less.
Question #2 - SAS variable names cannot be longer than 32 characters. There are plans to address this but the work hasn't been scheduled and is not on a roadmap.
Question #3 - Teradata BIGINT and NUMBER data types are problematic because they exceed the precision of SAS 9.4. This SAS Note may help: http://support.sas.com/kb/39/831.html.
This communities topic has information on BIGINT: https://communities.sas.com/t5/SAS-Data-Management/How-do-to-access-a-bigint-in-Teradata-from-Enterp...
Here is a code example using NUMBER:
15 libname mytera teradata server=vat user=sasxjb password=XXXXXX;
NOTE: Libref MYTERA was successfully assigned as follows:
Engine: TERADATA
Physical Name: vat
16 proc sql;
17 connect using mytera;
18 execute (create table jeff_num_test (x int, problem number)) by mytera;
19 execute (commit) by mytera;
20 execute (insert into jeff_num_test values (1,1)) by mytera;
21 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.18 seconds
cpu time 0.04 seconds
22 proc sql;
23 select * from mytera.jeff_num_test;
NOTE: Writing HTML Body file: sashtml.htm
NOTE: No rows were selected.
NOTE: The following 1 column(s) in MYTERA.jeff_num_test have been automatically dropped because they
have a datatype that is not supported by this engine:
problem <--- Jeff Note: this is the name of the actual column...
24 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.56 seconds
cpu time 0.39 seconds
If I didn't include a readable column in the table I would have gotten this error:
35 proc sql;
36 connect using mytera;
37 execute (create table jeff_num_test2 (problem number)) by mytera;
38 execute (commit) by mytera;
39 execute (insert into jeff_num_test2 values (1)) by mytera;
40 quit;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.50 seconds
cpu time 0.04 seconds
41
42 proc sql;
43 select * from mytera.jeff_num_test2;
ERROR: Table MYTERA.jeff_num_test2 doesn't have any columns. PROC SQL requires each of its tables to
have at least 1 column.
ERROR: Error trying to read from a DBMS table. At least one column must be selected.
NOTE: The following 1 column(s) in MYTERA.jeff_num_test2 have been automatically dropped because
they have a datatype that is not supported by this engine:
problem <--- Jeff Note: this is the name of the actual column...
44 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.16 seconds cpu time 0.04 seconds
Here is the source code:
libname mytera teradata server=tserv user=sasxjb password=password1;
proc sql;
connect using mytera;
execute (create table jeff_num_test (x int, problem number)) by mytera;
execute (commit) by mytera;
execute (insert into jeff_num_test values (1,1)) by mytera;
quit;
proc sql;
select * from mytera.jeff_num_test;
quit;
proc sql;
connect using mytera;
execute (create table jeff_num_test2 (problem number)) by mytera;
execute (commit) by mytera;
execute (insert into jeff_num_test2 values (1)) by mytera;
quit;
proc sql;
select * from mytera.jeff_num_test2;
quit;
Hope this helps,
Jeff
