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: […]
Tag: SAS BI Content Exam
Peek Inside SAS BI Book: Building Business Intelligence with SAS
You may be aware by now, our new SAS BI book Building Business Intelligence with SAS:Content Development Examples launched last week on the SAS Press site. That’s right, SAS Press or Amazon will be delighted to bring a copy of this SAS BI book to your door. When Angela and I set out to write this book, one of the first things we discussed was how new users get access to the SAS BI toolset and have no idea of its astonishing capabilities. This book guides you through each one so you understand it. Intermediate and advanced users will also find this book as a valuable reference. Several times, Angela & I have both found ourselves pulling out the draft copy to reference an advanced technique. This book fulfills a unique spot in the marketplace; there is no other single book that leads you through each SAS BI component with step-by-step examples along with hundreds of tips and techniques to make you successful! SAS Institute offers over nine SAS BI courses to cover all the topics we have jammed packed into this book. Making this an excellent study guide for those planning to take the SAS BI Content Development Exam. Your SAS […]
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 […]