Category: SAS

SAS programmers: meet Twitter

“Twitter, thou art nought but data.” So sayeth the SAS programmer.

Many data analysts now recognize Twitter for what it is: a tremendous source of data covering almost any topic, from Justin Bieber’s hair to political uprisings to technical conf…

Manage the internal SAS 9.2 account policies

In SAS 9.2, internal accounts can be created and utilized within the metadata and then do not require host (or domain) accounts defined elsewhere. By default, the sasadm@saspw is one such internal account.

Unless you specifically declare an exception,…

Optimize many-to-one mapping by user-defined functions

In many occasions, fast access into a lookup table to find desired value is necessary. In computer science, linked list, associative array, and hash table are widely used to construct the relationship between values and keys. Hash function, like value…

NOTE: SAS Office Analytics for Midsize Business

Since when did “mid size” become one word? Answer: since SAS recently released a new product bundle that means small to medium sized enterprises (SMEs) can get the value of Add-in for Microsoft Office (AMO) without the expense of Business Intelligence …

Making SOAP calls from SAS! Integrating with web services

One of the issues with SAS for many IT departments is the lack of integration with service oriented architecture (SOA). The good news is with many new features coming online with versions 9.X+ are service oriented. Lets look quickly at the Proc SOAP procedure now available. For those SAS programmers out there that aren’t familiar with […]

Manage the internal SAS 9.2 account policies

In SAS 9.2, internal accounts can be created and utilized within the metadata and then do not require host (or domain) accounts defined elsewhere. By default, the sasadm@saspw is one such internal account. Unless you specifically declare an exception, …

SAS Programmer Rule # 1

Let’s start with a quiz. Which of the following is the Programmer’s Rule # 1?

1. Expert knowledge of multiple languages, like SAS and Java
2. Talent to maneuver with complex algorithms
3. Innate ability to draw flowcharts
4. None of the abov…

Strip Non-Printable ASCII Characters (SAS)

Say in your SAS data set, which comes from a text file, XML, or database, has non-ASCII characters that look like garbage—perhaps an odd square. These are probably control characters that mean something to some system, but they may be useless to …