Hello,   I am trying to clean up some code for processing updates from a transaction dataset to a master dataset.  I ran across this SAS paper and subsequent SAS documentation that explains how to use the MODIFY statement to achieve this.   http://www2.sas.com/proceedings/sugi31/264-31.pdf   All of this works as instructed, but I need it to work a little bit differently and I have not been able to figure out how to do it.  In this paper, it talks about replacing the record in the master dataset if it also exists in the transaction dataset.  The issue I have is that I only want it to replace a record if the data for one of the records variables has changed.  In this case above, the entire record is rewritten because they match, regardless if any of the data has changed.   The reason I am trying to do this is because I want to be able to track and report on records that have had data change each day.  Is there a way to do this using the methods in this paper or similar?   Thanks! ... View more

I want to ask a follow up question to @CaseySmith to this thread from 2016 but it is locked.  In your solution to export logs from the VB Script, it currently exports logs from each process flow in the project.  How can I change this so it is only exporting the log from a specific containername?   https://communities.sas.com/t5/SAS-Enterprise-Guide/Export-SAS-log-to-external-files/td-p/287838   Thanks for your help! ... View more

Hello everyone,   I am trying to develop a good data validation process for data in an existing database.  What I would like to do is be able to scan the data in each variable to make sure the format is the same and values are existent and correct.  The purpose is to find data that is not formatted correctly so I can reformat and make sure the data in each observation is formatted correctly.   I have searched on Google and can't seem to find exactly what I am looking for.  I am hoping you can help.   Thanks! ... View more