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.
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.