headline »

SAS Coding: Use Flowcharts to Learn Inherited SAS Code

March 2, 2015 – 8:00 am | 2 Comments

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 or see an idea.
One of the most confusing projects I …

Read the full story »
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

User Conferences »

Wanted! SAS Rustlers Unite at #SASGF15 #TweetUp

February 22, 2015 – 12:23 pm | One Comment

In April 2015, SAS users travel across the world to the SAS Global Forum in Dallas, Texas – yes the legendary Wild West.  If you are arriving early at the conference (maybe for a workshop or to take a certification exam) – then you’re invited to a special and exclusive event.

#sasgf15 #tweetup

#SASGF15 Tweeps Unite!

This is an informal, pre-conference gathering for tweeps on Saturday 25th April at 8 PM at the conference hotel. Yes, a #SASGF15 #TweetUp  for people to meet their followers face-to-face and chat in more than 140 characters. If this is a little overwhelming you are allowed to watch and tweet away in a corner.

To entice you to come along, there will be some random drawings, SAS giveaways and an evening to exchange conference agendas and must see/do events.

No Twitter Account Required!

What: #SASGF15 #TweetUpYou don’t need a Twitter account to join us – but you know they are free – right?

[Here’s a quick Twitter tutorial!]

When: 8 PM, Saturday April 25 , 2013
Where: Lobby Lounge bar in the Omni Dallas Hotel

555 South Lamar, Dallas, Texas  [(214) 744-6664]

What to wear: Casual — Extra raffle ticket if you wear a t-shirt from the last conference you attended or a shirt from where you are from.  Why don’t you get really daring and wear a cowboy shirt!?!
What to Eat: Beverages of all sorts are available at the bar (at your expense)

It’s a good time to try good ole CocaCola or maybe a beer.

Who’s Hosting: Zencos – Tricia Aanderud (@taanderud)

Metacoda – Michelle Homes (@HomesatMetacoda)

 

 

Last Year’s TweetUp

#sasgf14 #tweetup location

Beautiful Location to have a part

IMG_5774

#sasgf14 #tweetup

Michelle was excited that it was past midnight – US Time!

#sasgf14 #tweetup

Our Selfie

Trying to get Phil Holland to guess what part of the SAS language he was!

IMG_5772

#sasgf14 #tweetup

Aussies … representing!

 IMG_5841

Attending?

Leave a comment or tweet one of us if you plan to attend.

Which population method should I use for my SAS prompt?

April 13, 2014 – 9:31 am | Comments Off
sas dynamic prompts

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 input through a prompt to provide custom output.  Consider the following three …

SAS Office Analytics: Working with Your Inner SAS Programmer

March 12, 2014 – 8:00 am | Comments Off

When working with new or even casual SAS BI users, the SAS Office Analytics really bridges the gap between “I’m not a SAS programmer” and “I have 1000’s of ideas for data visualizations”. Users need an easy way to access the data warehouse and create reports or answer simple questions. The SAS Office Analytics package (aka SAS Add-In for Microsoft Office) a natural choice since …

#SASGF14: You’re Invited to a TweetUp!

February 10, 2014 – 6:50 pm | 2 Comments
2014 sas global forum tweetup

Hello, G’Day, Hola, Hej, Bonjour, Hallo! In March 2014, SAS users travel across the world to the SAS Global Forum in Washington, DC.  If you are arriving early at the conference – then you’re invited to a special and exclusive event.

Tweeps Unite!
This is an informal, pre-conference gathering for tweeps on Saturday 22th March at 8 PM at the conference hotel. Yes, a #SASGF14 #TweetUp  for people to meet their followers face-to-face …

Little Known Secrets from SAS Stored Process Magicians

January 26, 2014 – 4:57 pm | Comments Off
0262r library of congress laurent magician

When writing stored processes – it can be tricky designing the perfect prompts especially when working with tricky users. Maybe you feel more like a magician than a SAS developer. Recently I needed a SAS stored process that allowed a user to find a needle in a very large haystack.  Let me share a simple trick I learned from Bryan Stines to make simple work …

SAS Visual Analytics: Tips for Unriddling Encoding in SAS Visual Analytics 6.3

January 20, 2014 – 6:00 am | 2 Comments
Batman's Riddler

In preparation for Tricia and my joint paper at SAS® Global Forum 2014, “SAS Admins Need a Dashboard Too” our SAS admin support team, Ken Aanderud and Paul Homes  had been busy setting up our new SAS Visual Analytics 6.3 environments, which we are very excited about! As we got underway loading tables to explore and analyze data we came across an error that prevented a table to …