Within SAS 9.2 you can now create shared prompts to use across information maps and stored processes. To get to the Shared Prompt capability from SAS Management Console: Move to Folders Tab Create Stored Process enter 'dummy' data for STP screens until you arrive at the Parameter Entry Screen. On
Author
After getting multiple requests by customers to perform this change and positive vibes from others on the prior blog post: http://sas-bi.blogspot.com/2009/02/sas-enterprise-guide-server-file-access.html I decided to bring the instructions to life in a ZencosTV Youtube Video. The video includes screens from Management Consoles for both 9.1.3 and 9.2 implementations.
Included are a few of my favorite things about the new Web Report Studio 4.2 (for SAS 9.2 EBI Installations). CALENDAR for prompts/filters! Drag and Drop Variables in Report Widget Dynamic dropdown lists (one effects the other) Right Click Option Lists on Report Widgets Filters/Prompts on OLAP Mulit-Dim Sources Reference:
You might notice that after completing a SAS installation with all prompted locations pointing to a 'non-standard' drive such as D or E, that there are still some files installed at the c:program filessas location. These are related to the JRE. There are currently no prompts for where this should
(SAS 9.2 Implementations) When saving SAS Stored Processes, the 'sassrv' internal user account is used to write the physical .sas files on the server. Security of these files (to reduce the users from overwritting other's .sas stored processes) can be accomplished via the Resource Management plug-in for SAS Management Console.
(Information Below for 9.1.3 Environments) To modify the Web Report component used from SAS Portal, modify the PortalContent.xml located in the Installation Folder (such as c:Program FilesSASWebPortal2.0.1PortalWEB-INFcontent in windows) and then redeploy the Portal. (You can directly modify the same file in the Tomcat/webapps location, however modifying the installation folder
Is the SAS Web Applications timeout of 30 minutes still too short? You can modify these by following editing the .xml files listed on page 15 of SAS Web Application Administration Guide. Here are the steps I took to update the Portal, SAS Web Report Studio and the SAS Stored
Included are some highlights that I have seen and already reaped the benefits of. Take a look, I'm sure there is a one item that you will also enjoy! Logging Levels Within the Management Console, for several of the Servers you can connect and view the logs immediately - without
New and Long Standing SAS Customers alike ask for advice on where to find information to troubleshoot and learn about SAS. Included below is a running list of URLs that SAS Users can find useful for finding information! SAS Community http://www.sascommunity.org SAS Conferences Paper Search http://www.lexjansen.com/ SAS Support
BI/EBI SAS deployed Web Applications actually are .ear files residing in the deploy_sas folder of jBoss. This could create a delay in reboot time if memory on the server is limited. Included are the steps to deploy these .ear files into full folders that dramatically improve the restart time of
I have submitted a SAS User Group paper for the Seattle Conference in 2010 but thought I'd go ahead and provide a couple of quick notes for those of you going ahead with it now :) If default authorization, small number of users & databases, no BI content (WRS, InfoMaps,
SAS stated that the Information Map Portal hasn't changed much since 9.1.3, but there are a couple of really well placed modifications. Included are my notes on the benefits of moving to Portal 4.2: No xythos - using SAS Content Server now Sticky Pages renamed to Persistent Additional Reference: What's
New jBoss installs might store excessive logging due to a malformed comment in log4j.properties that threw JBoss into a debug state on startup. There was a comment tag in the jboss-log4j.xml file something like !-- -------------Add new line here à All of the additional hyphens were causing the SASServer1 to
After completing several SAS 9.2 BI and EBI installations, I must profess my love for the improvements: greener! - cds shipped by customer request only, default is Electronic Download faster! less manual steps fewer system user accounts many more sample plans available for more 'standard' installs significant reduction in post-install
SAS Enterprise Guide uses HTML as the output default format. So for converted projects in SAS EG 4.2, there is a possible situation where the reports fail to view. Change the default back to HTML (or deploy SAS EG 4.2 with that format option selected). The option in 4.2 is
You can utilize IIS on your standard web server to connect to the jBoss SAS Installation. There are three steps that must be followed to the T: 1. On IIS Machine A. Create a file location for the dll and properties files. (This location via be referenced via a virtual
Twitter is an EXCELLENT resource to get SAS friends' feedback on issues. Take for instance the tweet yesterday from @CaroleJesse concerning EG 4.1 issues after installing 9.2 on the Server. @hollandnumerics responded that a command line step could be run to register the 9.2 system. See the dialog below and
My prerogative has always been to share my knowledge with the entire SAS user community (hence this blog & all my SAS papers). For an approach to supporting the entire SAS Server Architecture, I presented a paper at the SGF 2009 conference and created a Wiki page in SASCommunity.org to
There is actually many more PROMPT types available in SAS 9.2 than the prior version. Including ranges for date, time, text, and numeric! The 'Date Range' type specifically replaces the workarounds necessary in a prior version. (See these workarounds in post: Creating a Date Range Prompt in Web Report Studio
Getting a date prompt that filters on a range of dates requires an Information Map with a date variable that exists twice on the Information Map, two different prompts, and application of both within a Web Report Studio Report. Included are steps to get this to work. Within Information Map
Instead of writing proc metalib statements, SAS has a custom task that you can download into Enterprise Guide. This interface provides non-SAS coders a quick mechanism to register new tables created on the server to the Metadata Library. http://support.sas.com/demosdownloads/setupcat.jsp?cat=SAS%20Enterprise%20Guide
The initial installation of a SAS Metadata Server allows for all undefined (in SAS User Manager) users to have access. It is recommended (after testing the entire install & before deploying to the business) that the security defined in the ‘Users & Permissions’ tab of the Default ACT is modified
If you are assigning special authorization for one SAS Object (Library, Folder, Server) to a specific User Group in SAS Management Console, using the Authorization Tab on that Object makes sense. However, if you have multiple SAS Objects to assign this special authorization to, it makes more sense to create
Just wanted to let everyone know of this new (but still experimental) functionality in SAS Management Console: An experimental SAS Management Console plug-in is available in 9.1.3 called BI Lineage. The following Sample document provides an overview of the tool, with screenshots on it's use: http://support.sas.com/kb/33/574.html This SAS Note provides
When accessing an external data source from Oracle, Teradata, SQL, etc with SAS it is widely accepted that the SAS program should use the SQL Pass-Thru functionality rather than a libname reference. However when linking to a defined external data source in the SAS Metadata from SAS Information Maps, the
If you don't have SAS Management Console, you can still view the BIP Tree from SAS Enterprise Guide. This is particularly useful for (cough -- all) organizations that need to reduce their exposure of incorrect Metadata changes. In SAS Enterprise Guide, Select 'View' -> 'SAS Folders'. Then users can create
A fun article for April Fools Day. Reference:http://www.sascommunity.org/wiki/Special:ListSubBlogs/User:Richard.thesasguy 1. SAS is not like Oracle, your email system, or anything else for that matter. When viewed as a system, SAS software does not behave like a database, or any other operational system. Usually, very little goes on without the direct involvement
Well, the countdown to the SGF09 event began (at least according to an email I saw this morning). For those attending; the educational, networking and entertainment opportunities abound. But for those of you who are unable to attend, I found an interesting article from a fellow twitterer that you might
It's obvious that you have missed the submission deadline to get your own paper into the SGF2009 Washington DC Conference, so that can not be the reason to attend. So what steps can you take to convince your boss that paying for the conference is a good benefit for them
Posted on https://blogs.sas.com/content/sascom: Our friends at Zencos also offered a few predictions and recommendations, including: Increasing efficiencies: Companies will be reallocating resources effectively to succeed (or at least stay in business). Focused industries: Follow the new administration’s priorities to see which industries will bounce back first – government infrastructure, healthcare