SAS DIS column attribute global change

[acfarrer]

Using SAS DIS 4.904, I have 16 jobs where a column's attributes need to change from $10 to $20 (length, format, informat)

There may be more as the column is transformed to other names in the the ETL.

So far, I am making manual changes once the Jobs are Checked Out. Can this be automated? The Propagation tool seems erratic and is limited to the diagram. The 16 jobs are part of 52 step ETL controlled by an external scheduler.

The Impact Report from the first table is 66 pages and I cannot get the sas-relationship-reporter to work yet

Would this be easier if the ETL was a SAS Job Flow ?

[LinusH]

Perhaps the Column Standardization Tool could be at your aid here.
i haven't use it myself, but it seems to cover your needs.
http://documentation.sas.com/doc/en/etlug/4.903/n0kw06lyyymqzin14dl0a1x9dtat.htm
SAS Job Flows has nothing to do with column metadata.