Problem1(=Chapter26Problem1fromCody) UsePROCSQLto list all the observations from data set Inventory where Price is greater than 20. Problem2(=Chapter26Problem2fromCody)
Question:
Problem1"(=Chapter26Problem1fromCody)"
UsePROCSQLto list all the observations from data set Inventory where Price is greater than 20.
Problem2"(=Chapter26Problem2fromCody)"
Repeat Problem 1 (from Cody book which is the same to Problem 1 above), except use PROC SQLtocreateanew,temporarySASdataset(Price20)containingallobservationsfromInven- tory where the Price is greater than 20.
Problem3"(=Chapter26Problem3fromCody)"
UsePROCSQLtocreateanew,temporary,SASdataset(NSales)containingtheobservations fromSaleswhereRegionhasavalueofNorth. IncludeonlythevariablesNameandTotalSales in the new data set.
Problem4"(=Chapter26Problem6fromCody)"
WritethenecessaryPROCSQLstatementstoaccomplishthesamegoalastheprogramhere:
dataallproducts;
setlearn.inventorylearn.newproducts; run;
Don't forget that you need to make PROCSQLto create a dataset with the same name as above.
Problem5"(=Chapter26Problem7fromCody)"
WritethenecessaryPROCSQLstatementstoaccomplishthesamegoalastheprogramhere:
datathird;
setlearn.firstlearn.second; run;
Be careful!The order of the variables is not the same in both data sets.Also, some subject numbers are in both data sets.Don't forget that you need to make PROCSQLto create a dataset with the same name as above.
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last