topic How to update new data and avoid duplicates in SAS Procedures

How to update new data and avoid duplicates

co_ba — Thu, 15 Dec 2011 21:03:01 GMT

What is the best approach to update a data set that only adds the new data, change in case of revisions but does not create a duplicate variables?

data merge, proc sql?

Thanks for your advice

co-ba

How to update new data and avoid duplicates

Tom — Fri, 16 Dec 2011 02:04:27 GMT

If you want to replace existing rows then use MERGE. Make sure to have the new dataset listed last.

data want ;

merge old new ;

by id ;

run;

You could also look at the UPDATE statement, but that is really intended for transactions, not new records. Read about what happens when the transaction dataset has missing values for a variable.

For more complicated situations look at the MODIFY statement.

How to update new data and avoid duplicates

Ksharp — Fri, 16 Dec 2011 02:07:59 GMT

What is your sample data?

What data do you want to add ? and Final dataset is what looks like?

Ksharp