02-08-2012 01:26 PM
Carefully! I typically run the same code on a smaller versions of the datasets, and check the results. Whenever possible, I also try to run both proc sql and datastep merges on the smaller versions of the datasets and test to ensure that I get the same results.
02-08-2012 02:48 PM
the most important things for me:
02-08-2012 02:58 PM
One company I know went so far as to require users to perform all merges using their SMERGE macro. (Safe MERGE?)
The use had to specifiy whether to keep the duplicate variable names from the first or last dataset in the merge. It would do run-time checks to trap many-to-many merges.