SAS helper macros for peforming ETL tasks
%etl_load_sas_simple_vfvt
would load the target table provided that the New/To-Be-Modified/To-Be-Closed records have already been separated in different temp tables
%etl_simple_vfvt_wrapper
would provide an easy-to-understand „interface” to the user, in which only the target and source tables, natural key and other attributes list and some other parameters should be provided
%etl_test_connection
would check the existence of one or more given datasets
%hashjoin
simple wrapper for SAS Hash object
%shrink_table
shrinks char columns to max(length(.))
%etl_table_dupker
checks for key uniqueness
%ruleBasedAssignment
enhanced maptable lookup:
- joker char (e.g. #) acception
- rule ordering in case of multiple match
- allowing for the following operators: IN, NOTIN, LIKE, NOTLIKE, EQ, NE, LE, LT, GE, GT + LIKE, NOTLIKE: through PRXMATCH