Coding Tips

1636r_library_of_congress_Karmi_mystery_india
Stored Processes

SAS Stored Process: Dealing with Disappearing Results

The world needs magicians or illusionist.  I love watching illusions.  When I was at the SAS Professional Forum in the UK, there was a illusionist who just knew one card trick after another. Even when he seemed to mess up, he would then point to the card box and say, “Oh your card must be […]

Read More
0262r library of congress laurent magician
BI Tools
Stored Processes

Little Known Secrets from SAS Stored Process Magicians

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 […]

Read More
Batman's Riddler
Coding & Data
Visual Analytics

Tips for Unriddling Encoding in SAS Visual Analytics 6.3

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 […]

Read More
BI Tools

Administration: Retrieving Passwords from the SAS Metadata

When working with the SAS metadata, sometimes a developer needs to retrieve a user ID and password from the metadata. For instance a developer may need the encoded password to connect to the database using the SAS pass-through with relational databases like Oracle and TeraData.  [More discussion about the pass-through :  here with TeraData, here […]

Read More
BI Tools

SAS Coding: Scattered Data Might Need CPORT Procedure Help

My computer is a hot mess!  I have datasets and code everywhere.  I’m serious … you name it … there is not a hard drive, thumb drive, and even a DVD in my office that doesn’t have data on it.  I call it Scattered Data Syndrome and I had to do something before I kicked a […]

Read More