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 14:55, 14 February 2014 by ArtCarpenter (Talk | contribs)

Jump to: navigation, search

Welcome to

A collaborative online community for SAS® users worldwide. is an ongoing global community effort—created by SAS users for SAS users. This site is a place to find answers, share technical knowledge, collaborate on ideas and connect with others in the worldwide SAS Community. Get started now by creating a UserID.

Follow Us
For daily SAS Tips, Web updates & 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

SAS Global Forum Registration Special:

Have you been waiting to register for SAS Global Forum 2014? Wait no longer! Now is the time! For a limited time, from February 14 to Februatry 21 a discounted registration special is being offered. Read more and sign up now at the SAS Global Forum Site.

WANTED: Your SAS User Tips.

Facts about the Tip of the Day project:

  • Anyone can submit a SAS user tip. Just login with your user idea and follow the directions here.
  • A team of SAS users review tips for accuracy. Here is the list under review (feel free to add comments).
  • SAS users have submitted over 275 tips! Browse and search the list.
  • SAS user tips are always welcome. Keep them coming!








Join Get Involved Sasopedia Events User Groups
9,514 UserIds have been created on!
This number will decrease while userid cleanup is in process.
View the Web-site usage statistics and the definition of terms.