Turning text files into SAS data sets—6 common problems and their solutions

If you’re reading this blog post, you have probably gotten a text file from someone that needs to be turned into a SAS data set so that it can be manipulated, analyzed and made into a report. It all starts with getting the data into SAS. Sometimes that requires a […]

Post a Comment

Using SAS to add PivotTables to your Excel workbook

In Microsoft Excel, a PivotTable can help you to create an interactive view of summarized data. Within a PivotTable, it’s easy to adjust the dimensions (columns and rows) and calculated measures to suit your ad-hoc reporting needs. You can also create a PivotChart – similar in concept to a PivotTable, but […]

Post a Comment

SAS macro variables: how to determine scope

Have you ever created a SAS macro variable and at resolution time received a warning that it did not exist? Many times this warning is because your program referenced the macro variable outside the scope it was created in. Every macro variable created is stored in one of two symbol […]

Post a Comment

How to perform a fuzzy match using SAS functions

“Here’s Johnny!!!” and well sometimes John and sometimes Jonathan and sometimes Jon. In the real world, you sometimes need to make matching character strings more flexible. This is especially common when merging data sets. Variables, especially names, are not always exactly the same in all sources of your data. When […]

Post a Comment

Have you created Scalable Vector Graphics with SAS?

If you haven’t tried them for your web applications and other graphics needs, you’ll want to read further! Scalable Vector Graphics (SVG) output is vector graphics output you can display with most (if not all) modern web browsers. Because SVG graphic output is scalable, you can zoom in on the […]

Post a Comment

SAS arrays—be not afraid!

Arrays are a powerful SAS programming tool. They can be used to simplify coding for repetitive calculations, to transpose data and to evaluate variables in a non-sequential manner. Sometimes users are intimidated by the term array, but in SAS, an array is simply a grouping of variables that lasts for […]

Post a Comment

SAS macro errors: the answers you’re looking for

Have you ever received an error or warning in SAS macro and did not know what to do next or even where to look?  Now there is an answer! And debugging your SAS macros just got easier. All macro errors and warnings are now documented in the SAS 9.4 Macro […]

Post a Comment

Symbols in SAS 9.4 graphs: unlimited possibilities

Beginning with the first maintenance of SAS 9.4, you have the ability to define your own symbol markers using the SYMBOLCHAR and SYMBOLIMAGE statements. With these statements you can select a Unicode value or you can select an image file that exists on the local file system—making the possibilities for […]

Post a Comment

Matching SAS releases with compatible OS, SAS client and third-party software

The only thing that’s constant is change. The continual cycle of computing changes leads to common questions about the effects of these changes—operating systems are getting upgraded, customers are moving to new SAS clients, upgrading to new releases of SAS, working with new Java and browser versions. All of these […]

Post a Comment

Encoding: helping SAS speak your language

If you live in an English speaking country you are used to a relatively unadorned alphabet. Take a look at the French and Spanish languages, where vowels are decorated with accents like “acción” in Spanish, and the circumflex, or the hat used in “pâte” in French. Look at the gorgeous […]

Post a Comment