Providing software solutions since 1976
Sample 24679: Merging data sets by a common variable and create output data sets based upon observation origin
 |  |  |  |  |  |
Combine multiple data sets based upon a common variable.
Create new data sets: one for observations found in both data
sets and 2 other data sets for observations found in one data set
only.
Use IN= logic to determine if the current BY-Group is found in
both data sets.
These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.
data one;
input id $ name $ dept $ project $;
datalines;
000 Miguel A12 Document
111 Fred B45 Survey
222 Diana B45 Document
888 Monique A12 Document
999 Vien D03 Survey
;
data two;
input id $ name $ projhrs;
datalines;
111 Fred 35
222 Diana 40
777 Steve 0
888 Monique 37
999 Vien 42
;
data both one_only two_only;
merge one(in=in1) two(in=in2);
by id;
if in1 and in2 then output both;
else if in1 then output one_only;
else output two_only;
run;
title 'Both';
proc print data=both;
run;
title 'One only';
proc print data=one_only;
run;
title 'Two only';
proc print data=two_only;
run;
These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.
Both Obs id name dept project projhrs 1 111 Fred B45 Survey 35 2 222 Diana B45 Document 40 3 888 Monique A12 Document 37 4 999 Vien D03 Survey 42 One only Obs id name dept project projhrs 1 000 Miguel A12 Document . Two only Obs id name dept project projhrs 1 777 Steve 0
Combine multiple data sets based upon a common variable.
Create new data sets: one for observations found in both data
sets and 2 other data sets for observations found in one data set
only.
| Type: | Sample |
| Topic: | SAS Reference ==> DATA Step SAS Reference ==> Statements ==> File-handling ==> MERGE Common Programming Tasks ==> Combining Data SAS Reference ==> Statements ==> File-handling ==> MERGE ==> with IN= Common Programming Tasks ==> Selecting Data |
| Date Modified: | 2011-11-21 13:26:26 |
| Date Created: | 2004-09-30 14:09:03 |
Operating System and Release Information
| Product Family | Product | Host | SAS Release | |
| Starting | Ending | |||
| SAS System | Base SAS | All | n/a | n/a |
