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
Step: 1
It appears that the errors are related to misspelled or incorrectly referenced column names in your ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started