Merge Two data set or Nested Data set

[rsathe]

HI,

      I have two data set and i want to search one data set to another when exact match is found increment 5% in both number_of_items and value, i know i can do it with merge but i am not able to do it because there four variable which is missing in any order. can i do it with the help of nested loop i tried but it giving me wrong result and gets merge which don't want. i need value from purchase data set only.

data sets

DATA product;
INFILE DATALINES DELIMITER=',' DSD;
INPUT k1 $ k2 $ k3 $ k4 $;
DATALINES;
63,,9141,1501
51,214,9280,,
57,,,1505
1,150,9172,,
58,214,,,
64,120,9666,,
,,,641
RUN;

DATA purchase;
INFILE DATALINES DELIMITER=',' DSD;
INPUT k1 $ k2 $ k3 $ k4 $ number_items value;
DATALINES;
63,,9141,1501,10,10
51,214,9280,1502,10,10
57,,,1505,10,10
1,150,9172,,10,10
58,214,9180,,10,10
59,214,9180,,10,10
64,120,9666,,10,10
RUN;

my approach if every value is present and need to find exact match.

data want;
    merge product(in=pro_in) purchase(in=pur_in);
           by key1 key2 key3 key4;

     if pro_in and pur_in then
           do;
              *perform action ;
       end;

but my below code will not work because of missing value so i tried this it is not giving me result

data want;
    merge product(in=pro_in) purchase(in=pur_in);
           by key1 key2 key3 key4;

if k1 ne '' and k2 ne '' and k3 ne '' and k4 ne '' then
do;

end;

else if k1 = '' and k2 ne '' and k3 ne '' and k4 ne '' then
do;
*perform action ;
end;

* so on different condition;
run;

product 

purchase

desire output

can i do it with nested loop or merge with given constraints? please provide hint or solution. 

[Kurt_Bremser]

Please post example datasets that illustrate your issue. Post them in datasteps with datalines, so we can easily recreate your data.

[rsathe]

Hi KurtBremser,

   I update my question with data sets.