Tag: SAS BI Content Exam

SAS Stored Processes: 3 Tips to Improve Your Prompts

SAS stored processes are similar to SAS programs in that they use the same programming language.  Many of my SAS programs I created early on were only used by me, so I could live with  a little uncertainty and it was easy enough to check the logs for any issues.  If anything went wrong then I knew what I had to change. Stored processes required a whole new level of thinking – my first few stored processes back in the SAS 9.1.3 days were – well they left a lot to be desired.  When I would roll out a new stored process I would often get a call from a user who had done something crazy and the stored process wouldn’t work.  For instance, why would anyone put a state name in a customer name field to see if it would return all the customers from that state?  Only one thing could happen – no report!   Here’s some usability tricks that I have learned with my SAS Stored Processes to make them more robust and harder to break.  Really the out-of-the box prompts provide a lot of functionality that really helps. That’s right – let’s build a better mousetrap! Tip #1: […]

A Place of Your Own … from the SAS BI Administrator

When the SAS BI Administrator adds a new user to the SAS BI system, a personal folder called “My Folder” is created for the user.  Each user can create sub folders and store BI content (such as reports, stored processes, and so on).   Use…

Create, Access, and View Data – All the tools you need!

SAS EBI is comprised of several applications.  Here is a quick overview: Make Data SAS OLAP Cube Studio Build OLAP cube using SAS datasets. SAS Information Map Studio Build information maps from SAS datasets and OLAP cubes. SAS Enterprise Guide Connect to SAS datasets, RDBMS, and even Excel spreadsheets SAS Add-In for Microsoft Office Possible to create data in MS Excel that you can save to the server and then use in other BI Tools.  This would be an option for smaller datasets that are updated infrequently and not centrally stored, for instance, an department organization structure. Use Data Web Report Studio Create reports from OLAP Cubes, Info Maps, or SAS datasets. SAS Enterprise Guide Create reports and more from OLAP Cubes, Info Maps, or SAS datasets. Also create reports that can be shared as a stored process for the other SAS SAS Add-In for Microsoft Office In MS Excel – Create reports from OLAP Cubes, information maps, or SAS datasets.  Mix SAS data with the data from Excel spreadsheets. In MS Office/PowerPoint – create reports from cubes, information maps, or datasets.  Not as much flexibility as with MS Excel, but you can easily create report that you can share […]