On the Select Data tab, choose Vendor# and Invoice# and Last_updated.  In the Last_updated row, select MAX from the Summary column.  EG will automatically do summarization of the latest date by Vendor# and Invoice#. ... View more

15.  Ability to use shared prompts in our EG projects. ... View more

RobbieFreddie made a good point to use the tail -f command to watch the log as your web application server starts.  You will be amazed at how much is going on in the background.  Your first step should be to run this process to see what is going on and to identify any warnings or errors that could impact restart time. We run our web tier on jboss and a Solaris server, and the total "restart" time can take almost an hour.  Just starting the SAS Remote Services, Deployment Tester, etc only takes a minute.  The majority of the time is taken up by the web application server deploying the web applications, such as Web Report Studio, Information Delivery Portal, BI Dashboard, etc.  I would expect that the length of time to "restart" is primarily dependent upon the server speed (and other characteristics) and the number of web applications that you deploy.  Other configuration issues can also impact restart time, such as trying to "discover" services on other servers. ... View more

The majority of our installations are deployed through the LAN. We subset our software depot (http://support.sas.com/kb/39/110.html) to include only EG and AMO and created a response file for quiet installation (http://support.sas.com/kb/37/041.html) . Our IT folks then created a little script to run the setup routine from the depot (not necessary, but they like the control). The users are given admin rights to perform the installation, but those rights are removed after installation and logout. ... View more

Thanks Chris. Many of the projects are composed primarily of EG tasks. I think the best solution will be to get all of the users upgraded to 4.3 (over 100 users). About the time I get that accomplished, EG 5.1 will be out... ... View more

Under the filter tab of the query builder, you must associate your prompt(s) to column(s) within your dataset. Here is an example of a basic filter with a single prompt: Go to the filter tab, click the new filter icon 1. choose a basic filter, click next 2. select a column to filter on, click next 3a. select an operator (e.g. equal to, in a list, etc.) 3b.click the down arrow next to the Value text box, click the Prompts tab, select your prompt, click next 4. click finish Run the query builder, and the prompt should present itself. ... View more

You can use the new custom task "Export Data to Microsoft Excel 2007/2010". Details are at http://blogs.sas.com/sasdummy/index.php?/archives/205-Export-to-Excel-20072010-using-SAS-Enterprise-Guide.html. ... View more

Creating a new default theme for the web tier is more complex than changing a style sheet. See "Administering SAS Web Application Themes" in the SAS® 9.2 Intelligence Platform Web Application Administration Guide (http://support.sas.com/documentation/cdl/en/biwaag/63149/PDF/default/biwaag.pdf) for the details. ... View more