DATA Step, Macro, Functions and more

creating and modifying the control table based on exact match

Reply
Frequent Contributor
Posts: 85

creating and modifying the control table based on exact match

Hi All,

I have source table, target table and control table.

In first run, my target table will be loaded completely, but in second run only new records should be loaded and duplicate records should be loaded to control table. How to implement that ?? Need some help.

Source table run1

var1 var2var3
102030
405060

Target table run1

var1 var2var3
102030
405060

Control table run1

Job_nameStatusvar_ListNo of rowsDateDuplicates
SampleSuccessvar1,var2,var3217-Jul-14N

Now in run2 Source is

var1 var2var3
506070
405060

Target should be

var1 var2var3
102030
405060
506070

Control table should be

Job_nameStatusvar_ListNo of rowsDateDuplicates
SampleSuccessvar1,var2,var3217-Jul-14N
SampleSuccessvar1,var2,var3117-Jul-14Y

Any help is highly appreciated

Super User
Super User
Posts: 7,430

Re: creating and modifying the control table based on exact match

Why not just load the dataset as normal then do a proc sort nodupkey dupout=?  E.g. This would then give you a table with distinct rows and a table with the duplicates.  You can then post-process the duplicates to get your control dataset.

Ask a Question
Discussion stats
  • 1 reply
  • 166 views
  • 0 likes
  • 2 in conversation