Souj.input24a contains 2 variables, Product and Qty for 20 transactions 2.Souj.input24b contains 2 variables, Product and Price for 20 transactions 3.Create output dataset results.output24 4.Merge data sets Souj.input24a and Souj.input24b one-to-one in order to calculate a new variable totalprice(=Quantity*Price) for each observation 5. what is the grand total totalprice for the product='screwdriver'? 6.what is the average(mean) totalprice for product='Tape’? ... View more

*difference between One-to-one merging and match merging* Souj.input24a contains 2 variables, Product and Qty for 20 transactions 2.Souj.input24b contains 2 variables, Product and Price for 20 transactions 3. *Create output dataset results.output24 4.Merge data sets Souj.input24a and Souj.input24b one-to-one in order to calculate a new variable* totalprice(=Quantity*Price) for each observation 5. what is the grand total totalprice for the product='screwdriver'? 6.what is the average(mean) totalprice for product='Tape’? ... View more

IN QUESTION Merge data sets Souj.input24a and Souj.input24b one-to-one in order to calculate a new variable totalprice=(Qtr*Price) for each observation   one-to-one merge (using without by statement) match merge(using by statement) https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/basess/n11fri54im86d4n1imc3rzeeffyt.htm#:~:text=Therefore%2C%20a%20one%2Dto%2D,must%20use%20a%20match%2 please can some one explain???????? ... View more