The links above have code and detailed comments. If you only have certain fields that need updating only keep those in your dataset use the keep = on the update statement. update master transaction(keep=nbkid field1_update field2_update); by nbkid; ... View more

jhrbanker wrote: So, for example, if I'm receiving a text file MyText.txt monthly, when I look at my table, I want to be able to determine if the data in the table is from a file I received in April, or if it's March data. Thanks, How do you know if a file you received is in April/March? Do you look at the create date of the file? What happens if you have a drive failure or a file gets recopied for some reason and the create date changes? Or is the date included in the file name? ... View more