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

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

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
  • 1770 views
  • 0 likes
  • 2 in conversation