Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Updating SAS Dataset With Files in Sequential Order

Status
Not open for further replies.

TechSlinger

Technical User
Oct 31, 2013
19
CA
Hi

I am using SAS 9.3.

I have a dataset that is made up of many data elements of a patient visit - one line of data is one abstract. There is the original dataset from the submission and then many correction files. All files have all the same data elements so even if the field isn't being corrected, it will still be there so that an entire abstract can be overwritten. Correction filenames are all numbered in ascending order.

I want the correction files to update the original dataset but in order of the correction file. This is because one abstract could have multiple corrections, sometimes even the same field, so the updates must occur in sequence.

Is this possible and if so can you please advise how? Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top