There is a tool for changing server references. Aside from that, I think that this must be done proactively, like creating a temporary data set in step 1 and then use that throughout the project, so you only need to change step 1. Or use a macro variable. ... View more

You can use EG point and click for this, the trick is know what query you need. So perhaps first sketch the SQL query and then build it after? It will go something like the following (untested) proc sql; create table want as select a.date, a.y1, b.y2 from table1 as a join table2 as b on b.date>a.date group by a.date having b.date=min(b.date); quit; ... View more

Hi:   This sounds like the type of functionality that you have with the SAS Add-in for Microsoft Office. When you use the SAS Add-in, you can choose to automatically refresh the content or you can schedule for the content to be refreshed/updated. For example, see page 8 in this documentation http://support.sas.com/documentation/cdl/en/amogs/66249/PDF/default/amogs.pdf to see where the checkbox is if you have the SAS Add-in for Microsoft Office. cynthia ... View more

For just one or two people cooperating sitting aside do not make too much troubles, - you can define filenames libnames all of them in code that is started in a EGP flow named "autoexec" - you can have this definitions (code) moved into an autoexec-usermods approach of your appserver by your platform admin. For bigger projects (many developers). Versioning of en EGP project file is impossible is it will get locked by one the first updater. Others leaving to have just read access. In the basics an EGP file is a zipped containing all sources relations links etc. An IDE integrated Development Environment is not something suited for versioning. See: Using source control management with SAS Enterprise Guide - The SAS Dummy What you can do is: - use DI for building the programs. This tool is designed for ETL and an developpers   It supports check-in checkout at the development stage with also some support for SVN. - You are still needing an approach for release management. Versioning and releases are not the same however often being confused.   The question: What is you Test Accepance and Production environment approach? - You can develop Stored processes with Eguide and put those in release-management - You can edit code with Eguide and use the (relative) links, not storing the code into a EGP project.   The relative links setting only works with Windows based approached not with Unix (Linux). - Many links in the EGP project can get personalized not able to run by others, try to avoid that. - scheduling/workflows should be solved by schedule tools (LSF) not being kept focussed as a EGP flown    ... View more

Hi Chris, Thanks for your answer! 🙂 The next problem is: I build an original SAS EG project. The flow is already constructed but problem (explained above) appears. By using the "upload data set task box", this box seems to create a dubble output data sets for every boxes following the upload task. What is strange is that the two duplicates always refer to the same SAS data set (same name, same library, same server). So, the flow works but visually, it's totally awful: imagine that you find every SAS data sets twice in your EG project... Thanks for your help everyone, Arnaud ... View more

Hi Chris, Thanks for your answer. I have SAS/STAT installed because proc GAM works if I used it in a regular "SAS 9.3" environment. The thing is that I have some problem to access, with SAS enterprise guide, the server with SAS toolboxes. But finally, it turns out that's all about "problem with the IT department (access denied with the server hosting the toolboxes ...)". I'm waiting for the passwords to access it and come back if new problems appear. Thanks again for your fast answer! This forum is really efficient when questions about SAS appear. Arnaud ... View more

In the Details section of the PROC GAM documentation, there is a section called Dispersion Parameter.  It mentions the scaled deviance as the estimator of the dispersion (scale) parameter.  What I do not know is whether the output "Deviance of the Final Estimate" is scaled or not, and for the life of me, I can't find it in the documentation or the examples. Steve Denham ... View more

Since the last line is a call to the macro then you should see notes and messages as it tries to run it.  If you are not then you probably have unbalanced quotes, parenthesis or other things that is causing to not see the macro call.  Sometimes it is easiest to just save your program, close SAS and start over to clear up that type of issue. ... View more