proc sql;
connect to teradata (MODE=TERADATA user=xxxxx password="xxxxx" tdpid='xxxxxxxxxxx' connection=global);
execute(
insert into BLAH_DB.table
select
*
from blahdb.othertable cst inner join otherdb.tablec ch on cst.cust_acct_nbr = ch.cust_acct_nbr
) by teradata;
ERROR: Teradata execute: No more room in database BLAH_DB.
Solution:
The column names were not the same.
Somehow that makes it blowup (x-product??)
Solution:
The column names were not the same.
Somehow that makes it blowup (x-product??)
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.