BookmarkSubscribeRSS Feed
PatrickCuba
Obsidian | Level 7

Hi All,

 

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. 

 

Is it possible?

 

BTW I'm using 9.4M4

1 REPLY 1
LinusH
Tourmaline | Level 20

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.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 997 views
  • 0 likes
  • 2 in conversation