Question: Got a errors that say ERROR: Column ProdcutID could not be found in the table/view identified with the correlation name T x3 and then ERROR:

 Got a errors that say "ERROR: Column ProdcutID could not be found in the table/view identified with the correlation name T" x3 and then "ERROR: Column ProdcutID could not be found in the table/view identified with the correlation name S" x3 "ERROR: Column OrderDate could not be found in the table/view identified with the correlation name S" x4 and "ERROR: The following columns were not found in the contributing tables: PriceOut" How do I get rid of them?

libname States "msfs-03.grove.ad.uconn.eduhomedao19006DocumentsSASdatasets";

proc import file= "msfs-03.grove.ad.uconn.eduhomedao19006DocumentsSASInputWellington Global Marketplace v2"

out= states.emp

dbms= xlsx REPLACE;

run;

proc import file= "msfs-03.grove.ad.uconn.eduhomedao19006DocumentsSASInputWellington Global Marketplace v2"

out= states.emp

dbms= xlsx REPLACE;

sheet= "Employee_Master";

run;

proc import file= "msfs-03.grove.ad.uconn.eduhomedao19006DocumentsSASInputWellington Global Marketplace v2"

out= states.dep

dbms= xlsx REPLACE;

sheet= "Departments";

run;

proc import file= "msfs-03.grove.ad.uconn.eduhomedao19006DocumentsSASInputWellington Global Marketplace v2"

out= states.pro

dbms= xlsx REPLACE;

sheet= "Products";

run;

proc import file= "msfs-03.grove.ad.uconn.eduhomedao19006DocumentsSASInputWellington Global Marketplace v2"

out= states.salesbystate

dbms= xlsx REPLACE;

sheet= "Sales_Tax_By_State";

run;

proc import file= "msfs-03.grove.ad.uconn.eduhomedao19006DocumentsSASInputWellington Global Marketplace v2"

out= states.cus

dbms= xlsx REPLACE;

sheet= "Customers";

run;

proc import file= "msfs-03.grove.ad.uconn.eduhomedao19006DocumentsSASInputWellington Global Marketplace v2"

out= states.sal

dbms= xlsx REPLACE;

sheet= "Sales_2014";

run;

proc sql;

create table states.billingbystate as

select t.state, PriceOut*Quantity*(1-Discount)*(1+State_Tax_Rate) as Billing_Total

from states.salesbystate as t

join states.sal as s

on t.ProdcutID=s.ProductID

where s.OrderDate >= '01JAN2014'd and s.OrderDate < '01JAN2015'd

order by t.state;

quit;

Step by Step Solution

3.44 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

It appears that the errors are related to misspelled or incorrectly referenced column names in your ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!