Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting Information for Decision-Making and Strategy Execution

Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young

6th Edition

137024975, 978-0137024971

More Books

Students also viewed these Databases questions