All, proc sql;
create table TEST.SS1 AS /*SS1 sas table now 3 coumns*/
select * from ssmeta.ss2; /* metadata Teradata table has 3 coumns */
quit;
If I do this again with insert, I am getting below ERROR.
proc sql;
insert into TEST.SS1 (procid, queryid)
select * from ssmeta.ss2;
quit;
ERROR: Attempt to insert more columns than specified after the INSERT table name.
But If Ido like below then that will work.
data TEST.SS1(keep=procid queryid);
set ssmeta.ss2;
run; What could be the reason for this.
... View more
