topic Re: Can I create a column xyz in a Teradata table pass thru? in SAS Programming

Can I create a column xyz in a Teradata table pass thru?

Santt0sh — Wed, 17 May 2023 22:32:45 GMT

Hi All,

I am trying to create a table db1.trans with columns.
%Let Acct = User;

Proc sql ;
Connect to teradata( user= myuserid password = mypwd tdpid = zzzz@somebank.com mode = Teradata);
Execute(
Create table db1.Acct_&Acct. As (
Select trandte, &Acct. As AcctType
From db1. All_Accts) with data
) by Teradata;
Quit;

When I try the above code the I get an error states that user column is not present on db1.Accts table.

Could you please suggest me to add the macro variable &Acct as column in the new table I’m creating.

Thanks

Re: Can I create a column xyz in a Teradata table pass thru?

SASKiwi — Wed, 17 May 2023 22:44:21 GMT

If the table already exists then you wont be able to do a CREATE TABLE, you will first need to do a DROP TABLE.

However your code is creating a table called Acct_User, not Accts, so that is where I would expect to find the new column.

Re: Can I create a column xyz in a Teradata table pass thru?

Tom — Thu, 18 May 2023 03:06:47 GMT

Try a different variable name. USER is normally a reserved word in SQL code.