topic Re: Merge in SAS Programming

Merge

souji — Sat, 11 Jan 2020 17:15:41 GMT

Hi,

Another one, Please correct me, if I am wrong

#5- do not know how to get it

/*Scenario:

1.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(=Qtr*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'? */

proc sort data=Souj.input24a out=out.input24a;

by product;

run;

proc sort data=Souj.input24b out=out.input24b;

by product;

run;

data results.output24;

merge out.input24a out.input24b;

by product;

totalPrice=gty*price;

run;

proc means data=results.output24;

by product;

where product='Tape';/* I think #6)

run;

Re: Merge

ed_sas_member — Sat, 11 Jan 2020 17:51:26 GMT

Hi @souji

At first sight it seems that proc means should be:

proc means data=results.output24 mean;
var totalprice;
where product='Tape';
run;

There is also a typo -> gty should be replaced by qty in your code

The very first thing to do would be to try your code!

You will easily see if the syntax is correct and if you get the right results (especially in this case, as there are very few variables and observations).

Re: Merge

souji — Sat, 11 Jan 2020 18:00:23 GMT

Hi @ed_sas_member

Thank you for your quick response, I appreciate you

What about : 5. what is the grand total totalprice for the product='screwdriver'?

please help me this too

Souji

Re: Merge

ed_sas_member — Sat, 11 Jan 2020 18:39:47 GMT

Hi @souji,
You’re welcome!
For question 5, I believe you are asked to compute the sum of totalprice of screwdrivers.
An easy way to do that is to use a proc print :
Proc print data=results.output24;
Sum totalprice ;
Where product = ‘screwdriver’;
Run;

You can also use a proc means -> change mean by sum in your code and adapt the condition where.

Best

Re: Merge

Mona4 — Mon, 14 Nov 2022 15:38:16 GMT

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????????

Re: Merge

PaigeMiller — Mon, 14 Nov 2022 15:41:36 GMT

What part of the documentation do you need an explanation for? Please be specific.

Re: Merge

Mona4 — Mon, 14 Nov 2022 19:03:58 GMT

*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’?

Re: Merge

Mona4 — Mon, 14 Nov 2022 19:04:30 GMT

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’?

Re: Merge

PaigeMiller — Mon, 14 Nov 2022 20:10:41 GMT

What part of this are you having trouble with? Can you show us the code you have tried so far?