Coding Tips

Coding & Data
Visual Analytics

Dealing with Missing Dates in SAS Visual Analytics

It’s nearing the new year and you may have already started preparing reports that have the organization’s goals and the progress toward those goals. However your chart may not be displaying correctly. If your data is not setup properly then you’ll notice that you only have one or two months when you want to see […]

Read More
Coding & Data

How Do You Flowchart a SAS Program?

I’m a visual person – I always need a picture. As a consultant, many times I’m given a thumb drive full of code and asked to make modifications.  When you are on a project with me, you’ll grow weary of hearing me say “Can you draw it?” Something magical happens for me when I see a flow […]

Read More
sas va labels on map
BI Tools
Coding & Data
Data Visualization
Visual Analytics

Creating Better Data for Visual Analytics Users

One factor for self-service BI is ensuring that the data is easily understood by the end user. The idea of self service BI is that users with less training can build charts and reports to help them answer their questions. This does put some onus on the data creator to make sure that the data […]

Read More
sas dynamic prompts
BI Tools
Stored Processes

Which population method should I use for my SAS prompt?

During our Debugging and Tuning SAS Stored Processes session, an attendee asked “Why would I choose a dynamic versus static prompt for my stored process?” It was a good question because the choice might make a difference in the stored process speed. Here’s some guidelines. What are the different Population Methods? Stored Processes take user […]

Read More
Coding & Data
Stored Processes

Building a SAS Stored Process Log

As a SAS stored process developer, a question sometimes pokes its way into my head: “Are people using the stored processes I write?”  In fact, really I have four questions: What stored processes are being used?  Who is using them? When are they being used? How are they using them? I realized what I’ve been missing. […]

Read More