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.

Answer rating: 100% (QA)

Sure here are the PROC SQL statements for each problem List all observations where Price is greater ... View the full answer