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

[Santt0sh]

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

[SASKiwi]

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. 

[Tom]

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