In my first four posts in the education analytics blog series, we learned how education customers are using SAS, the positive impact for their users and institution, and some of their best practices. In talking to customers for this series, one of the many things we've learned is that they
Once you have a data strategy for omnichannel, what's next? Kim Kaluba explains.
SAS Visual Investigator has an attractive user interface. One of its most engaging features is the network diagram, which represents related ‘entities’ and the connections between them, allowing an investigator to see and explore relationships in their source data. For maximum impact, each entity in the network diagram should have an
The purpose of this blog post is to demonstrate a SAS coding technique that allows for calculations with multiple variables and multiple observations across a SAS dataset. This technique can be useful for working with time series, clinical trials, - in any data step calculations involving values from different observations.
Once in a while you run into a pesky situation that is hard to overcome without resorting to major surgery. Such a situation occurs when you have a stacked bar chart with a discrete legend positioned vertically on the side of the graph. A simple example is shown below. title
Need to grant one or more users access to part of your secure SAS configuration directory? You can do it without opening up your SAS configuration directory to everyone. Most SAS 9.4 Platform deployments on Unix have been done using the SAS Installer account known as sas. The sas account
A SAS/IML programmer asked whether you can pass the name of a function as an argument to a SAS/IML module and have the module call the function that is passed in. The answer is "yes." The basic idea is to create a string that represents the function call and then
A ghoulish Halloween Boo to all my readers! Hope my costume freaks you out, but even if it doesn't, I’m positive PROC FREQ will in a few amazing ways! Today’s Programming 2: Data Manipulation Techniques class asked about the power of PROC FREQ. Since I stopped to explain some of it's benefits to
I often create temporary ODS output files - and getting rid of those files after I'm done is an extra chore I don't relish. For example, if I want to generate a PDF-only report and email it from SAS (see "Jedi SAS Tricks: Email from the Front – Part 2")
Joyce Norris-Montanari says IT and business need to work together when giving business users self-service data preparation tools.
When a plot is classified by one or more variables, the different classes values are displayed in the graph either by position or by using different plot attributes such as color, marker shape or line pattern. For plots that display the visual by a filled area (bar, bin, band, bubble,
This article demonstrates a SAS programming technique that I call Kuhfeld's template modification technique. The technique enables you to dynamically modify an ODS template and immediately call the modified template to produce a new graph or table. By following the five steps in this article, you can implement the technique
Plot statements included in the graph definition can contribute to the legend(s). This can happen automatically, or can be customized using the KEYLEGEND statement. For plot statements that are classified by a group variable, all of the unique group values are displayed in the legend, along with their graphical representation
If you’ve been waiting for the buzz to settle around the Internet of Things before deciding how to invest in this new technology space, now’s the time to stop waiting. I’ve been working in the technology sector for a few decades, and the innovation and excitement I’m seeing around IoT
When loading data into CAS using PROC CASUTIL, you have two choices on how the table can be loaded: session-scope or global-scope. This is controlled by the PROMOTE option in the PROC CASUTIL statement. Session-scope loaded proc casutil; load casdata="model_table.sas7bdat" incaslib="ryloll" outcaslib="otcaslib" casout="model_table”; run; Global-scope loaded proc casutil; load casdata="model_table.sas7bdat"
If you plan to travel abroad and see the world, you'll need a passport. And, depending on several factors, you might also need travel visas. Which passports allow you to travel with the least amount of hassle (and the least amounts of visas)? Let's create a map to help you
David Loshin describes some steps you can take to ensure that self-service data preparation improves collaboration.
To improve is to change; to be perfect is to change often.-Winston Churchill If you've visited SAS documentation (also known as the "SAS Help Center") lately, you may have noticed that we've made some fairly significant changes in the documentation for SAS products and solutions. The new site is organized in a new way, search
Suppose you want a list of car manufacturers from the CARS dataset. Easy! Call the %CHARLIST macro from a %PUT statement, like this: The CHARLIST macro generates a list of unique values of a selected variable from a selected dataset. So does PROC FREQ. But, if you don't need statistics, the CHARLIST
The North Georgia Candy Roaster I’m a North Carolina native, born and raised. So, it was quite a surprise at a recent trip to the farmers market when I came across this odd looking, large pink banana-shaped pumpkin-squash that I had never laid eyes on. When I asked what it
Curve labels in series plots can be positioned inside or outside the graph. Date variables can be specified as TYPE=LINEAR with a date format or more commonly as TYPE=DATE. Sometimes external curve labels might appear below or above the graph, particularly with TYPE=DATE axes. This post shows you ways to move them to the right of the graph.
This article describes the advantages and disadvantages of principal component regression (PCR). This article also presents alternative techniques to PCR. In a previous article, I showed how to compute a principal component regression in SAS. Recall that principal component regression is a technique for handling near collinearities among the regression
Quick Quiz! Where might you hear the following conversation? ... Waitress: "What would you like to drink, honey?" Customer: "I'll have a coke." Waitress: "What kind?" Customer: "Diet Pepsi." If you answered somewhere between Texas and Georgia, you would be correct! To those of us not from that area, it
Kim Kaluba says start the journey toward ominchannel with a data strategy based on governance.
Last year, a user asked about creating a "Turnip Plot" as used in this study of Caesarian Section Rates. Primarily, this is similar to a histogram on the y-axis for each unique value on the y-axis. A marker is drawn for each occurrence, starting from the center. Back then, I
A common question on discussion forums is how to compute a principal component regression in SAS. One reason people give for wanting to run a principal component regression is that the explanatory variables in the model are highly correlated which each other, a condition known as multicollinearity. Although principal component
The previous post on Multiple Blank Categories showed how to include multiple blank categories on the axis. But, given the purpose for this was to separate different segments in the data, I also included ideas on how to segmented a discrete axis using reference lines or Block Plot. A similar idea
To make accurate predictions, it is necessary that the sample data you use for model development is compatible with the target population. The distribution of each input used in the model should be similar in the sample and the target population. In your model you should include only those variables
There are many compelling reasons existing SAS users might want to start integrating SAS Viya into their SAS9 programs and applications. For me, it comes down to ease-of-use, speed, and faster time-to-value. With the ability to traverse the (necessarily iterative) analytics lifecycle faster than before, we are now able to generate
Reading an external file that contains delimiters (commas, tabs, or other characters such as a pipe character or an exclamation point) is easy when you use the IMPORT procedure. It's easy in that variable names are on row 1, the data starts on row 2, and the first 20 rows
