7 proc sql 78 select 79 Product ID, 80 Product Name, 81 Mfg Suggested Retail Price 82 from 83 lib shoe vendors 84 where 85 Supplier ID 1303 86 and Mfg Suggested Retail Price ( 87 select 88 (mean(Mfg Suggested Retail Price) 2 std(Mfg Suggested Retail Price)) 89 from 90 lib shoe vendors 91 where 92 Supplier ID 1303 93 ) 94 order by 95 Mfg Suggested Retail Price asc 96 limit 1 22 202 ERROR 22 322 Syntax error, expecting one of the following

Question

7 proc sql  78 select 79 Product ID, 80 Product Name, 81 Mfg Suggested Retail Price 82 from 83 lib shoe vendors 84 where 85 Supplier ID   1303 86 and Mfg Suggested Retail Price   ( 87 select 88 (mean(Mfg Suggested Retail Price)   2   std(Mfg Suggested Retail Price)) 89 from 90 lib shoe vendors 91 where 92 Supplier ID   1303 93 ) 94 order by 95 Mfg Suggested Retail Price asc 96 limit 1        22 202 ERROR 22 322  Syntax error, expecting one of the following

SolutionInn · Accepted Answer

The Answer is in the image, click to view ...

Question: 7 proc sql; 78 select 79 Product_ID, 80 Product_Name, 81 Mfg_Suggested_Retail_Price 82 from 83 lib.shoe_vendors 84 where 85 Supplier_ID = 1303 86 and Mfg_Suggested_Retail_Price >

Step by Step Solution