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'.
When viewing OLAP cubes in Web Report Studio, there comes a time when the user might want to view all the levels within the hierarchy, without the cumbersome process of selecting and expanding each individual item. In 9.2, there is a quick solution. When you right click on the level-heading
The %STPBegin and %STPEnd macros are pretty powerful pieces of code for SAS Stored Processes. They embed all sorts of information on devices, where content is located, and just make everything work. However for creating those fancy custom HTML forms or layouts, ods html is needed instead. I've written about
Using ActiveX in SAS graphics provides users with more functionality, options, and pretty colors than Jpeg, gif, etc (check out these examples). The issue is that ActiveX requires a device driver installed on the viewing machine, similar to Flash. In SAS 9.2, the sasgraph.exe is available within the SASWEB component deployed
So, you have created a report with a Filter. That filter is pretty evident somewhere in the report anyway (or you just want the USER to have no knowledge of what is not there) so why not remove the filter list at the top of the report? Pretty easy option,
CASE statements are a powerful mechanism in SQL code to analysis, recode, etc data. In Information Map Studio, you can utilize this CASE statement via the Expression Editor Window. Create a new data item and click edit in the 'Expression Settings' area. From the Categories - CASE operator folder, there
So you've got a nightly process that updates a file somewhere. Unfortunetly, something still has it locked and the update fails, the nightly process crashes & burns, and someone at 8am upon arriving decides to blast you for not having updated data ready for them to analyze. Sound familar? There
I must recommend that you check out this example from pg 70 of the SAS Stored Process Developers Guide. http://support.sas.com/documentation/cdl/en/stpug/61271/PDF/default/stpug.pdf This is a pretty sweet example of how to upload a file from your machine (via Internet Explorer) into the SAS System. A custom form can be created in html
The following option can be added to the Metadata Server to default users to a specific DOMAIN. This removes the requirement of using domainusername or username@domain formats for the username field. -authproviderdomain (HOSTUSER:DOMAINNAME) I made this modification within the file: ..Lev1\SASMeta\MetadataServersasv9_usermods.cfg In SAS Management Console, you must still
Included are some references for using the Libname XML Engine. This can be handy for writing and reading xml. SAS Documentation on the XML Libname for 9.2: http://support.sas.com/documentation/cdl/en/engxml/61740/HTML/default/a002594363.htm An example of exporting a SAS dataset using a custom tagset is located at: http://support.sas.com/documentation/cdl/en/engxml/61740/HTML/default/a002975327.htm The SAS User Group paper http://www2.sas.com/proceedings/sugi29/119-29.pdf also provides
You can export the .sas code from a specific task or the entire project into a .sas file! It's great when publishing a project into a repeatable batch/schedule process. However, be aware of default names for the .sas resulting file. I recently ran across an error when exporting a task
