Hello
Let's say that I work on 2 tera tables in order to create sas data set.
Here are 3 ways: way1 is 100% working well , Way2 is also 100% working well.
I want to ask about way3 only in order to learn it.
Is it possible to -
A-create a violate table1 in Tera
B-create a violate table2 in Tera
C-create a violate table3 in Tera by merge violate table1+ violate table2
D-Create SAS data set from violate table3
/***WAY1***/
/***WAY1***/
/***WAY1***/
proc sql;
connect to teradata (server=dwprod schema=DWP_vall authdomain=TeraDataAuth);
create table VBM374 as
select * from connection to teradata
(
SELECT top 100000 Branch_Cust_Nbr as customer_ID,Branch_Cust_IP,first_Branch_Cust_IP as numerator,Team_IP
from VBM374_USED_BRANCH_CUSTOMER
);
disconnect from teradata;
quit ;
proc sql;
connect to teradata (server=dwprod schema=DWP_vall authdomain=TeraDataAuth);
create table VBM376 as
select * from connection to teradata
(
SELECT top 100000 Team_IP,Branch_Nbr
from VBM376_INTERNAL_ORGANIZATION
);
disconnect from teradata;
quit ;
proc sql;
create table WANT_WAY1 as
select a.*,b.Branch_Nbr
from VBM374 as a
inner join VBM376 as b
on a.Team_IP=b.Team_IP
;
quit;
/***WAY2***/
/***WAY2***/
/***WAY2***/
proc sql;
connect to teradata (server=dwprod schema=DWP_vall authdomain=TeraDataAuth);
create table WANT_WAY2 as
select * from connection to teradata
(
SELECT top 100000 a.Branch_Cust_Nbr as customer_ID,a.Branch_Cust_IP,a.first_Branch_Cust_IP as numerator,a.Team_IP,b.Branch_Nbr
from VBM374_USED_BRANCH_CUSTOMER as a
inner join VBM376_INTERNAL_ORGANIZATION as b
on a.Team_IP=b.Team_IP
);
disconnect from teradata;
quit ;
/***WAY3***/
/***WAY3***/
/***WAY3***/
/**Create violtate table1 in tera data ***/
/*SELECT top 100000 Branch_Cust_Nbr as customer_ID,Branch_Cust_IP,first_Branch_Cust_IP as numerator,Team_IP*/
/*from VBM374_USED_BRANCH_CUSTOMER*/
/**Create violtate table2 in tera data ***/
/*SELECT top 100000 Team_IP,Branch_Nbr */
/*from VBM376_INTERNAL_ORGANIZATION*/
/**Create violtate table3 in tera data ***/
/*by merge violtate table1 +violtate table2*/
/**Create sas data set from violtate table3**/
... View more
