Tool to search a library of SAS egp files

[Kayellen61]

Does anyone know of a tool that I can run to search for specific tables or data columns being used in an egp file?

Thank you.

[ChrisHemedinger]

You can try using this "unofficial" tool that I built a while ago. Lots of folks have had success with it.

[Kayellen61]

Hello for some reason, I was not able to download the version for SAS EG 8.1.  The link did nothing.

[ChrisHemedinger]

Direct link: http://support.sas.com/documentation/onlinedoc/guide/blog/EGPSearcherTool.zip

But unfortunately there is not a version specifically for EG 8.1 -- we have versions for 7.x and 8.2/8.3.

[Kayellen61]

Thank you for your quick response.

[Kayellen61]

Is there another way for me to receive this tool?

[ChrisHemedinger]

I fixed the link in the blog. But as I said, it won't address the specific version of SAS Enterprise Guide 8.1, which has been updated for a long time to 8.2/8.3.

As an alternative you could use SAS Enterprise Guide automation -- via scripts -- to export and examine much of the content in EGP files.

[Quentin]

Hi,

This might not help, but I think needs like this are a great reason to store .sas code outside of .egp files (and link to them from EG process flows).  To my mind, EG became a much better tool for developers when it added that option.  Storing code outside of EG gives you the ability to execute it from other SAS sessions / environments, and also search code using any text search tools.

Too approach this problem, I might be tempted to script a process that would extract all the code from EG projects and dump it to .sas files as a first step.

[ChrisHemedinger]

Good advice @Quentin -- and to get you started I have several scripts on GitHub -- in PowerShell or VBScript.

[AlanC]

I have C# code to work with EG files and do similar processes.

Ping me offline Quentin if you need help. I am busy until after the holidays but can look at it after new years.

[Quentin]

Thanks Alan. I'm not the OP for this question, but appreciate the offer!

[AlanC]

I was responding to your mention of writing a script: I should have made that clear.

Ultimately, you need to open the egp XML, get the elements, find the one with SAS code, and extract it. i am pretty sure I have that already. the OP question regarding the datasets should also be discoverable in a similar manner.

[yabwon]

I would use SAS Packages for storing and sharing my SAS code (https://github.com/yabwon/SAS_PACKAGES).

Other thing, wouldn't a macro like one below solve the issue?

Bart

%macro getSASfilesFromEGP(
  path
 ,libOut
);
%local inZIP inF outF;
%let inZIP = z%sysfunc(datetime(),hex7.);
%let   inF = i%sysfunc(datetime(),hex7.);
%let  outF = o%sysfunc(datetime(),hex7.);
data _null_;
  rc0 = filename("&inZIP.", "&path.", "ZIP", "lrecl=1 recfm=n");
  did = dopen("&inZIP.");

  did = dopen("&inZIP.");
  if not did then
    do;
      put "ERROR- Aborting.";
      stop;
    end;

  do i=1 to dnum(did);
    file = dread(did, i);

    if upcase(scan(file,-1,".")) ne "SAS" then continue;

    rc1 = filename("&inF.", "&path.", "ZIP", "member='" !! strip(file) !! "' lrecl=1 recfm=n");

    rc2 = filename("&outF.", catx("/", dequote(symget("libOut")), translate(file,"_","/")), "DISK", "lrecl=1 recfm=n");
    rc3 = fcopy("&inF.", "&outF.");

    if ^fexist("&outF.") then put "WARNING: UnZIP failed.";
    put i= file=;
    put (rc:) (=);

    rcY = filename("&inF.");
    rcZ = filename("&outF.");
  end;

  did = dclose(did);
run;

%mend getSASfilesFromEGP;

%getSASfilesFromEGP(
  C:\Users\bart\Desktop\Project.egp
 ,C:\Users\bart\Desktop\TEST123
)