I have joined 3 tables (table1, table 2, table 3) with Empid which is common in all three tables.
The final merged table is Four.
Data Four;
merge table1(in=a)
table2(in=b)
table3(in=c);
by Empid;
if a and b and c;
run;
proc print data = Four;
Run;
I got the final table Four.
My question is :
What steps would you take to ensure your dataset is correct apart from reading the log and apart from reading the first few lines of the code as formal testing?
... View more
