Posts Tagged ‘ Data Analysis ’

Rolling statistics in SAS/IML

February 3, 2016
By
Rolling statistics in SAS/IML

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 a DATA step program, as discussed […] The post Rolling statistics in SAS/IML appeared first on The DO Loop.

Read more »

Compute a moving average in SAS

January 27, 2016
By
Compute a moving average in SAS

A common question on SAS discussion forums is how to compute a moving average in SAS. This article shows how to use PROC EXPAND and contains links to articles that use the DATA step or macros to compute moving averages in SAS. In a previous post, I explained how to […] The post Compute a moving average in SAS appeared first on The DO Loop.

Read more »

What is a moving average?

January 25, 2016
By
What is a moving average?

A moving average (also called a rolling average) is a statistical technique that is used to smooth a time series. Moving averages are used in finance, economics, and quality control. You can overlay a moving average curve on a time series to visualize how each value compares to a rolling […] The post What is a moving average? appeared first on The DO Loop.

Read more »

Using Excel versus using R

January 15, 2016
By

Here is a video I made showing how R should not be considered “scarier” than Excel to analysts. One of the takeaway points: it is easier to email R procedures than Excel procedures. Win-Vector’s John Mount shows a simple analysis both in Excel and in R. A save of the “email” linking to all code … Continue reading Using Excel versus using R

Read more »

Compute a weighted mean in SAS

January 6, 2016
By
Compute a weighted mean in SAS

Weighted averages are all around us. Teachers use weighted averages to assign a test more weight than a quiz. Schools use weighted averages to compute grade-point averages. Financial companies compute the return on a portfolio as a weighted average of the component assets. Financial charts show (linearly) weighted moving averages […] The post Compute a weighted mean in SAS appeared first on The DO Loop.

Read more »

Popular posts from The DO Loop in 2015

January 4, 2016
By
Popular posts from The DO Loop in 2015

I wrote 114 posts for The DO Loop blog in 2015. Which were the most popular with readers? In general, highly technical articles appeal to only a small group of readers, whereas less technical articles appeal to a larger audience. Consequently, many of my popular articles were related to data […] The post Popular posts from The DO Loop in 2015 appeared first on The DO Loop.

Read more »

Why doesn’t PROC UNIVARIATE support certain common distributions?

December 7, 2015
By
Why doesn’t PROC UNIVARIATE support certain common distributions?

A SAS customer asked: Why isn't the chi-square distribution supported in PROC UNIVARIATE? That is an excellent question. I remember asking a similar question when I first started learning SAS. In addition to the chi-square distribution, I wondered why the UNIVARIATE procedure does not support the F distribution. These are […] The post Why doesn't PROC UNIVARIATE support certain common distributions? appeared first on The DO Loop.

Read more »

What was data science before it was called data science?

December 2, 2015
By
What was data science before it was called data science?

“Data Science” is obviously a trendy term making it way through the hype cycle. Either nobody is good enough to be a data scientist (unicorns) or everybody is too good to be a data scientist (or the truth is somewhere in the middle). Gartner hype cycle (Wikipedia). And there is a quarter that grumbles that … Continue reading What was data science before it was called data science?

Read more »

Exact tests in PROC FREQ: What, when, and how

October 26, 2015
By
Exact tests in PROC FREQ: What, when, and how

Did you know that the FREQ procedure in SAS can compute exact p-values for more than 20 statistical tests and statistics that are associated with contingency table? Mamma mia! That's a veritable smorgasbord of options! Some of the tests are specifically for one-way tables or 2 x 2 tables, but many apply […] The post Exact tests in PROC FREQ: What, when, and how appeared first on The DO Loop.

Read more »

Tabulate counts when there are unobserved categories

October 7, 2015
By
Tabulate counts when there are unobserved categories

Suppose that you are tabulating the eye colors of students in a small class (following Friendly, 1992). Depending upon the ethnic groups of these students, you might not observe any green-eyed students. How do you put a 0 into the table that summarizes the number of students who have each […] The post Tabulate counts when there are unobserved categories appeared first on The DO Loop.

Read more »


Subscribe

Email:

  Subscribe