My one PROC REPORT wish

June 9, 2016
By

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 Read more »

Reusing calculated columns in Netezza and SAS queries

June 8, 2016
By

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...
Read more »

I see spots – sunspots!

June 8, 2016
By

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 Read more »

Lasagna plots in SAS: When spaghetti plots don’t suffice

June 8, 2016
By
Lasagna plots in SAS: When spaghetti plots don’t suffice

Last week I discussed how to create spaghetti plots in SAS. A spaghetti plot is a type of line plot that contains many lines. Spaghetti plots are used in longitudinal studies to show trends among individual subjects, which can be patients, hospitals, companies, states, or countries. I showed ways to

The post Read more »

R Passes SAS in Scholarly Use (finally)

June 8, 2016
By
R Passes SAS in Scholarly Use (finally)

Way back in 2012 I published a forecast that showed that the use of R for scholarly publications would likely pass the use of SAS in 2015. But I didn’t believe the forecast since I expected the sharp decline in SAS … Continue reading
Read more »

How to get started learning SAS

June 7, 2016
By

You’ve probably seen the headlines by now that reveal SAS analytics skills are the most valuable skills in today’s job market. So what’s next? There is no better time to learn SAS programming – there are a slew of options and resources to get you started. First, explore the many

The post Read more »

Jedi SAS Tricks: Writing to Text Files from DS2

June 6, 2016
By

A reader posed a question in the comments to an earlier Jedi SAS Trick, asking how to write the results of a DS2 DATA _NULL_ program to a text file. It's an interesting question, as DS2 currently has no text file handling statements or capabilities. Take, for example, this traditional

The post Read more »

Rexer Data Science Survey: Satisfaction Results

June 6, 2016
By
Rexer Data Science Survey: Satisfaction Results

by Bob Muenchen I previously reported on the initial results of Rexer Analytics’ 2015 survey of data science tools here. More results are now available, and the comprehensive report should be released soon.  One of the more interesting questions on the survey … Continue reading
Read more »

Beyond the Credential: What’s up with the test before the test?

June 6, 2016
By

If you have taken a SAS Deployment exam in the past 9-12 months, you may have wondered why there are pre-test test questions. While it might seem like I am providing warmer-upper questions out of the goodness of my heart, these pre-test tests are actually called candidate surveys. Their purpose?

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.