View as a Web page

SAS® Tech Report SAS
February 2012 support.sas.com  |  subscribe  |  unsubscribe

Dear Readers,

In the January edition, you probably remember that I included some emails from readers - right here in my Editor's Note. That note sparked so much interest that I also posted it to the SAS Users Groups blog. It's quite clear that there are many ways that people can use SAS to accomplish the same thing. In fact, I'd almost say that there is an element of challenge in it for you – when you see a clever way of doing something, perhaps you think to yourself, "I think I can do that without..." Kathryn McLawhorn, Technical Support Analyst at SAS, wrote a very good 2011 SAS Global Forum paper with that thought in mind: Choosing the Road Less Traveled: Performing Similar Tasks with either SAS DATA Step Processing or with Base SAS Procedures .

The key, as McLawhorn writes in her paper, is that each SAS user is working from his or her level of expertise and comfort zone. Here's another example: Angelika Schaffrath Rosario read the November edition and decided to test the %squeeze macro (from Is Your SAS Library a Disk Hog? Here's How to Put it on a Diet) , against a file that she'd already compressed using COMPRESS, an option she prefers. In her case, Rosario said using %squeeze only reduced the file by 5.5 percent.

There are some great opportunities coming your way to discuss your tips and tricks face-to-face with your SAS friends and peers. SAS users events will be starting soon around the globe. Check out the schedule and find a place where you can challenge others to be a better programmer, developer, administrator...

Waynette Tubbs
Editor, SAS Tech Report
What's New
Analytics 2012 »
Join SAS and leading analytics experts in Cologne, Germany for the Analytics 2012 Conference Series, June 14-15. Register by February 29 and save up to €300!"
How to Access SAS Sample Programs »
Have you ever wanted to run a sample program from the SAS documentation or wanted to use a data set that appears in the SAS documentation? You can: All programs and data sets in the documentation are distributed with SAS - you just have to know where to look!
Export to Excel 2010 Just Got a Little Bit Easier »
This Chris Hemedinger Twitter message intrigued me, so I clicked on his link: "'ERROR: XLSX is not yet supported by proc export' - that message is SO last year. Meet SAS 9.3M1." It seems that a new capability - improved XLSX support in PROC EXPORT - has made it into this SAS® 9.3 maintenance release. Check it out!
[VIDEO] Writing SAS Code in the New SAS Enterprise Guide Editor »
A common misconception is that SAS Enterprise Guide is for point-and-click users who need to have code generated for them. Although that is a powerful (and very cool) part of the software, you may be missing out on some of the most amazing features included in the SAS Enterprise Guide programming editor.
Tips & Techniques
Understanding the Anatomy of a SAS® Deployment »
Wondering how installing your new SAS Business Intelligence software will fit into your already busy schedule? No problem! Mark Schneider, Director R&D, Deployment at SAS, has put together a great video and PowerPoint presentation to help you out.
How to Clear the Output Window in SAS 9.3 »
One of the most  visible changes in SAS 9.3 is that the default LISTING destination no longer defaults to ODS output. Instead, the default destination is HTML. With a new destination comes a new method for clearing the output window.  Rick Wicklin’s post provides screen shots and example code making the new method clearly understandable.
Read HTML Data into SAS® With This Macro »
In this paper, Rick Langston describe a SAS program that reads an arbitrary HTML stream and create a separate SAS data set for each TABLE definition in the stream.
How to Define a Library for Use with SAS® Marketing Automation Exports »
Create a Function to Calculate the Weekday Starting with Monday »
Use PROC FCMP to create a function that calculates the weekday starting with Monday instead of Sunday. User-defined functions and subroutines created by PROC FCMP can be used in the DATA Step beginning in SAS 9.2.
Training
Four Reasons to Attend SAS Training at SAS Global Forum »
There's a lot of talk about staying for the magic of Disney World after SAS Global Forum. But, some of the most popular SAS training courses are being offered April 18-20 – prior to the conference. Here are some reasons SAS users have said they like arriving early.
[VIDEO] SAS OnDemand for Professionals »
What is SAS OnDemand for Professionals? Take this video guided tour to understand the value.
Jedi SAS Tricks: These Aren't the Droids ... Ep 1 »
The power of the Force makes ridding yourself of problematic characters so much easier! Learn about the COMPRESS function with the latest Jedi SAS trick from SAS Training Instructor, Mark Jordan.
Webcasts & Events

Customer Segmentation Made Simple

March 9



PharmaSUG 2012
May 13-16
San Francisco, CA
Registration is open!  

SAS Global
Forum 2012

April 22-25
Orlando, FL
Registration open! 
SAS Users Connecting
IFSUG Summit »
The Insurance and Finance SAS Users Group Summit is a great place to interact with friends and peers who not only know SAS, but also understand our economic situation, regulatory challenges and the technological hurdles we face. Check out the summit and the users group.
Unofficial Official Guide to SAS Global Forum »
Where are you getting info about what to see and do while you're in Orlando in the spring? Sara Jones and her fellow bloggers are writing a series of posts that include tips to get your boss to say yes, where to stay, how to get reduced amusement park tickets and more. Subscribe to get all of their cool tips and tricks!
Resources
Peek Inside SAS BI Book: Building Business Intelligence with SAS® »
Angela Hall and Tricia Aanderud have co-authored a SAS Business Intelligence book. Aanderud's blog post gives you a great look inside – before you buy: It's like thumbing through the book in the bookstore!
Quick Clicks

Tech Support »

SAS Global Forum »

Users Groups »

sasCommunity.org »

SAS Focus Areas »

SAS Samples »

Discussion Forums »

Key Happenings in SAS Online Support »
Support
Technical Support
E-newsletter Archives »
Technical Problems »
E-mail Address Changes »
Don't miss important updates from SAS! Please add sas.com as a domain
in your safe sender list.
Your Subscription
We hope that you enjoyed reading this e-newsletter. However, if you would rather not receive SAS e-newsletters in the future, return to our e-newsletter subscriptions site to log in and edit the subscription options in your profile.
 
Privacy Statement


To contact SAS via postal mail: SAS, SAS Campus Drive, Cary NC 27513 USA. ATTN: Legal Division/Privacy Manager.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks
of SAS Institute Inc. in the USA and other countries. ® indicates USA registration. Other brand and
product names are trademarks of their respective companies.

Copyright © SAS Institute Inc. All rights reserved.