In recent years, more and more people have been registering as independent voters in the US, rather than Democrat or Republican – the independents now control well over 1/3 of the votes. Will they likely vote for the Democrat or Republican candidates in the upcoming election? Let’s break down some numbers […]
The post Will independent voters decide the election? appeared first on SAS Learning Post.
Here in the US, our July 4th Independence Day holiday is coming up. It’s a festive holiday with lots of fun & fireworks, but you also need to also be careful … and I’ve got the graphs to prove it! Last year, I wrote a blog post about a SAS […]
The post July 4th Fireworks Safety appeared first on SAS Learning Post.
I recently read an article that claims 35% of men, and 40% of women in the US are now obese. Yikes! I wondered when this happened, and whether it had been a gradual or sudden change. If I only had some graphs … which the article didn’t provide. I did some […]
The post The big fat truth about the US weight problem appeared first on SAS Learning Post.
When I travel for work, I want to get the most out of my trip. So while I was in Las Vegas in April for SAS Global Forum, I used my free time to check out what’s in store for the Analytics Experience at the Bellagio, Sept. 12-14. Take a […]
The post Analytics Experience – Maximize your conference trip appeared first on SAS Learning Post.
With recent advances in quadcopters, or drones, they have become pretty capable and fun flying machines. And just about anybody can afford the entry-level models. They’ve recently become prevalent enough that the government has started coming up with rules, and the Federal Aviation Administration (FAA) started requiring owners to register drones that […]
The post These aren’t the drones you’re looking for – but those are! appeared first on SAS Learning Post.
The one thing, above all others, that I wish PROC REPORT could do is know which observations from my data set that I want kept together on a single page of non-Listing output. This is problematic for two reasons. 1. PROC REPORT cannot read my mind! 2. PROC REPORT does […]
The post My one PROC REPORT wish appeared first on SAS Learning Post.
Netezza and SAS allow a query to reference a calculated column by name in the SELECT, WHERE, and ORDER BY clauses. Based on the DRY principle, this reduces code and makes code easier to read and maintain.
Some people call calculated columns derived or computed columns.
In Microsoft SQL Server, SQLite, and other RDBMSs you cannot exactly do this: a workaround is to reference a subquery or view. In Microsoft SQL Server, you can also define a computed column on a table.
Below is an example tested with Netezza 7.2. Notice height_m is used in the SELECT clause, and bmi is used in the WHERE and ORDER BY clauses.
For more posts like this, see Heuristic Andrew.
For the first time in 4.5 years, we had a day with zero sunspots – I think this special occasion calls for some sunspot graphs! But before we get started, here’s one of the many pictures my friend Kirk took of the sun down in Marco Island, Florida. Spots or no […]
The post I see spots – sunspots! appeared first on SAS Learning Post.