Reading in Exotic Locations

August 20, 2008
By

This post was kindly contributed by Key Happenings at support.sas.com - go there to comment and to read the full post.

As August draws to a close and school systems all over the country are calling students back to their desks, I can’t help but daydream about lavish vacation spots with warm breezes and cool blue water. But, this post isn’t about vacationing. It is about finding information in out-of-the-way places. These sites aren’t hidden or hard to find, they just exist on a different path than you usually take to your content. I’d like to introduce you to just a few things I found in places that I recently discovered.

Discovery 1
This is a tip from Kirk Paul Lafler that was published in the SESUG spring 2008 e-Newsletter.
Title:    PROC SQL Join Algorithms and the _METHOD Option


PROC SQL _METHOD;
SELECT MOVIES.TITLE, RATING, ACTOR_LEADING
FROM MOVIES,
ACTORS
WHERE MOVIES.TITLE = ACTORS.TITLE;
QUIT;

Read the tip to find out what this code can be used for.

Discovery 2
Here’s a quick tip from the SAS UK office that appeared in their April In The Know e-Newsletter.
Question:    Is there a way to check the syntax of a step prior to executing the step?
Answer:    Yes, use the option ‘Cancel’ on the ‘Run’ statement. The CANCEL option terminates the step without executing it and prints a warning message that the step was not executed at the user’s request.
Read the tip for example code.

Discovery 3
One last tip for you from the SAS Programmers group on Facebook. This tip was posted by Elinor Jane Leland Zenta, who wrote:

In the SAS window click tools => options => keys
In the F12 spot (which should be empty) type in
output;clear;log;clear;wpgm;submit
When you run your programs press F12 which will clear your log and output windows and submit your program.

Share your discoveries
Do you visit a location that others may not know about? If so, take a minute to share the location with the Support News blog readers by posting a comment below. Alison Bolen shared several lists of Web addresses that might be of interest to SAS professionals. You can view her list of Online communities for SAS users and SAS professionals in the sascom voices blog.

This post was kindly contributed by Key Happenings at support.sas.com - go there to comment and to read the full post.

Tags: ,

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

Sponsors







Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com
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.