PROC-X: an online (unofficial) journal about the SAS(R) software - written by bloggers

SAS VA Data Builder: Add a New Data Item

by Tricia Aanderud • February 5, 2016

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 you need to add a data item to your data table, …

This post appeared first on BI Notes for SAS Software Users. Go to the site to subscribe or view more content.

[[ This is a content summary only. Visit my website for full links, other content, and more! ]]

SAS

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

by Robert Allison • February 5, 2016

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 a race. I bet you didn’t […]

The post How to eat 724,548 donuts and burn 138 million calories! appeared first on SAS Learning Post.

SAS

Sorting data in SAS: can you skip it?

by Chris hemedinger • February 4, 2016

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 step Many SAS procedures allow you […]

The post Sorting data in SAS: can you skip it? appeared first on The SAS Dummy.

SAS

Undocumented SAS feature: Bulkloading to Netezza with ODBC interface

by Andrew Z • February 3, 2016

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. In some of my benchmarks the duration of the whole bulk loading operation is independent of the number of rows inserted!

By default on Netezza the bulk loading interface delimits values using a pipe character, and for cases where the values contain a pipe, SAS Access Interface to ODBC unofficially supports the BL_DELIMITER option to specify an alternate delimiter. For the ODBC interface, this option is undocumented.

However, there are nuances with the BL_DELIMITER option. According to the SAS Access Interface to Netezza:

?p>Read more »

For more posts like this, see Heuristic Andrew.

SAS

Where might Zika virus strike next?

by Robert Allison • February 3, 2016

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 we get to the numbers, here […]

The post Where might Zika virus strike next? appeared first on SAS Learning Post.

SAS

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

by Sian Roberts • February 1, 2016

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 control charts in QC, which allows […]

The post What’s the most important new feature in SAS/STAT software? appeared first on SAS Learning Post.