topic Re: Automation: how export the SAS the whole EG project process flow to a sas code (programatically in SAS Enterprise Guide

Automation: how export the SAS the whole EG project process flow to a sas code (programatically)

chandusaladi — Tue, 27 Feb 2024 18:02:47 GMT

Hi,

I want to export the SAS EG project to a .sas file so that it can be run without depending on SAS EG. Additionally, I want to automate the exporting process of EG projects since I have hundreds of projects that need to be converted into .sas files."

Re: Automation: how export the SAS the whole EG project process flow to a sas code (programatically

Kurt_Bremser — Tue, 27 Feb 2024 20:03:37 GMT

EG itself can only export a project to a program file one at a time; AFAIK, there is no internal scripting for this available. You would need to dig into the automation facilities of Windows, if it can script the loading and exporting of a project through the user interface (by recording all keystrokes and mouse actions).

Re: Automation: how export the SAS the whole EG project process flow to a sas code (programatically

AlanC — Tue, 27 Feb 2024 20:29:12 GMT

I have the code to do this. Will try and get it to github as a console app.

It will use .NET 8 if you are interested.

Re: Automation: how export the SAS the whole EG project process flow to a sas code (programatically

AhmedAl_Attar — Tue, 27 Feb 2024 20:43:11 GMT

Hi @chandusaladi

Have a look at this 2017 article Doing More with SAS Enterprise Guide Automation by @ChrisHemedinger

It may have something you can use

Re: Automation: how export the SAS the whole EG project process flow to a sas code (programatically

Patrick — Tue, 27 Feb 2024 23:25:15 GMT

@chandusaladi wrote:

Hi,

I want to export the SAS EG project to a .sas file so that it can be run without depending on SAS EG. Additionally, I want to automate the exporting process of EG projects since I have hundreds of projects that need to be converted into .sas files."

In an ideal world you would migrate these EG projects to Viya 4 SAS Studio Flow which are server side flow definitions that then also allow for server side scheduling.

Go with the flow; migrating Enterprise Guide Projects to SAS Studio Flows

Re: Automation: how export the SAS the whole EG project process flow to a sas code (programatically

chandusaladi — Wed, 28 Feb 2024 00:23:17 GMT

The SAS EG projects are currently in version EG 6.1. Since we cannot directly migrate these projects to SAS Viya 4 (which supports only versions above EG 7.0), we have decided to convert them to .sas files and then proceed with the migration

Re: Automation: how export the SAS the whole EG project process flow to a sas code (programatically

Patrick — Wed, 28 Feb 2024 00:33:47 GMT

@chandusaladi wrote:

The SAS EG projects are currently in version EG 6.1. Since we cannot directly migrate these projects to SAS Viya 4 (which supports only versions above EG 7.0), we have decided to convert them to .sas files and then proceed with the migration

There is an EG migration wizard that should make it a rather simple task to first migrate the project in bulk to EG7.x

If it was me then I'd consider a migration to Studio Flow preferable over an export to .sas files.

The more I'm getting into Studio Flow as part of my own learning journey the more I really start to like all the functionality and integration points it offers.

Re: Automation: how export the SAS the whole EG project process flow to a sas code (programatically

chandusaladi — Wed, 28 Feb 2024 19:18:19 GMT

Thank you, could you please share

Re: Automation: how export the SAS the whole EG project process flow to a sas code (programatically

AlanC — Wed, 28 Feb 2024 19:30:57 GMT

Will do once ready. I started work last night on making it accessible from the command line.

I will update this thread once ready (next week, hopefully).

Re: Automation: how export the SAS the whole EG project process flow to a sas code (programatically

SASKiwi — Wed, 28 Feb 2024 20:05:45 GMT

@chandusaladi - Doing a manual "Save As" in EG 8.3 to upgrade your projects to a migratable version would be pretty quick even with hundreds of projects.

Re: Automation: how export the SAS the whole EG project process flow to a sas code (programatically

AlanC — Fri, 01 Mar 2024 06:46:41 GMT

Prelim version that does a bare minimum, for now. I left out the parsing and reporting for SAS code so you can accomplish the bare minimum (extract code):

savian-net/SaviEg: Extracts SAS EG projects into SAS code and does reporting on contents (github.com)

I will add in the other bits over time. They are coded but in a different project. Let me know how it goes.

I also made it x64. .NET 5+ runs on all major platforms so the code could run as portable but I don't have another OS (outside of Windows) installed. If a need arises to support Linux, I can recompile and someone can test it.