This week's SAS tip is from Lora Delwiche and Susan Slaughter's bestselling The Little SAS Book: A Primer, Fifth Edition. With over 50 years of combined SAS experience, this powerhouse duo has helped thousands of programmers. You, too, can benefit from their instruction. The following excerpt is from SAS Press authors Lora
Occasionally, people ask me what is the best thing about writing a book. Is it the notoriety you get from being a SAS Press author? Fame is always pleasant. Is it the money you make from the advance and the royalties? Money is always useful. Is it displaying technical expertise
In SAS 9.4, the SAS programming language continues add new features by the truckload. I've already discussed PROC DELETE (which is actually an old feature, but like an 80s hit song it's now back with a better version). In this SAS Tech Talk video from SAS Global Forum 2013, I
If you need an excuse to get out of the office and perhaps learn a thing or two this fall, here are three upcoming events: Foresight Practitioner Conference: S&OP and Collaborative Forecasting (Columbus, OH, September 25-26) From the campus of Ohio State University, Foresight's editor Len Tashman and S&OP column
Earlier this week I posted a "guest blog" in which my 8th grade son described a visualization of data for the 2013 ASA Poster Competition. The purpose of today's blog post is to present a higher-level statistical analysis of the same data. I will use a t test and a
Teil 1: Performancekiller Der SAS Enterprise Guide ist ein sehr intuitives und trotzdem ausgesprochen mächtiges Graphical User Interface. Neben einer kompletten Programmieroberfläche, bietet er eine Menge Point- and Click Anwendungsroutinen, durch welche man vom Einlesen von Excel-Dokumenten, über SQL-Abfragen, bis hin zu komplexen Grafiken und Vorhersagemodellierungen, mit ein paar Klicks alles erreichen
Die Entwicklung der Rechenkapazitäten ist so rasant, dass man sich das gelegentlich vor Augen führen muss. Vor einem halben Jahrhundert sind Menschen regelmäßig ins All geflogen – mit Computern, deren Leistungsfähigkeit heute von jedem Smartphone übertroffen wird. Während vor wenigen Jahren noch hochqualifizierte Spezialfirmen viele Monate und Jahre für Planung
Last month, a question came in via an earlier blog post. Peter Timusk, a reader of SAS books and potential author, asked Emmett Cox how to be seen as the expert you are by writing a book. Emmett was more than happy to answer Peter’s question. “First pick a topic that
As student growth or value-added measures become more prevalent in educator evaluation systems, many question how those ratings actually help teachers improve their practice. i.e. “How does a level 3 teacher become a level 4 or 5?” Robust and reliable value-added data serve as a great starting point for teachers
Editor's Note: My 8th grade son, David, created a poster that he submitted to the 2013 ASA Poster Competition. The competition encourages students to display "two or more related graphics that summarize a set of data, look at the data from different points of view, and answer specific questions about
The graphs produced by the SG procedures (and GTL) have a default look and feel designed for the common use cases. However, everyone has a preference for some special features that make the graphs unique. Fortunately, extensive customizations can be made to graphs produced by these tools using statement and
John Taylor likes computer data the way he likes big trout: here, there or anywhere. Which is perfectly natural, considering he’s the data analyst in the Inland Fisheries Department at Texas Parks and Wildlife. Taylor describes his unspoiled enthusiasm for big data and big fish in this sendup of Dr. Seuss that
Back in 2011, I wrote about the all new SAS Framework Data Server in 9.3 and how it needs to be running for certain web applications to function properly. But it is actually used as the data storage device for multiple SAS components including webdav content, alerts, comments, and workflows.
Welcome to my new blog series Data Preparation (DP) and Data Quality (DQ) on the road. The main actors here are my two SAS books Data Preparation for Analytics Using SAS and Data Quality for Analytics Using SAS, which are allowed to accompany me to many conferences, SAS events, and
People take SAS Training courses for a variety of reasons. Dr. John Taylor puts the skills he learns in the classroom to work at the Texas Parks and Wildlife Office. As you’ll see in this entertaining video, Taylor has a passion for big data and big trout. “An unexpected
With the medical science these days, there are many genetic defects you can be tested for, to see if you might develop a certain problem/disease, or might be a carrier for it. Would you rather know, or not know? (Would your health insurance company rather know, or not know?) These
If you're a software developer, you're probably already familiar with these terms: I18N and L10N. Internationalization (I + 18 letters + N = I18N) The discipline of preparing your software to run correctly in different languages with different culture settings. For example, the software must be able to accommodate multibyte
The Empirical Evidence Steve Morlidge presents results from two test datasets (the first with high levels of manual intervention, the second with intermittent demand patterns), intended to challenge the robustness of the avoidability principle. The first dataset contained one year of weekly forecasts for 124 product SKUs at a fast-moving consumer
My previous post described the multinomial distribution and showed how to generate random data from the multinomial distribution in SAS by using the RANDMULTINOMIAL function in SAS/IML software. The RANDMULTINOMIAL function is simple to use and implements an efficient algorithm called the sequential conditional marginal method (see Gentle (2003), p.
Suppose we have a perfect forecasting algorithm. This means that we know the "rule" guiding the behavior we are forecasting (i.e., we know the signal), and we have properly expressed the rule in our forecasting algorithm. As long as the rule governing the behavior doesn't change in the future, then any
With the pervasiveness of mobile devices, being able to read while “on the go” has been easier than ever. How many times have you found yourself in a situation where you pass the time waiting by reading something on your phone/iPad/tablet etc? With eBooks on my iPad, I find that
Stellen Sie sich vor, Sie sind der CEO eines weltweit operierenden Unternehmens und finden in einem Benchmark heraus, dass Ihre Wettbewerber stärker wachsen als Sie. Deshalb starten Sie eine Analytics-Strategie, stellen einen Datenanalysten an, nennen ihn Data Scientist (so heißt das nämlich heute) und bitten ihn, analytisch optimierte Marketingkampagnen zu
This article describes how to generate random samples from the multinomial distribution in SAS. The content is taken from Chapter 8 of my book Simulating Data with SAS. The multinomial distribution is a discrete multivariate distribution. Suppose there are k different types of items in a box, such as a
While I've long advocated the use of Coefficient of Variation (CV) as a quick and dirty indicator of the forecastability of a time-series, its deficiencies are well recognized. It is true that any series with extremely low CV can be forecast quite accurately (using a moving average or simple exponential smoothing
This week's SAS tip is from Ron Cody and his very popular book Learning SAS by Example: A Programmer's Guide. If you haven't yet discovered Ron Cody's work, you're missing out. Fortunately, you can learn a lot more about Ron and his many books--as well as view bonus content here. The following excerpt
With the release of SAS 9.4 (which included SAS/STAT 12.3 and SAS Enterprise Guide 6.1), you might seriously consider hiring a Chief Versions Officer (CVO). Fortunately, most of the recent versions of SAS Enterprise Guide work with the different recent versions of SAS, so you have some flexibility as you
Im fortschreitende Modernisierungsprozess befindet sich die öffentliche Hand im Spannungsfeld zwischen knappen Kassen und demografischem Wandel einerseits und Forderungen nach einer wirkungsorientierten und bürgernahen Auftragserfüllung andererseits. Die zunehmende Komplexität der fachlichen Zusammenhänge innerhalb einzelner Politikfelder und der Abhängigkeiten zwischen verschiedenen Bereichen bindet zusätzliche Ressourcen. Mehr und mehr fordert die Politik
How old is your version of SAS software? The graph on the left shows the release dates for various releases of SAS software, beginning with SAS 8.0. The graph is based on a graph on Jiangtang Hu's blog that shows the major SAS releases. As this graph demonstrates, SAS software
"Forecastability" is a frequent topic of discussion on The BFD, and an essential consideration when evaluating the effectiveness of any forecasting process. A major critique of forecasting benchmarks is that they fail to take forecastability into consideration: An organization with "best in class" forecast accuracy may do so only because
Previously I've described how you can use SAS Enterprise Guide to send an e-mail message using Gmail as your e-mail provider. In the article, I mentioned that you can also write SAS programs that send e-mail messages, but at the time you could not reach Gmail using the FILENAME EMAIL
