SAS_MERGING

233737  data  height(keep=name height)
233738        weight(keep=name weight)
233739        sex(keep=name sex)
233740        age(keep=name age);
233741     set sashelp.class;
233742  run;
 
NOTE: Compression was disabled for data set WORK.SEX because compression overhead would increase the size of the data set.
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: The data set WORK.HEIGHT has 19 observations and 2 variables.
NOTE: Compressing data set WORK.HEIGHT increased size by 100.00 percent.
      Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: The data set WORK.WEIGHT has 19 observations and 2 variables.
NOTE: Compressing data set WORK.WEIGHT increased size by 100.00 percent.
      Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: The data set WORK.SEX has 19 observations and 2 variables.
NOTE: The data set WORK.AGE has 19 observations and 2 variables.
NOTE: Compressing data set WORK.AGE increased size by 100.00 percent.
      Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds

One to One Match Merging

Create a dataset named heightweight by merging height and weight datasets based on the values present in name variable

233762  proc sort data=height;
233763     by name;
233764  run;
 
NOTE: There were 19 observations read from the data set WORK.HEIGHT.
NOTE: The data set WORK.HEIGHT has 19 observations and 2 variables.
NOTE: Compressing data set WORK.HEIGHT increased size by 100.00 percent.
      Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
 
 
233765
233766  proc sort data=weight;
233767     by name;
233768  run;
 
NOTE: There were 19 observations read from the data set WORK.WEIGHT.
NOTE: The data set WORK.WEIGHT has 19 observations and 2 variables.
NOTE: Compressing data set WORK.WEIGHT increased size by 100.00 percent.
      Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
233769
233770  data heightweight;
233771     merge height weight;
233772     by name;
233773  run;
 
NOTE: There were 19 observations read from the data set WORK.HEIGHT.
NOTE: There were 19 observations read from the data set WORK.WEIGHT.
NOTE: The data set WORK.HEIGHTWEIGHT has 19 observations and 3 variables.
NOTE: Compressing data set WORK.HEIGHTWEIGHT increased size by 100.00 percent.
      Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds

Create a dataset named hws by merging height,weight and sex datasets based on the values present in name variable

241259  proc sort data=height;
241260     by name;
241261  run;
 
NOTE: Input data set is already sorted, no sorting done.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
241262
241263  proc sort data=weight;
241264     by name;
241265  run;
 
NOTE: Input data set is already sorted, no sorting done.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
241266
241267  proc sort data=sex;
241268     by name;
241269  run;
 
NOTE: There were 19 observations read from the data set WORK.SEX.
NOTE: The data set WORK.SEX has 19 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
 
 
241270
241271  data hws;
241272     merge height weight sex;
241273     by name;
241274  run;
 
NOTE: There were 19 observations read from the data set WORK.HEIGHT.
NOTE: There were 19 observations read from the data set WORK.WEIGHT.
NOTE: There were 19 observations read from the data set WORK.SEX.
NOTE: The data set WORK.HWS has 19 observations and 4 variables.
NOTE: Compressing data set WORK.HWS increased size by 100.00 percent.
      Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds

Create a dataset named ahws by merging age,height,weight and sex datasets based on the values present in name variable

248759  proc sort data=age;
248760     by name;
248761  run;
 
NOTE: There were 19 observations read from the data set WORK.AGE.
NOTE: The data set WORK.AGE has 19 observations and 2 variables.
NOTE: Compressing data set WORK.AGE increased size by 100.00 percent.
      Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
248762
248763  proc sort data=height;
248764     by name;
248765  run;
 
NOTE: Input data set is already sorted, no sorting done.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
248766
248767  proc sort data=weight;
248768     by name;
248769  run;
 
NOTE: Input data set is already sorted, no sorting done.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
 
 
248770
248771  proc sort data=sex;
248772     by name;
248773  run;
 
NOTE: Input data set is already sorted, no sorting done.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
 
 
248774
248775  data ahws;
248776     merge age height weight sex;
248777     by name;
248778  run;
 
NOTE: There were 19 observations read from the data set WORK.AGE.
NOTE: There were 19 observations read from the data set WORK.HEIGHT.
NOTE: There were 19 observations read from the data set WORK.WEIGHT.
NOTE: There were 19 observations read from the data set WORK.SEX.
NOTE: The data set WORK.AHWS has 19 observations and 5 variables.
NOTE: Compressing data set WORK.AHWS increased size by 100.00 percent.
      Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

*Copyright @ www.mycsg.in;

What is the word meaning of 'merge'?

Common scenarios where merging (joining rows into a single observation) is required

What does 'MERGE statement' of SAS data step do?

What is 'match merging' in SAS?

Creating some sample datasets

One to One Match Merging

Create a dataset named heightweight by merging height and weight datasets based on the values present in name variable

Create a dataset named hws by merging height,weight and sex datasets based on the values present in name variable

Create a dataset named ahws by merging age,height,weight and sex datasets based on the values present in name variable