BookmarkSubscribeRSS Feed
acfarrer
Quartz | Level 8

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 ?

 

 

 

1 REPLY 1
LinusH
Tourmaline | Level 20
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.
Data never sleeps

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 542 views
  • 1 like
  • 2 in conversation