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;

Answer rating: 100% (QA)

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