Dictionary tables are one of the things I love most about SQL! What a useful thing it is to be able to programmatically determine what your data looks like so you can write self-modifying and data-driven programs. While PROC SQL has a great set of dict...

Read more »

Tags: Uncategorized

Posted in SAS | Comments Off on Jedi SAS Tricks – FedSQL Dictionary Tables

Here in the US, we typically use top level domains such as .com, .gov, and .org. I guess we were one of the first countries to start using web domains in a big way, and therefore we kind of got squatter's rights. As other countries started using the we...

Read more »

Tags: analytics, ccTLD, map, Uncategorized

Posted in SAS | Comments Off on A map of country code top-level domains (ccTLD)

One way to assess the precision of a statistic (a point estimate) is to compute the standard error, which is the standard deviation of the statistic's sampling distribution. A relatively large standard error indicates that the point estimate should be viewed with skepticism, either because the sample size is small

The post Read more »

Tags: Bootstrap and Resampling, Uncategorized, vectorization

Posted in SAS | Comments Off on The jackknife method to estimate standard errors in SAS

There have been several polarizing topics throughout history, such as religion & political affiliation. And for software developers there's one more biggie ... tabs -vs- spaces! Which group is right? Perhaps the opinion of the better programmers should have more weight(?) Is there a metric we can use to determine whether

The post Read more »

Tags: analytics, programmers, spaces, survey, tabs, Uncategorized

Posted in SAS | Comments Off on Tabs -vs- Spaces: Which coders make more money?

Below is the latest update to The Popularity of Data Science Software. It contains an analysis of the tools used in the most recent complete year of scholarly articles. The section is also integrated into the main paper itself. New … Continue reading →

Read more »

Tags: analytics, data science, python, R, SAS, SPSS, Stata, Statistics, Uncategorized

Posted in SAS | Comments Off on Data Science Tool Market Share Leading Indicator: Scholarly Articles

Most numerical optimization routines require that the user provide an initial guess for the solution. I have previously described a method for choosing an initial guess for an optimization, which works well for low-dimensional optimization problems. Recently a SAS programmer asked how to find an initial guess when there are

The post Read more »

Tags: Optimization, Uncategorized

Posted in SAS | Comments Off on How to find a feasible point for a constrained optimization in SAS

If countries have a similar median age, does that mean they are also similar in other ways? My best guess at an answer is - probably. Perhaps if we plot the data on a map, we'll be able to see the answer more clearly. I first started thinking about thi...

Read more »

Tags: age, analytics, demographics, Uncategorized

Posted in SAS | Comments Off on Map: Median age by country

When I was in college, I lived in the Alexander dorm, where each room had an American student and an International student. I learned a lot about the rest of the world, and I also heard a lot of different languages being spoken. I'm really impressed wh...

Read more »

Tags: Uncategorized

Posted in SAS | Comments Off on Bilingual job opportunities in the U.S.