This blog post is a "mashup" of a couple of my previous posts, combining the lessons to create something brand new that I hope you will find useful. First, let's review what we know: SAS Enterprise Guide supports a scriptable object model, which allows you to write scripts or programs
I was recently asked the following question: I am using bootstrap simulations to compute critical values for a statistical test. Suppose I have test statistic for which I want a p-value. How do I compute this? The answer to this question doesn't require knowing anything about bootstrap methods. An equivalent
When you analyze data, you will occasionally have to deal with categorical variables. The typical situation is that you want to repeat an analysis or computation for each level (category) of a categorical variable. For example, you might want to analyze males separately from females. Unlike most other SAS procedures,
We'll interrupt the series on Why Forecasts are Wrong, with a report from the inaugural Analytics 2011 conference, held last week in Orlando. A2011 drew over 1025 attendees (from 44 states and over 25 counties). The Analytics conference series features a wide range of topics (including forecasting, optimization, data mining, text
One great element of SAS’ Analytics2011 conference (not a SAS Users Group conference, but a great place for SAS users to find information about using SAS) is how it gives students a platform to showcase their work in analytics. Every year, hundreds of posters are submitted outlining innovative applications and research
In SAS/IML 9.22 and beyond, you can call the R statistical programming language from within a SAS/IML program. The syntax is similar to the syntax for calling SAS from SAS/IML: You use a SUBMIT statement, but add the R option: SUBMIT / R. All statements in the program between the
Writing is usually very easy for me - I close the door and concentrate on the task at hand. But today, my mind is wandering. Maybe it's the changing season (it's fall in the US) that makes me think of all of the SAS users who might be reading my posts:
"I think that my data are exponentially distributed, but how can I check?" I get asked that question a lot. Well, not specifically that question. Sometimes the question is about the normal, lognormal, or gamma distribution. A related question is "Which distribution does my data have," which was recently discussed
Years ago and a seemingly far galaxy away, I wrote about how to modify 9.1.3 to start Enterprise Guide users in a different location for the File folder. By default, the user only can access their personal SAS Temporary File. Why change this? I would prefer to use a central
I was contacted by SAS Technical Support regarding a customer who was trying to use SAS/IML to compute quantiles of the folded normal distribution. I had heard of the distribution, but it is not built into SAS and I had never worked with it. Nevertheless, I set out to understand
For the past year, I’ve had the pleasure of serving on the communications team of the National Collaborative for Bio-Preparedness (NCB-P), of which SAS is a partner and the analytics provider. That experience was heavy on my mind as I recently watched the film Contagion. I may drop some minor
“I really wish someone had shown me this function in SAS sooner, because it’s saved me a ton of time and effort,” said Brandi Rhoads as she opened her presentation at the Western Users of SAS Software (WUSS) conference in San Francisco.
I've been very fortunate to meet a lot of SAS users during my scant 3 year tour at SAS. I've met them while attending SAS Global Forum 2009, 2010, and 2011; NESUG 2009, 2010 and 2011; and SESUG 2010. Of course, like you, I want to go to all of the
In SAS/IML 9.22 and beyond, you can call any SAS procedure, DATA step, or macro from within a SAS/IML program. The syntax is simple: place a SUBMIT statement prior to the SAS statements and place an ENDSUBMIT statement after the SAS statements. This enables you to call any SAS procedure
Within the SAS documentation there must be thousands of unique words. But ten words occur more than any others within the SAS documentation corpus: SAS, data, statement, option, set, value, variable, PROC, model, table. This is according to one of our staff terminologists, Vicki Leary, who helps to keep our use of these words consistent and
This week brought big news of one of the most cruel and heartless tyrants of the 21st century. This man is known for narcissistic behavior, surrounding himself with a cadre of beautiful women, sleeping in a different place every night, picking new favorites each week, and bringing tears and untold suffering
In my Friday series about innovation, I've decided to include some personal stories of unusual and unique uses of SAS. Once a month or so, I'll swap out the Post-it Notes for a profile of someone who has used SAS in an innovative way to solve a problem or, like
When I learn a new statistical technique, one of first things I do is to understand the limitations of the technique. This blog post shares some thoughts on modeling finite mixture models with the FMM procedure. What is a reasonable task for FMM? When are you asking too much? I
Halloween is around the corner and children everywhere will wear masks throughout their neighborhoods for a night of trick-or-treating fun and, likely, too much candy. A masking has also occurred in education policy with the No Child Left Behind Act, sans the candy at the end of the night. That
Two weeks ago I had the pleasure of reading Tom Wallace's new book, Sales & Operations Planning: Beyond the Basics. This is not an introductory "how to" book -- Tom and Bob Stahl have already written those -- but instead covers nine major companies that have implemented (and extended!) S&OP
If you've been to a SAS Forum, US SAS Regional or local SAS event, you know that it is impossible to see and hear everything that is on your list. Imagine how disappointed your SAS colleagues are who are sitting at home. They would love to hear about what you
Normal, Poisson, exponential—these and other "named" distributions are used daily by statisticians for modeling and analysis. There are four operations that are used often when you work with statistical distributions. In SAS software, the operations are available by using the following four functions, which are essential for every statistical programmer
Functionality to upload files onto the SAS server (from 9.2 on) is available using stored processes and an html input type="file". I introduced this topic last year in my blog post using the SAS Stored Process Developer Guide sample. Of course, it is never as easy as the sample is
~Contributed by Paul Gorrell and Warren Stinson, Conference Co-Chairs There were 384 attendees from 23 states and 6 countries gathered at the Holiday Inn By The Bay in Portland, Maine for three days to present, discuss, code, blog and tweet, using both familiar and new ways to share SAS expertise. There
With data standards rising in every industry, there’s a high demand for analysts and an unfortunate shortage of analytic talent. Many organizations are turning to student internships as a low-cost way to hire support, train potential new employees and provide real-world experience for students.
The premise of the modern portfolio theory (MPT), proposed by Harry Markowitz in 1952, is diversity. Murphy Choy says that means you should “never put all of your eggs in the same basket.” According to Choy, the theory was never meant to be used with complex investment products because they
I received the following email: Dear Dr. Wicklin, Why doesn't SYMPUT work in IML? In the DATA step, I can say CALL SYMPUT("MyMacro", 5) but this doesn't work in IML! Frustrated Dear Frustrated, The SYMPUT subroutine does work in SAS/IML software! However, the second argument to SYMPUT must be a
Ready for some fun facts? These tidbits were all shared during the Western Users of SAS Software (WUSS) conference held in San Francisco this week: 1. How many million dollars did a simple Excel spreadsheet error cost TransAlta? Answer: $24 million 2. What percentage of mobile phone users older
There are days that I could use code like this to make two of myself. No, that would never work; then I would be bored with so much time on my hands! In this new series, called Friday's Innovation Inspiration, we'll take a look at Post-It Notes from the 2011 Innovation Walls. SAS users filled
I previously wrote about using SAS/IML for nonlinear optimization, and demonstrated optimization by maximizing a likelihood function. Many well-known optimization algorithms require derivative information during the optimization, including the conjugate gradient method (implemented in the NLPCG subroutine) and the Newton-Raphson method (implemented in the NLPNRA method). You should specify analytic
