topic application of in in merge in SAS Programming

application of in in merge

veda8 — Sun, 19 Jul 2020 16:02:41 GMT

These are the two questions given

1) Explicitly output rows for products with sales (matches
products in the profit table) to the profit_detail table.
*2) Explicitly output rows for products without sales to the *
product_nosales table.

proc sort data=crb.profit out=profit_sort;
by Product_ID;
run;

proc sort data=crb.products out=products_sort;
by Product_ID;
run;

data profit_detail product_nosales;
merge profit_sort(in=inprof) products_sort(in=inprod);
by Product_ID;
if inprof=1 and inprod=1 then output profit_detail;
else if inprof=0 and inprod=1 then output product_nosales;

(i didnt understood how from the question this statment was written .I felt the question was not quite clear,Can someone please explain)
run;

proc print data=product_detail;
run;

proc print data=product_nosales;
run;

@Tom @FreelanceReinh

Re: application of in in merge

Tom — Sun, 19 Jul 2020 17:09:23 GMT

Your answer looks good to me.

When I am answering a question that seems be imprecisely worded I like to explicitly state how I have interpreted the question and any assumptions I have to make to be able to provide an answer.

Re: application of in in merge

Kurt_Bremser — Sun, 19 Jul 2020 18:10:50 GMT

Take a good look at your code:

data profit_detail product_nosales;
merge profit_sort(in=inprof) products_sort(in=inprod);
by Product_ID;
if inprof=1 and inprod=1 then output profit_detail;
else if inprof=0 and inprod=1 then output product_nosales;
run;

In both conditions that lead to an output, inprod must be 1 (true), so you can move that up and use a subsetting if:

if inprod;

and then direct the output depending on inprof, so the complete code would be:

data
  profit_detail
  product_nosales
;
merge
  profit_sort (in=inprof)
  products_sort (in=inprod)
;
by Product_ID;
if inprod;
if inprof
then output profit_detail;
else output product_nosales;
run;

Re: application of in in merge

veda8 — Mon, 20 Jul 2020 05:41:19 GMT

the solution isnt written by me.I am not understanding from the question how they derived this solution ie. especially the second if statement