About Skn

Skn · ‎04-12-2017

@ChrisBrooks Thank you. I used the smiliar logic.

Skn · ‎04-12-2017

@CiCi thank you!

Skn · ‎04-11-2017

Hi Chris, Sorry for not being clear here. To keep it simple. I basically want a output dataset which will be result of dataset1 and dataset2. Either of the function from above works Output data I have provided, is the desired result I wanted. Rules: you can think this is a transactional data. Dataset1 is existing, Dataset2 is new. Update date is the date on which Dataset2 is run Every time when we run the Dataset2, there will be new records and overlap records on primary key. As an output I want, those new records from Dataset2. I don’t want to change the overlapping records. Thanks

Skn · ‎04-11-2017

Hi Chris, Sorry for not being clear here. To keep it simple. 1. I basically want a output dataset which will be result of dataset1 and dataset2. Either of the function from above works 2. Output data I have provided, is the desired result I wanted. 3. Rules: - you can think this is a transactional data. Dataset1 is existing, Dataset2 is new. Update date is the date on which Dataset2 is run - Every time when we run the Dataset2, there will be new records and overlap records on primary key. - As an output I want, those new records from Dataset2. I don't want to change the overlapping records. Thanks

Skn · ‎04-11-2017

Hi Team, I'm trying to merge/append/combine two datasets. there are few overlaps in both the datsets. I just want the data that is present only in Dataset 2 and not in Dataset1. any help is truly appreiciated! using SAS EG 6.1 Dataset1 Date Ord_no item update_date 4/9/2017 111 56 4/10/2017 4/9/2017 112 45 4/10/2017 4/9/2017 113 32 4/10/2017 4/9/2017 114 46 4/10/2017 4/9/2017 115 64 4/10/2017 Dataset 2: Date Ord_no item update_date 4/9/2017 111 56 4/11/2017 4/9/2017 112 78 4/11/2017 4/9/2017 113 32 4/11/2017 4/9/2017 114 46 4/11/2017 4/9/2017 122 34 4/11/2017 4/9/2017 124 56 4/11/2017 4/10/2017 134 75 4/11/2017 4/10/2017 135 76 4/11/2017 4/10/2017 136 77 4/11/2017 Output: Date Ord_no item update_date 4/9/2017 111 56 4/10/2017 4/9/2017 112 45 4/10/2017 4/9/2017 113 32 4/10/2017 4/9/2017 114 46 4/11/2017 4/9/2017 122 34 4/11/2017 4/9/2017 124 56 4/11/2017 4/10/2017 134 75 4/11/2017 4/10/2017 135 76 4/11/2017 4/10/2017 136 77 4/11/2017

Online Status	Offline
Date Last Visited	‎04-12-2017 01:49 PM

Re: Merge/append data with overlaps

Re: Merge/append data with overlaps

Re: Merge/append data with overlaps

Re: Merge/append data with overlaps

Merge/append data with overlaps

Re: Merge/append data with overlaps

Re: Merge/append data with overlaps

Re: Merge/append data with overlaps

Re: Merge/append data with overlaps

Re: Merge/append data with overlaps

Re: Merge/append data with overlaps

Merge/append data with overlaps