This morning Rick introduced how to count the missing frequencies for all variables in a dataset, including character and numeric variables. He provided two solutions by either PROC FREQ or PROC IML. I have a petty macro based on PROC SQL’s nmiss() f…
A test to count missing values for large data
This morning Rick introduced how to count the missing frequencies for all variables in a dataset, including character and numeric variables. He provided two solutions by either PROC FREQ or PROC IML. I have a petty macro based on PROC SQL’s nmiss() f…
Create your first stored process in one little minute
Watch the following youtube video to see how easy it is to create a stored process using the SAS Enterprise Guide Stored Process Wizard interface.
Tip on creating graphic files in specific locations
When trying to write out graphics to a specific filename location, the gsfname option is only honored when ODS LISTING is turned on and ODS HTML is turned off. This is especially important in 9.3 Base SAS as the ODS HTML option is the default output de…
Bridging the gap between statisticians and stakeholders
The Analytics 2011 Conference, taking place Oct. 24-25 in Orlando, FL, is quickly approaching. Larry Seligman, a session speaker at the conference, recently took the time to answer some questions about his presentation and what he is looking forward to…
Calling Windows PowerShell from SAS: a simple example
As I mentioned in my introductory post about Windows PowerShell, you can use PowerShell commands as a simple and concise method to collect data from your Windows systems; information that is ripe for analysis within SAS. In this example, I’ll show a technique for using a SAS program to call […]