If you deploy the SAS 9 environment on Windows, you may have multiple SAS processes running on a single box (metadata process, OLAP server, multiple workspace servers). Windows Task Manager doesn't provide a great way to distinguish one sas.exe process from another, but Process Explorer does. Process Explorer lets you
For the third year running, SAS spellers have prevailed at the Corporate Spelling Bee, held for the benefit of the Literacy Council of Wake County. In addition to showing their spelling skills, team members are encouraged to wear costumes to convey their team spirit. I've never seen a SAS for
My new favorite typeface for programming is Consolas, a font designed for use with Microsoft Visual Studio 2005. I use it there, but I now also use it for SAS programming. It uses ClearType technology, so the "crisp and clean" benefits kick in only when you have ClearType smoothing enabled.
A colleague asked me to run a certain SAS program and then try to view the output in SAS Enterprise Guide. The output contained an SQL VIEW, and darn it, the application refused to open it, reporting only that the data "could not be opened." There was nothing wrong with
A new book brings into pop culture a concept that we've already known for years: that is, governments and corporations use data mining and analysis to influence our lives in major and minor ways. While Super Crunchers author Ian Ayres might not mention SAS by name (actually, I don't know
My new license plate arrived the other day, embossed with my personalized tag of "SASDUMMY". I used the North Carolina Department of Motor Vehicles web site to help select the plate and verify that this tag was available. Apparently there aren't many self-deprecating SAS programmers roaming around I-40. If you
It was about eight months ago that I wrote the first draft of "Setting It All Up", Chapter 15 of SAS for Dummies. There is some pressure to be clever when organizing these chapters for a Dummies book, and to be creative when crafting section headings and figure captions. Our
This January 2007 report from eWeek states that specialized skill shortages will swell IT salaries. According to that article, "demand in the software development area will include Business Objects, Java, [Microsoft] developers, SAS programmers and systems architects." (Bold added by me.) I guess their crystal ball is pretty good, because
There is no good way to migrate MDDBs to V9Cubes. Here is an excerpt from the SAS migration website (http://support.sas.com/rnd/migration/planning/files/mddb.html): “There is no automated method to convert Version 8 MDDB code to SAS 9.1 OLAP code. PROC MDDB executes in SAS 9.1. However, it creates a Version 8 MDDB that
SAS BI-ogsource is now 2 years old! Hope everyone has enjoyed the content over the years. Please feel free to contact me with feedback, suggestions, or even ideas for new posts! BI Weblog Email Address
Let's say you use SAS Report format, the latest tagset supported by ODS. After all, it's the lingua franca of SAS BI applications, since it's also used by SAS Web Report Studio, SAS Add-In for Microsoft Office, and SAS Enterprise Guide. You've discovered how to use the report builder in
Overall, query response time dramatically decreases with the use of sets, therefore it is preferred that user selections (or the cube itself) prevents the potential of choosing multiple members within the same dimension. Queries that only included 1 member in the slicer but are still represented as a set are
In the SAS BI-ogsource, Angela posts some sample SAS code for updating library definitions using the METALIB procedure. SAS Enterprise Guide users can make use of a friendlier interface to do the same job. Now available for download, the Update Library Metadata task plugs right into SAS Enterprise Guide and
The SAS OnDemand for Academics offering has brought to light some tremendous resources for learning SAS, and you don't have to be a professor or student to take advantage of them. One such resource is the SAS Online Resources for Statistics Education. If you've wondered how to start using SAS
When Alison Bolen asked if I would consider hosting my own blog, as a "spin-off" from her informative sascom voices blog, I didn't hesitate. Spin-offs have a rich heritage in our media culture, and I am superpleased to be a Mork and Mindy to her Happy Days. (I would rather
In order to promote WRS reports through Dev-Test-Prod, the BI Manager provides a good export/import wizard. However the SAME information map is being called for this one WRS report. What if the information map is also being moved through Dev-Test-Prod? Take the .srx export file created for the WRS export,
Once you have mistakenly loaded IE 7 and can no longer use the SAS web applications, you'll find that reverting back to IE 6 will take an act of congress. (Really, and you know how slow they are.) Use Firefox and install their IE tab. You can download it from
Once you move to production, you really dont need all of that STP code in the system right? Here are two quick statements you can use to reduce the amount of logging done. options obs=max nosyntaxcheck; %let SYSCC=0; April 2008 UPDATE: Received a question concerning what is impacted by this
Hotfix 4 was made available in June. Don't forget to load it up. http://ftp.sas.com/techsup/download/hotfix/ent_guide41.html#41eg04 The big one that caused problems for me was: "ALERT - SAS® Enterprise Guide® might delete metadata Login objects, causing other SAS applications to fail "
By the way if you want to decode a {sas001} encoded password just remove the prefix and feed it into this page: http://www.opinionatedgeek.com/dotnet/tools/Base64Decode/Default.aspx
Did you know that from Windows Explorer, the specific WebDav Folder can be opened.Just navigate to 'My Network Places' and use the Add Network Place Wizard.
I have emailed this simple code up & down the east coast. My memory isnt as good as it use to be, so I also have a copy nearby to implement when onsite. This updates the metadata within the specified library (and delete tables/info if it no longer exists in
Can there be ‘Or’ Boolean logic on filters within Information Map studio. The answer is yes. See the screenshot below on how to apply the ‘Or’.
Might not work as expected? http://support.sas.com/documentation/configuration/thirdpartysupport/v913sp4/thirdparty913sp4.html#browsers Firefox is supported on some Operating Systems, but not Windows (only IE). For the most part Firefox should work, and we really don’t have another choice since reverting IE back versions I hear is very cumbersome. Here is a link to Firefox 1.5 .
Cross tabulations in SAS Web Report Studio don't work with just category/qualitative data. A measure is required. So how to count the number of records that exist in the group? Using the SASHELP.SHOES data table, we would like to count the number of subsidaries that exist within a region, or
When creating a filter on a numeric value in Information Map Studio, the query doesn't include the filter when used in Web Report Studio. The classification of the variable must be changed from "Measure" to "Category". (Measure is automatically used for incoming numeric values.) For instance, SASHELP.SHOES has a 'Number
Adding a bookmark or data exploration to the Information Map Viewer Portlet in SAS Information Delivery Portal will only display the number of records in your preferences within the data exploration itself. Be careful of novice users not realizing this and just taking the initial screen at face value (har
In SAS Business Intelligence packages (where Information Delivery Portal is not licensed), Xythos is not absolutely necessary. Apache can be setup as a webdav folder for SAS Web Report Studio use in storing shared and personal report metadata. This is a much simpler installation process and you loose no functionality
Two options to editing the Portal Welcome Portlet: 1. Take the welcome portlet par and change the text 2. Pg 35 of: http://support.sas.com/rnd/itech/updates/91/portal_dev.pdf Never tried this myself though … I usually just log in as sasguest and edit the entire Public Kiosk page. (Removing the Welcome Portlet and adding a
So you installed SAS v9 BI successfully, but when you download the SAS Management Console on a client site, some of the selections are missing from the menu bar on the left. (For instance, the BI Manager plug-in, a very handy way to manage your BI content.) Never fear, you
