As the first step in the decommissioning of the site has been converted to read-only mode.

Here are some tips for How to share your SAS knowledge with your professional network.

Main Page

From sasCommunity
Revision as of 09:13, 28 October 2009 by LainieH (Talk | contribs)

Jump to: navigation, search  A collaborative online community for SAS® users worldwide. . . Learn More

sasCommunity Tip of the Day

Sometimes, programmers have to resort their data again in order to use it for subsequent processing even though the system has detected the data as sorted. This need to resort may be due to some weird errors on the index created by the user or in a situation where SAS was not able to verify the sort done previously. This error can also occur if the data was sorted using a collating sequence different from the current one.

A possible use for the FORCE function is to achieve deduplication of certain sorted fields in data which can be found in the link below.

To address such issues, use the FORCE command in PROC SORT.

proc sort data = <data> FORCE;
    by X1 X2 ... XN;

SUGI Paper

Submitted by Murphy Choy. Contact me at my Discussion Page.

Feel free to comment on this tip.

Prior tip - Next tip -- Random Tip

Submit a Tip

Check out the Tip of the Day page for details about this effort.

What's New

Introducing what's new on

SAS Programmer
Let Michael know he's not alone
It's not easy being a SAS Programmer! That's the subject of SAS Author Michael A. Raithel's talk as the Featured Lunchtime Speaker for SAS Global Forum 2010. He hopes you'll join him.

In the meantime, Michael invites you to share your own comments or amusing anecdotes on what you find challenging about being a SAS programmer.
  • The Sasopedia is undergoing updates to make it easier to use and navigate. Visit the Sasopedia to find and contribute to frequently asked questions (FAQs) on using SAS.

9,514 UserIds have been created on!
View the Web-site usage statistics and the definition of terms.
Join Get Involved Sasopedia Events User Groups