topic Merge that Keeps the Smaller Dataset Structure in SAS Programming

Merge that Keeps the Smaller Dataset Structure

DavidPhillips2 — Wed, 10 May 2017 17:55:45 GMT

Is there a merge function that combines columns from two datasets while only updating the smaller dataset with the first value of the larger dataset?

E.g. Dataset 1

Dataset 2

A orange

A blue

B pink

Result dataset

A orange

B pink

Re: Merge that Keeps the Smaller Dataset Structure

ballardw — Wed, 10 May 2017 18:08:41 GMT

This generates the desired result. I won't promise it is extensible for all cases.

data work.data1;
   input a $;
datalines;
A
B
;
run;
data work.data2;
   input a $ color $;
datalines;
A orange
A blue
B pink
;
run;

data work.try;
   merge work.data1 work.data2;
   by a;
   if first.a;
run;

Re: Merge that Keeps the Smaller Dataset Structure

PeterClemmensen — Wed, 10 May 2017 18:10:07 GMT

Not sure if this is what you are asking, but this gives the desired output

data dataset1;
input var1 $;
datalines;
A
B
;

data dataset2;
input var1 $ var2 $;
datalines;
A orange
A blue
B pink
;

proc sort data = dataset1;
   by var1;
run;

proc sort data = dataset2;
   by var1;
run;

data want;
   merge dataset1 dataset2;
   by var1;
   if first.var1;
run;

Re: Merge that Keeps the Smaller Dataset Structure

DavidPhillips2 — Wed, 10 May 2017 18:11:24 GMT

Ballardw,

Thanks I forgot about first dot. Happy letters and colors pair up now.