Tag: Uncategorized

Keeping your data set clean: Integrity constraints

When I teach my Data Cleaning course, the last topic I cover in the two-day course is SAS Integrity Constraints.  I find that most of the students, who are usually quite advanced programmers, have never heard of Integrity Constraints (abbreviated ICs).  I decided a short discussion on this topic would […]

The post Keeping your data set clean: Integrity constraints appeared first on SAS Learning Post.

Jedi SAS Tricks – FedSQL Dictionary Tables

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…

A map of country code top-level domains (ccTLD)

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…

Tabs -vs- Spaces: Which coders make more money?

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 Tabs -vs- Spaces: Which coders make more money? appeared first on SAS Learning Post.

Map: Median age by country

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…

Bilingual job opportunities in the U.S.

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…

Star Trek (the original series) – the infographic!

If you were a fan of the original Star Trek television series, you probably remember lots of little details about the show. And you might even feel sorry for the people who don’t get the clever references you make to things from the show. If you’re tha…