I have dozens of .sas programs and they are running pretty simple data transformations.
I know I can automate registering tables by using proc metalib however I would like to automate the registering of the program as a job in metadata too and hopefully capture the data lineage from source to target as well. I see DI studio has something to import .sas code and I think it runs PROC SCAPROC in the background and it captures everything as jobs and tables. I want that, but I want to be able to automate that.
I don't have DI Studio at my finger tips, so I can't tell for sure, but it doesn't look that way when you look in the documentation.
It's somewhat logical, since imported SAS code usually needs some manual adjustments to look/work well from a DI Studio perspective.
So perhaps you need to hire a student who does the boring part of point and click...
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.