BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » Archive by Tags

Articles tagged with: Coding Tips

Stored Process Outputs Data without a Report

2011-11-07 – 7:31 AM
running from sas web application server

You can do more with SAS Stored Processes than just create reports.  These little suckers are packed full of power and the only limit is your imagination (and libraries where you  have write access!)  In this post, you will learn how to use a stored process to move a dataset to another library and not output a report at all.  
 Creating the Stored Process
The stored process …

Info Map: Use SAS Functions to get dates – oh yeah

2011-10-18 – 2:20 AM
IMAP_005_date_4

In Information Map Studio, you can use the Expression Editor and some SAS functions to create new data items from existing data items.  Here’s how to create some common Date data items.  SAS functions make it easy to perform actions and all you need is a variable and sometimes a parameter or two.  [Last week I talked about using functions to create a new data item.]
The following …

What *is* a code review?

2011-10-11 – 3:46 AM
bad_code_review

Our team planned to use a new set of data tables to increase our customer knowledge and overall improve our processes. Due to our workloads, our team lead had a person (Dev X) from another team write some code to access the tables and create some usable datasets for our process. After the code was written, Dev X was asked to arrange a meeting …

SAS MS Add-In: Why are there two variables with almost the same name?

2011-10-03 – 6:00 AM
461_amo_var name similar

Recently while setting up a report in SAS Add-In for Microsoft Excel, I was going to create a graph using an information map. When trying to assign the chart values, I realized I had several very confusing  variable names.  When the information map was created, I know I had everything neat looking due to my own OCD about variable names.
As shown in the following figure, …

Building Business Intelligence Using SAS Book

2011-09-01 – 10:24 AM
SAS BI Book Reviewer Comments

Building Business Intelligence Using SAS Book
SAS Business Intelligence (BI) package provides an interface for multiple audiences to dissect, discover, and decide on what the data means to their organization. This book shows you the SAS business intelligence capabilities, features, and contains the most sought after tips and tricks to bring a novice user up to speed quickly!
 
SAS BI Book Overview
Each chapter highlights a specific SAS business …