SAS DIS column attribute global change

acfarrer — Wed, 08 Dec 2021 16:39:00 GMT

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 ?

Re: SAS DIS column attribute global change

LinusH — Thu, 09 Dec 2021 07:35:50 GMT

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.

topic SAS DIS column attribute global change in SAS Data Management

SAS DIS column attribute global change

Re: SAS DIS column attribute global change