Automatization of Code Extraction from SAS EG project

[Baki]

Okay I have an interesting automatization idea for my ML process that includes SAS EG.

Basically, I have SAS EG project that I use to extract client data that will later be used for ML modeling.

I use saspy to establish connection between my SAS Linux server and local windows computer.

Currently, I have EG project, from which I extract .sas file that I store and then use in my automatized process. Now that manual work is sometimes problematic, e. g. I make simple changes in EG and forget to export SAS EG to .sas and replace old versions of .sas files that are used.

I would like to know, is there any way to program (in Python, PowerShell...) script that automatically extracts .sas file from EG project. I have looked at some COM objects that are used for Outlook (and I use them), but I haven't found that kind of solution for EG Project.

So the main idea, I create a script that automatically creates .sas file from SAS EG project, so that every change in SAS EG project will automatically be applied to my ML modelling process that is fully automatized besides this part of .sas code extraction from SAS EG every time I change it.

Best regards and thanks for help in advance!

[yabwon]

You can use this macro I've wrote some time ago that takes EGP project file and extracts all .sas files from inside.

Here is link to the post:

https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-list-all-programs-included-in-an-egp-fi...

Bart

[Baki]

Great, thanks!
I will implement it and see how it works.

[Baki]

Just 2 quick questions.
1. If I have links that determine the order of execution of my SAS EG project, is it the creation order of .sas files?
2. Are names of those .sas files that are zipped based on the names of programs that are their source?

[yabwon · Accepted solution]

1) Don't know.

2) I don't think so.

Bart

P.S. If I want to have a single file that keeps my code and my order of execution I'm using SAS packages (https://github.com/yabwon/SAS_PACKAGES)

[AlanC]

I wrote an extensive C# project that extracted all of the aspects of the EG project files. It then serialized them out to files. This included metadata, etc.

EG project files are not structured the same between versions. The code tries to accommodate but I didn't have an example of each one.

Look at https://github.com/savian-net/SaviEg