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
2025 SAS Hackathon: There is still time!
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.