Many of you know Mike Zdeb. He's a long-time SAS user and frequent presenter at SAS conferences. Zdeb is also a reviewer of many SAS Press books and author of his own SAS book, Maps Made Easy Using SAS. Zdeb contacted me after he read the May SAS Tech Report
The Swiss army knife is known for its versatility, with a variety of tools and blades to help you complete the task at hand. When you are creating graphics, you sometimes have a special feature you want to add, but you can't seem to find the right syntax "tool" to
Unlike many of you, data hasn’t always ruled my world. Though I took statistics and economics classes in college, I built my academic career around studying history and writing papers like “The Importance of the Family Dinner in Preserving the Italian Culture among Immigrants.” Don’t laugh; it earned me an
No matter what statistical programming language you use, be careful of testing for an exact value of a floating-point number. This is known in the world of numerical analysis as "10.0 times 0.1 is hardly ever 1.0" (Kernighan and Plauger, 1974, The Elements of Programming Style). There are many examples
The Supreme Court of the United States is set to reveal its ruling on the landmark health care legislation known as the Affordable Care Act. Much angst has resulted from this law and many parties that feel obliged to support or criticize the law have prepared statements, and in some
According to Janet Stuelpner and Joseph Hantsch, the authors of the 2012 SAS Global Forum paper, One at a Time; Producing Patient Profiles and Narratives, patient profiles are used several ways depending upon the 'customer' need.
A reader wrote for help with a computational problem. He has a vector of length N and the vector contains integer values in the range [1, 120], which represent months for which events occurred over a 10-year period. The question is: what is the 24-month period for which the most
So are you now dreaming big? Coming up with other ideas for how SAS Stored Processes can be leveraged in your installation of SAS? As I mentioned in last week's post, you could use OLAP cubes as a data source for your SAS Stored Process. Here is how I would
This is a third post on newspaper stories that I recently read. Today's post deals with science, politics, and rising sea levels. Incidentally, the title is a blatant reference to John Allen Paulos's brilliant book, A Mathematician Reads the Newspaper. Senate approves law that challenges sea-level science The NC legislature
Can you actually get something for nothing? With PROC SQL’s subquery and remerging features, yes, you can. Often there is a need to add group descriptive statistics such as group counts, minimum and maximum values for further by-group processing. Instead of first creating the group count, minimum or maximum values
One of my new work friends says this frequently. But the statement is lost in his translation from Portuguese, it is not that he does not believe me, it is just that he has questions about how things happen so he can learn. I debate on which version of this
This is my second post on some newspaper articles that I recently read. Today's post deals with academic fraud. Questions linger in academic fraud case Over the past year, the News and Observer has occasionally reported on a scandal at the University of North Carolina at Chapel Hill in which
This past weekend was Father's Day, so I took some time to relax and read the newspaper. I found several stories that suggested interesting statistical questions. Unfortunately, the data are not available for analysis. Nevertheless, the stories are worth sharing. Over the next few days, I'll post my thoughts on
Wizard Harry Potter makes magic just waving his wand around and shouting out spells. Using SAS Enterprise Guide (and you are welcome to shout out your own commands too) you can create some magic, allowing the Stored Process Wizard to code for you. On Step 2, the "Include code for"
To celebrate special occasions like Father's Day, I like to relax with a cup of coffee and read the newspaper. When I looked at the weather page, I was astonished by the seeming uniformity of temperatures across the contiguous US. The weather map in my newspaper was almost entirely yellow
Statistical graphs often include display of derived statistics along with the raw data. Often these statistics are presented in a tabular format inside the graph. With SGPLOT procedure, a table of statistics can be added to the graph as an inset table, as shown below. Using a Stat Table: SGPLOT code:
I had a chance to attend a moderated panel discussion at the last SAS Global Forum Executive Conference with executives from Best Buy, Seminole Gaming and Office Depot, and each speaker offered their own unique story about how applied customer analytics makes a difference in marketing. I captured some key points in previous
In the video below, you'll hear a great explanation from SAS CTO Keith Collins about the benefits of high-performance analytics, and why it's not just about getting answers faster. He also tells interviewer Karin Reed which SAS procedures are being optimized for high-performance analytics and provides up dates about big
The first time that I saw a demonstration of SAS Visual Analytics Explorer was awesome, but it didn't give me goosebumps. I got goosebumps the size of golfballs during SAS Global Forum Opening Session when Dr. Goodnight sat down at a computer screen and began to demonstrate how effortlessly users can
After some discussion with SAS Product Marketing yesterday, we devised this response to everyone's question about the Business Analytic differentiator that SAS provides. ********************************************************************************************************* Business Intelligence is one of the key components from SAS that ties into a suite of analytic techniques, information handling and performance infrastructures needed to deliver
ODS Graphics components like GTL and SG procedures are designed to work with Styles to create graphs that are effective in the delivery of information and aesthetically pleasing out of the box. You no longer have to tweak the colors to ensure a nice graph. The graph derives all the
A colleague was recently working with a web service that supplies some datetime values using the Microsoft Windows internal representation. He called the web service to retrieve those values (along with other data) from SAS, and he needed convert these values to SAS date-time values. The Microsoft definition for a
When I was growing up, summertime always meant a road trip to see my grandparents and great-grandparents in Concord, California, just outside San Francisco. Most of our time in Concord was spent shuffling between relatives but my parents always made time for a day trip into San Francisco. On these
Questions (or search strings) lead people to my blog or my email box on a daily basis and many of these are related to what SAS Stored Processes can or cannot do. Can a SAS Stored Process query an RDBMS? Can a SAS Stored Process create a data table? Could
SAS customers are both bright and generous. Recently, I met several who gathered to discuss SAS Enterprise Miner and SAS Model Manager predictive analytics and data mining software. Hiring the best I loved listening to their discussion on what they look for and how they find the people who will
Six user import and synchronization macros are available in the SAS Foundation directory, these are documented as available in creating programs to retrieve information and compare authentication provider (such as LDAP) account information with what is stored in SAS Metadata to then synchronize the two. Try this code in BASE
A collegue who works with time series sent me the following code snippet. He said that the calculation was overflowing and wanted to know if this was a bug in SAS: data A(drop=m); call streaminit(12345); m = 2; x = 0; do i = 1 to 5000; x = m*x
When the IASUG conference founder and 2012 co-chair John Xu was asked what makes this one-day event so successful year after year, he said, “The most important factor is the leadership. We are lucky that we have core conference volunteers committed to supporting the conference.”
Last Friday morning I took a meeting with SAS CEO Jim Goodnight. Despite the hassle, I was happy to rearrange my busy schedule to squeeze him in. Ha! Just a little joke there about my inflated sense of importance! Actually, the meeting was part of a regular series called "Conversations
A common question really and one that I get after posting code like yesterday's All SAS Stored Process Locations Report. The neat trick is just to type METABROWSE in a BASE SAS command window. (There are two other commands: METACON and METAFIND. Has anyone got any tips on when those
