Category: SAS

Where in the World is SAS Visual Analytics?

by Tricia Aanderud • February 9, 2016 • Comments Off

I get a lot of inquiries about the SAS Visual Analytics geo-mapping features. Typically, customers are interested in knowing how specific the plotting can get. Many are concerned that the product is focused mainly in the US and thus probably doesn’t go any deeper – but that’s not true. In this post I’ve assembled landmarks from around the world to give you an idea of …

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 VA Data Builder: Add a New Data Item

by Tricia Aanderud • February 5, 2016 • Comments Off

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! ]]

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

by Robert Allison • February 5, 2016 • Comments Off

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.

Sorting data in SAS: can you skip it?

by Chris hemedinger • February 4, 2016 • Comments Off

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.

Undocumented SAS feature: Bulkloading to Netezza with ODBC interface

by Andrew Z • February 3, 2016 • Comments Off

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.

Where might Zika virus strike next?

by Robert Allison • February 3, 2016 • Comments Off

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.

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

by Sian Roberts • February 1, 2016 • Comments Off

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.

Frequency of individual characters from SAS data set

by Andrew Z • January 29, 2016 • Comments Off

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 pipe character as a delimiter, but my data set contained values with the pipe character, so this macro identifies alternative delimiters.

Another potential use is cracking a message encrypted using a simple letter substitution cipher.

To begin, this code creates an example data set courtesy of William Shakespeare.

For more posts like this, see Heuristic Andrew.

Page 162 of 561

« 1 … 160 161 162 163 164 … 561 »