topic Re: Size of SAS egp project in SAS Enterprise Guide

Size of SAS egp project

SASdevAnneMarie — Fri, 28 Aug 2020 08:07:00 GMT

Hello Experts,

I have a question. I don't understand why my SAS egp project became very huge (10 365 Ko):

I use the proc datasets to delete all the table in library work, so I yhave no table.

Thank you very much!

Re: Size of SAS egp project

Kurt_Bremser — Fri, 28 Aug 2020 08:35:54 GMT

Check your results and logs.

Re: Size of SAS egp project

ChrisHemedinger — Fri, 28 Aug 2020 11:42:02 GMT

EG projects do not store your data, but they do keep your ODS results and log output. If you have Project Log enabled, you might want to clear it (see Project Properties, Project Log -- check online help for details).

Re: Size of SAS egp project

SASdevAnneMarie — Fri, 28 Aug 2020 11:52:18 GMT

Thank you for your answer!
I have no data in project and I put the "options nosource";
I still have the same size of project. 😞

Re: Size of SAS egp project

Kurt_Bremser — Fri, 28 Aug 2020 12:26:50 GMT

@SASdevAnneMarie wrote:
Thank you for your answer!
I have no data in project and I put the "options nosource";
I still have the same size of project. 😞

Please re-read my post with proper diligence. I explicitly did not talk about data, but results and logs. Check all those with your own eyes.

Re: Size of SAS egp project

SASdevAnneMarie — Fri, 28 Aug 2020 12:33:05 GMT

Thank you, I see.
I have no results because I used "ODS NORESULTS;"

I can't understand why the log is not deleted with "options nosource";

Thank you!

Re: Size of SAS egp project

Kurt_Bremser — Fri, 28 Aug 2020 12:44:04 GMT

The SOURCE option controls if the original code statements are sent to the log or not. NOTEs, WARNINGs and ERRORs are still sent to the log. If you repeat 10 steps for 5000 times in a macro, you'll have all those from 50.000 steps in the log.

If you have lots of data errors in your data, and a large value in the ERRORS option, this will also cause a large number of log messages.

Re: Size of SAS egp project

Quentin — Fri, 28 Aug 2020 12:45:49 GMT

I think .egp files are still zipped xml. So if you're really curious what's driving the file size, you could make a copy of the egp file, unzip it to a folder, and poke around a bit to see which files are the largest and what's in them. You don't say much about what's in the egp file, so it's hard to guess.

Re: Size of SAS egp project

SASdevAnneMarie — Fri, 28 Aug 2020 12:48:44 GMT

Thank you Kurt,

There is some option for not generating the log?
Thank you!

Re: Size of SAS egp project

Quentin — Fri, 28 Aug 2020 13:02:45 GMT

No log is a scary thing, but you can do it with:

proc printto log="NUL:";
run;

Re: Size of SAS egp project

SASdevAnneMarie — Fri, 28 Aug 2020 13:30:04 GMT

Thank you!
That works, my project is not huge any more!

Best regards,
Marie

Re: Size of SAS egp project

Kurt_Bremser — Fri, 28 Aug 2020 13:48:31 GMT

Instead of suppressing the log as a whole, you should look for the reason why it grows so big, and correct that. Very often, overly large logs point to problems (extraneous NOTEs, data ERROR's, ...) or to inefficient code (10000 data steps repeated in a macro loop instead of a single data step with by group processing).

So you should review your whole process very carefully, and pay attention to details. Garbage code stays garbage code, even if you refuse to look.