What if you would like to make a copy of an existing stored process to test out your changes before making them live? The copy command is available from within SAS Management Console or from the SAS Enterprise Guide Open Stored Process GUI as seen below (note you can only
Remarkably, this week's tip was initially inspired by the Guinness Brewery in Dublin, Ireland. In his new book Statistical Analysis for Business Using JMP, Professor Willbann Terpening provides lots of useful information - including the origin and usage of the Student t-distribution. If you'd like to get to know Willbann and
What tiny looking operator packs a mighty punch with large datasets? Your queries are big. Your reports span multiple columns. To top it all you have to summarize data in multiple ways. Are you tempted to throw in the towel? Do you feel like saying a firm “Can’t be done”
This week's SAS author's tip comes from Carol Matthews and Brian Shilling and their book Validating Clinical Trial Data Reporting with SAS. SAS users have raved about this guide. In her review, Susan Fehrer said "Carol and Brian's book provides a good overview, practical hands-on tips, and many examples of how to perform
A SAS user (who lives in the the US) emailed me a question about SAS functions. He was reading UTC (Coordinated Universal Time) datetime values from server logs, and to make future calculations and comparisons easier, he wanted to transform the value to local datetime. The INTNX() function worked great, but
FINALLY…the simplest ESTIMATE statements to write are for continuous variables not involved in interactions or higher order terms. Consider a data set containing the 2004 SAT scores for each of the 50 states. The file includes the combined math and verbal SAT scores (TOTAL), the state (STATE) and the percent
Robert Allison's SAS/GRAPH: Beyond the Basics collects examples that demonstrate a variety of techniques you can use to create custom graphs using SAS/GRAPH software. To celebrate the book’s publication, we asked Robert to tell us more about why he loves SAS/GRAPH. Here’s what he had to say: A graph is
My previous blog demonstrated the most difficult type of ESTIMATE statement to write—a two-way (or higher) ANOVA with interactions. An "easy button" for ESTIMATE statement comes by having a simpler model. Models with only main effects and no interactions make writing ESTIMATE statements straightforward. Consider first a one-way ANOVA. A
Bill Franks’s new book, Taming the Big Data Tidal Wave: Finding Opportunities in Huge Data Streams with Advanced Analytics, has just released. This book shows how big data is changing the world of analytics; what people, processes, technologies, and mindsets are necessary to succeed in analytics in this new era;
How can you go home on time? Take a quick tour with these 5 tips that I was able to summarize for my students in the SAS SQL 1: Essentials class yesterday. Since they found it handy and asked if it could become a blog post, I thought I’d share
