Merge Two data set or Nested Data set

rsathe — Tue, 06 Feb 2018 09:58:42 GMT

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.

Re: Merge Two data set or Nested Data set

Kurt_Bremser — Tue, 06 Feb 2018 08:21:21 GMT

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

Re: Merge Two data set or Nested Data set

rsathe — Tue, 06 Feb 2018 10:00:01 GMT

Hi KurtBremser,

I update my question with data sets.

topic Merge Two data set or Nested Data set in SAS Enterprise Guide

Merge Two data set or Nested Data set

Re: Merge Two data set or Nested Data set

Re: Merge Two data set or Nested Data set