Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.
Did you know that there is a wealth of SAS Training Material for free? I have this bookmarked for reference material and continued education. Free Tutorials: UPDATED URL (2009Aug03) http://support.sas.com/training/elearn/tutorials/ SAS Papers Online: http://support.sas.com/rnd/papers/ Users Group Proceedings: http://support.sas.com/events/sasglobalforum/previous/online.html
A consistent theme has occurred over the past couple months, navigating the SAS Documentation is a must-learn skill. Easily access the functions, proc statements, special (component specific) topics is essential! Included below is the overview documentation on the SAS Intelligence Platform: The SAS V9 Documentation includes information about the SAS
Well, we love our crackberries so much that now we can get our SAS graphs pushed out to the small screen. http://support.sas.com/kb/26/171.html
I have used this with much success with clients' Windows servers. It makes searching on .sas batch programs, determining which sas.exe is for what BI server, etc. Use the 'Find' function and simply type in the .sas file or BI service component you are looking for. This also provides more
For Web Report Studio reports to have drill through to detail, the associated Information Map must have drill-through to detail option selected.
In order to have the BI Manager Plug in available on a client machine, don't forget that Foundation Services and Query & Report Services are required in plan file.
If a SAS data view needs to be added to the SAS Metadata, utilize the Import Tables wizard in the SAS Management Console (SMC). "If you use PROC METALIB to import metadata for a SAS® view, the procedure incorrectly assigns a value of DATA to the MemberType attribute. The value
"I have been doing a lot of performance testing recently with the Teradata access engine vs the ODBC access engine on the same Teradata instance, and from the same server the ODBC access engine on Sybase IQ. Setup: This is all done from a SAS 9.1.3 SP4 installation, with the
I wanted to share a trick/technique with you all regarding making it easier to migrate EG projects from one environment to another. The issue is that there are often occasions where it is necessary to code file paths in an EG project (just like in any other SAS program) and
When trying to generate rollup measures for further statitical analysis from an OLAP cube, completing in MDX proved much more efficient then querying and running PROC MEANS steps. Included is an example of how to utilize the DRILLUPMEMBER() function in MDX code: http://www.databasejournal.com/features/mssql/article.php/10894_3572621_2
