The SAS client for ETL development would be SAS Data Integration Studio. There you would have ready made loaders. You can write your own loader and implement it as a SAS macro. First write the code for loading one of the tables and test it. Only then generalize it by wrapping a macro around. As you need to load deltas you will need to somehow compare your new source records with the already loaded target records. There are different ways of doing this and it depends on what volumes you're dealing with. What you want to avoid is loading the target table into SAS for doing this comparison. May be easiest when "hand coding" would be to load the business keys from source into the db, compare with the db table and create a table with the new keys ( the delta). You then use this delta within SAS to select your new records and you append them to the target table via Proc Append. If there are a lot of records to be loade then you can define bulk load options with Proc Append. If you want to use such an approach then this link will be of interest for you http://support.sas.com/documentation/cdl/en/acreldb/63647/HTML/default/viewer.htm#a002680719.htm
... View more
