Recently, I shared a summary of Brian Varney’s SESUG presentation on How to document your SAS environment. One important step was determining where files that control overall processing, such as autoexec.sas files, are deployed. For installations on a single server or platform, Varney suggested using the OPTIONS procedure, which lists
Frequently someone will post a question to the SAS Support Community that says something like this: I am trying to do [statistical task]and SAS issues an error and reports that my correlation matrix is not positive definite. What is going on and how can I complete [the task]? The statistical
“So, you work for SAS?” asked my co-passenger. I was on the plane to Baltimore to attend my first NESUG conference and the tag on my laptop bag was the clue. I happened to be seated next to a SAS user who was familiar with ODS Graphics. I ended up
Several weeks ago, South Carolina was the victim of what some experts believe to be the largest cyber-attack against a state tax department in history. Approximately 3.6 million personal South Carolina income tax returns were exposed, and nearly 657,000 businesses compromised, in an international hacking attack. Coincidentally, SAS and the SC
Jenine Milum is the Vice President and Analytics Manager at Wells Fargo Bank. About 10 years ago, she learned a valuable, but little known solution to cutting the CPU processing time when dealing with large data sets. "We were processing log activity for our website on a daily basis," says Milum,
Have you used the MEANS procedure to calculate frequencies: for several variables in the same step? without sorting the data first? without checking for missing values? using the TYPE statement and the CLASS statement together? At the recent SouthEastern SAS Users Group conference, Janet Willis shared what can go wrong
Last week I wrote about using acceptance-rejection algorithms in vector languages to simulate data. The main point I made is that in a vector language it is efficient to generate many more variates than are needed, with the knowledge that a certain proportion will be rejected. In last week's article,
Kirk Paul Lafler, Software Intelligence Corporation, has written four SAS books and more than 500 peer-reviewed papers - 19 of which were awarded Best Contributed Papers or Poster, so I’m going to believe him when he says that he’s figured out a thing or two about tuning SAS systems.
A recent question by a user lead led me to experiment with what is often referred to as conditional highlighting. The user wanted to display a bar chart of response by year, where each bar is colored by year, and show a cross hatch pattern on the bars where the
Have you heard the expression "Talk Turkey"? Well then, what better (tongue-in-cheek) thing to do around the Thanksgiving holiday, than talk some turkey using SAS Graphs! ;) I don't usually decorate my graphs with images and pictures (they typically make the graph more difficult to read), but when it comes
The LOC function is one of the most important functions in the SAS/IML language. The LOC function finds elements of a vector or matrix that satisfy some condition. For example, if you are going to apply a logarithmic transform to data, you can use the LOC function to find all
Most custom tasks need to access SAS data in some way. Since custom tasks are built using Microsoft .NET, and the .NET Framework is object-oriented, it would be convenient if we had an object-oriented method for navigating SAS data sources. That was the thinking behind the "SasData"-namespace classes within the
As the holidays approach, we’ll all have some down-time to catch up on personal and professional reading, hopefully cozied up by a fire with a cup of hot chocolate in hand. While most books regarding data-driven decision making and value-added analyses can be pretty heavy, I’d like to suggest two
In pharmaceutical research, analysts often want to see the number of respondents who are at each site and the treatment they receive. Apparently, there's more than one way to produce correct results when you are using the PROC MEANS procedure. In Janet Willis' paper, Do You Have Too Much Class?, (awarded Best
Are you considering submitting a paper to the SAS Global Forum? The deadline for submissions is right around the corner – here’s some ideas to help you get your paper selected! Steve Overton and Tricia Aanderud have presented papers at several of the SAS user groups and here are a
Analytics maturity is a hot topic right now. Many come to SAS for answers on how to assess their analytics maturity and advance their use of analytics, especially at a corporate level. I want to share the highlights of what we usually prescribe from a best practices perspective regarding advancing
'Develop an Analytic Center of Excellence (COE)' could be translated to – develop a culture of analytics in your organization such that every department and division sees value in analytics and pursues measurement for all strategic decisions.
As one of the external instructors for the SAS Platform Administrator Fast Track course in Australia, I have found that the students who attend the courses come from diverse backgrounds. My experience so far has been an approximate 50-50 split, with half being IT system administrators wanting to learn how
A few days ago on the SAS/IML Support Community, there was an interesting discussion about how to simulate data from a truncated Poisson distribution. The SAS/IML user wanted to generate values from a Poisson distribution, but discard any zeros that are generated. This kind of simulation is known as an
Justin Smith and William “Gui” Zupko were looking at manufacturing data over time and wanted to know the minimum value in their dataset, and they wanted to pinpoint its exact location – the specific row and column. PROC ARIMA uses the ARIMA (auto-regressive integrated moving average) model or the ARMA
Editor's note: This post was updated on 8/5/16. “One time a fellow came up to me and said, ‘Tell me something unique about you,” said David Chapman, of Chapman Analytics, “I said, ‘I used SAS when SAS was free.” Needless to say, Chapman has been using SAS for a long
Congratulations to this year's NorthEast SAS Users Group Student Scholarship winners! Student scholarships make it possible for young professionals to learn new SAS skills, meet other SAS users, hear about innovative new research, and network with other professionals from around the world. Rachel Bray, University of Maryland College Park, is pursuing a
How do you hire a Chief Data Scientist? That's not a hypothetical question: I know of at least three companies that are actively looking for a "Chief Data Scientist" at the moment. Hiring the right person is harder than you'd think. Whether or not a Chief Data Scientist is a
I was recently asked, "Does SAS support computing inverse hyperbolic trigonometric functions?" I was pretty sure that I had used the inverse hyperbolic trig functions in SAS, so I was surprised when I read the next sentence: "I ask because I saw a Usage Note that says these functions are
Last week I attended my first SCSUG conference, this one in Houston. Houston, the fourth most populous city in USA, is the world's capitol of the Oil and Gas industry. So it was no surprise I met many attendees from local oil and gas related companies. But, I also met many
We are careening towards the holiday season, and this year more than ever before it's going to mean one thing: Online Shopping. As you enter your credit card number over and over to complete your many purchases, you might occasionally transpose or mistype your account number. Does it surprise you
Did I tell you that I went to Andrew Kuligowski's hands-on workshop while I was at MWSUG 2012? Actually, I only attended the first portion of his session; it didn't make sense for me to take up a computer since I'm not a programmer. His workshop was to teach users how to parse useful data from unusual
IBM Global Financing offers 100 percent financing on your SAS purchase In this economy, many companies are counting their pennies. Those budget constraints can put a real damper on requests for the SAS products and solutions that you need for your data challenges. IBM Global Finance (IGF) – the world's
There are people who claim that an IT expert professional with no knowledge of SAS can get the SAS Administrator job done. That's probably true. It also depends on your definition of getting the job done. At some SAS sites, it can be that the administrator's role in supporting SAS is to install it and
The other day I was constructing covariance matrices for simulating data for a mixed model with repeated measurements. I was using the SAS/IML BLOCK function to build up the "R-side" covariance matrix from smaller blocks. The matrix I was constructing was block-diagonal and looked like this: The matrix represents a
