topic Re: comparing files in SAS Enterprise Guide

comparing files

carmendee — Fri, 11 Dec 2015 15:55:19 GMT

Simplist way in Enterprise Guide to keep and update all the rows in one file and add new rows and or update rows.

Example

Input 1

Tom Active

Bob Active

Tim Active

Jack Inactive

Input 2

Tom Inactive

Sue Active

Output desired:

Tom InActive (Updated row)

Bob Active

Tim Active

Jack Inactive

Sue Active (new row)

LinusH — Fri, 11 Dec 2015 16:43:21 GMT

What can be called simple depends on your preferences and skills.

By programming: data step merge, update or modify (or even SQL) will solve this "simple" update scenario.

If you are more of point-and-click-person, I think unfortunately the only standard component for this kind of of operation is Query Builder.

There you can do a full outer join. Remember that you need to define calculated columns using coalesce() function.

Ok, perhaps, not that very simple...?