I finally understand what you want, but you lost me right there. So basically you need a metadata that will hold both deleted and existing columns information. Why? what is the point to have a metadata that does not match what you have in the data source? If you have a constantly changing data source, then you need to update (sync) your metadata just as often. You can choose to run Proc metlib in batch on regular basis (we do it daily at middle night) or on the fly every time before you use it. Just my2cents. Haikuo
... View more