Use Elasticsearch and Kibana for large BI system

February 16, 2017
By
Use Elasticsearch and Kibana for large BI system



Nowadays Elasticsearch is more and more popular. Besides it original search functionalities, I found Elasticsearch can be

  1. used as a logging container. That is what the ELK stack is created for.
  2. utilized as a JSON server with richful APIs, which can be combined with its Kibana as BI...
    Read more »

Simultaneous confidence intervals for multinomial proportions

February 15, 2017
By
Simultaneous confidence intervals for multinomial proportions

A categorical response variable can take on k different values. If you have a random sample from a multinomial response, the sample proportions estimate the proportion of each category in the population. This article describes how to construct simultaneous confidence intervals for the proportions as described in the 1997 paper

The post Read more »

Learn about SAS Studio, SAS Enterprise Guide and (drumroll) SAS Viya at SAS Global Forum 2017!

February 14, 2017
By

When mentioning to friends that I’m going to Orlando for SAS Global Forum 2107, they asked if I would be taking my kids. Clearly my friends have not attended a SAS Global Forum before as there have been years where I never even left the hotel! My kids would NOT enjoy it… but,

The post Read more »

Purging inactive voter registrations in North Carolina

February 13, 2017
By

After the recent presidential election, I was updating my graphs of the voter registration data and noticed that the number of registered voters decreased after the election. At first I thought that was odd, but then I realized that maybe inactive voters were being purged. I wanted to find out

The post Read more »

An easy way to run thousands of regressions in SAS

February 13, 2017
By
An easy way to run thousands of regressions in SAS

A common question on SAS discussion forums is how to repeat an analysis multiple times. Most programmers know that the most efficient way to analyze one model across many subsets of the data (perhaps each country or each state) is to sort the data and use a BY statement to

The post Read more »

Visualized: US Currency in circulation, past and present

February 9, 2017
By
Visualized: US Currency in circulation, past and present

During my morning commute I heard an interesting news story on NPR's Morning Edition about the merits and risks of the $100 bill. Apparently there are a lot of them in circulation, but no one knows exactly where they are. According to the report, they are seldom used for legitimate

The post Read more »

Visualizing 100 years of US presidential pardons

February 9, 2017
By

A topic that's been in the news a lot lately is the presidential power to grant pardons, commutations, and such. But all the articles I've seen just quoted numeric totals - I haven't seen a graph of the data anywhere! So I set out to find the data and graph

The post Read more »

Winsorization: The good, the bad, and the ugly

February 8, 2017
By
Winsorization: The good, the bad, and the ugly

On discussion forums, I often see questions that ask how to Winsorize variables in SAS. For example, here are some typical questions from the SAS Support Community: I want an efficient way of replacing (upper) extreme values with (95th) percentile. I have a data set with around 600 variables and

The post Read more »

Tip for coding your color values in SAS Enterprise Guide

February 7, 2017
By
Tip for coding your color values in SAS Enterprise Guide

Colors are the subject of many romantic poems and songs, but there isn't much romance to be found in their hexadecimal values. With apologies to Van Morrison: ...Skipping and a jumping In the misty morning fog with Our hearts a thumpin' and you My cx662F14 eyed girl When it comes

The post Read more »

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.

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
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.