• Proc SQL requires few lines of SAS code compared with datastep and or Proc steps
• Frequency counting can be done in no time… which is very helpful during the QC or...
Read more »
It's Friday, and on SAS Voices they are posting fun stuff about dogs who work at SAS. I'm posting about PROC SQL and MySQL. You tell me - which of us knows how to ring in the weekend with style? I've been working with...
Read more »
SQL syntax contains a few set operators, such as UNION, EXCEPT and INTERSECT. The UNION operator concatenates the results of multiple SQL queries vertically into a single table for all matching rows, which I found particularly useful in PROC SQL while...
Read more »
One of the best things about attending the SAS Global Forum is all the brilliant people you get to meet. Guy Garrett’s presentation about planning a BI strategy was quiet popular and I have to say he was very witty. Turns out implementing a...
Read more »
SAS stored processes are similar to SAS programs in that they use the same programming language. Many of my SAS programs I created early on were only used by me, so I could live with a little uncertainty and it was easy enough to...
Read more »
I've been a fan of statistical simulation and other kinds of computer experimentation for many years. For me, simulation is a good way to understand how the world of statistics works, and to formulate and test conjectures. Last week, while investigating the efficiency of...
Read more »
SAS users, by definition, do not embrace the mysterious. That's one of the main reasons that they use SAS: to demystify some data or process. And so, when you (as a SAS user) have gone to the trouble of designing a process flow in...
Read more »
~ Contributed by Lelia McConnel, Technical Support Consultant, SAS ~ Base SAS 9.3 has made creating high quality graphics output easier than ever. Did you know that you can create great looking, high resolution graphs with Base SAS? The Customer Suppor...
Read more »
In example 9.30 we explored the effects of adjusting for multiple testing using the Bonferroni and Benjamini-Hochberg (or false discovery rate, FDR) procedures. At the time we claimed that it would probably be inappropriate to extract the adjusted p-v...
Read more »