Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

proc sql duplicate column name

Status
Not open for further replies.

Anna dlC

Programmer
Apr 1, 2021
2
0
0
CA
I am attempting to dump a dataset into a new table -- no merge/join involved. I'm getting the error message "ERROR: Error attempting to CREATE a DBMS table. "ERROR: ORACLE execute error: ORA-00957: duplicate column name.." -- those dots on end are not mine. It's not actually telling me which column is duplicated.

I've used this exact code with many campaigns, first time I've seen this error. The list of variables in temp2 is below the code.

libname ocl oracle user=&uid password=&und path="iwp2.world";

proc sql;
connect to oracle (user=&uid pass=&und path='@iwp2.world' buffsize=5000);
drop table ocl.anna_input_aug2023 ;
create table ocl.anna_input_aug2023(bulkload=YES) as select * from temp2 ;
execute (grant select on anna_input_aug2023 to ECMA_APP) by oracle ;
%put &sqlxmsg;
disconnect from ORACLE;
quit;
run;

Variable
CLIENT_FM
CLIENT_IA
COMBINED
COMM_LIKE_ME
COMMUNITY
COMMUNITY_ID
CONN_FM1
CONN_FM2
CONN_FM3
CONN_FM4
CONN_FM5
CONN_FM6
CONN_IA1
CONN_IA2
CONN_IA3
CONN_IA4
CONN_IA5
CONN_IA6
CPIC_BALANCE
DNS
ECONOMIC_SEGMENT
FM_CONN_6MTH
HLD_CONNECT_NUMBER
HLD_CUSTNO
HLD_MANAGED_SEGMENT
HLD_PDR
HLD_PORTFOLIO
HLD_PTFL_BUS_UNIT_TRANSIT_NUM
IA_CONN_6MTH
IA_OPP
LOAD_DATE
MA_STATUS
MARKET
MARKET_ID
MONEY_IN
NATIONAL
P_ASSET_SAV_EXTERNAL
PW
REGION
REGION_ID
ROLE
ROLE ASSIGNMENT
TIBC
TRANSIT
TRANSIT_FINAL
TRANSIT_ID
TRANSIT_LIKE_ME
TYPE2
TYPE3
WG_BALANCE

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top