Tag: Uncategorized

Two tips for importing and exporting data between SAS Enterprise Guide and Microsoft Excel

In his first SAS® Enterprise Guide® Tip, instructor David Ghan teaches how to import and combine data from multiple Microsoft Excel sheets.  Then, in his second tip, he shows the alternative approach – how to export groups of data to separate sheets…

Top 6 recommendations for SAS Certification preparation

Certification is always a hot topic on our social media channels. A popular, ongoing discussion in our LinkedIn group focuses on advice for candidates preparing for the SAS Certified Base Programmer exam. Here’s a summary of the top recommendations t…

A better than median year

SAS has had a many good years. But that’s old news. In the past. Old hat. This is a new year, and we don’t rest on our laurels. We may toot our own horn about our laurels, but we don’t rest on ’em. Peer Revue’s job is to inform you of […]

What are the odds of … winning the lottery?

What are the odds of winning the lottery?  This seems like a simple question (and yes, there is a simple answer), but there are a few technical details to work out first… Which lottery?  Let’s say the Powerball Lottery. When? The number of balls us…

Mathematical squiggles in SAS

John D. Cook shared a picture of “pretty squiggles” on his blog, as well as a prose description of the mathematics behind it. I’m more of a programmer than a mathematician, but I’ve attempted to transcribe his description into a SAS program. I used DATA step to generate the point […]

Time to trade in your jalopy macro?

Suppose you have an old jalopy that’s perfectly reliable.  Your jalopy gets you where you wanna go: no frills; no drama. Do you trade your old wheels in for a racecar that accelerates like crazy and corners like it’s on rails? Or stick with what’s old…

If Netflix had used my viewing history to create its new show

Netflix has made a big splash in the news with its use of big data. By analyzing millions of data points about the viewing habits of its customers, the movie delivery giant used the insight it gained to devise the “perfect show”. One of the defining characteristics of the show, […]

A SAS graph for the Chinese New Year

I like to think that I have a graph for all occasions – Chinese New Year is no exception! … This year, the Chinese New Year is on Feb 10, 2013. The date varies from year to year, because it’s based on the lunar (moon) cycles.  I thought it would […..