SAS VA Data Builder: Add a New Data Item

February 5, 2016
By

The SAS Visual Analytics Data Builder allows you to prepare and load data to the SAS LASR Server so you can complete analysis or build reports and dashboards. It’s a little more tricky to use than some of the other parts of SAS Visual Analytics but can usually be mastered within a day. If...
Read more »

How to eat 724,548 donuts and burn 138 million calories!

February 5, 2016
By

Eating donuts, burning calories, and raising money for a good cause -- that's what the annual Krispy Kreme Challenge is all about. If this intrigues you, read on to find out more... But first, here's a picture of me eating a donut, preparing for...
Read more »

Sorting data in SAS: can you skip it?

February 4, 2016
By
Sorting data in SAS: can you skip it?

TL;DR The next time that you find yourself writing a PROC SORT step, verify that you're working with the SAS Base engine and not a database. If your data is in a database, skip the SORT! The details: When to skip the PROC SORT...
Read more »

Undocumented SAS feature: Bulkloading to Netezza with ODBC interface

February 3, 2016
By

The SAS/ACCESS Interface to ODBC in SAS 9.4M4 states it supports bulk loading only to "Microsoft SQL Server data on Windows platforms." However, in practice on the Windows platform it also supports bulk loading to Netezza.

Bulk loading is amazingly fast....
Read more »

Where might Zika virus strike next?

February 3, 2016
By

The World Health Organization recently declared the Zika virus a global public health emergency. This virus is spread by certain mosquitoes, and therefore if we know where those mosquitoes are located, then we've got a pretty good idea of where the virus might spread. Before...
Read more »

Rolling statistics in SAS/IML

February 3, 2016
By

Last week I showed how to use PROC EXPAND to compute moving averages and other rolling statistics in SAS. Unfortunately, PROC EXPAND is part of SAS/ETS software and not every SAS site has a license for SAS/ETS. For simple moving averages, you can write...
Read more »

What’s the most important new feature in SAS/STAT software?

February 1, 2016
By

What do you think is the most important new feature in SAS/STAT? Well it depends! In this video, SAS developers talk about their new work and which customers will be excited about it and why. Healthcare professionals may lean toward the new rare events...
Read more »

Group processing in SAS: The NOTSORTED option

February 1, 2016
By
Group processing in SAS: The NOTSORTED option

Novice SAS programmers quickly learn the advantages of using PROC SORT to sort data, followed by a BY-group analysis of the sorted data. A typical example is to analyze demographic data by state or by ZIP code. A BY statement enables you to produce...
Read more »

Frequency of individual characters from SAS data set

January 29, 2016
By

This script counts the frequencies of individual ASCII characters in a single column in a SAS data set and then prints an easy-to-read report.

My initial motivation relates to delimiters. By default bulkloading data from Netezza to SAS (which is very fast) uses the...
Read more »

Proc-x is looking for sponsors!

Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com



Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.