Main Page

From sasCommunity
Jump to: navigation, search

Welcome to sasCommunity.org

A collaborative online community for SAS® users worldwide.

sasCommunity.org 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

libname pclib "C:\TEMP";
rsubmit inheritlib=(pclib);
proc summary nway data=pclib.shoeaud(where=(region="Canada"));
   class region product subsidiary;
   var   sales  returns;
   output out=sumshoes sum=;
   run;	
endrsubmit;
run;

Did you know that using SAS/CONNECT, you can have a program running on a server "reach back" and process data directly from a SAS data set on your client machine (workstation)? The aptly-named INHERITLIB (SAS 9.2) option allows a remotely-running SAS program to process data from your workstation or network as if it were local to the remote server. Using the INHERITLIB option obviates the need for you to use PROC UPLOAD to send your data to the remote server for processing. That can be handy when you do not want to have multiple copies of a data set spread across your various computing platforms.

The INHERITLIB option can be coded on either the RSUBMIT or the SIGNON statement. See the example at right where we are allocating the "C:\temp" directory to the "PCLIB" libref in our local SAS session. Thereafter, we RSUBMIT a simple PROC SUMMARY that will run on our Linux server. The RSUBMIT statement specifies that the remote session is to "inherit" the PCLIB libref. So, when the SUMMARY procedure executes on the remote Linux server, it "reaches back" to the workstation and drags the relevant observations across the network to the waiting SUMMARY procedure running on the Linux server. Pretty neat, eh?

Of course, you need to weigh any additional network traffic associated with remote servers processing local data against any gains realized by using the INHERITLIB option. But you already knew that, didn't you?!

Submitted by Michael A. Raithel, The man who wrote the book on performance. 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

MWSUG 2017 Call for Junior Professional Applications

September 19, 2017

MWSUG Junior Professional Applications

Junior Professionals
Are you wanting to attend the 2017 MWSUG conference in St. Louis? We are offering you the chance to attend at the discounted price of $495, and 2-nights of your stay will be covered.

Don't miss this opportunity to join fellow SAS professionals to sharpen your SAS skills.

In order to be eligible you must be a full-time employee using SAS in your daily work for less than four years, and participate at MWSUG as a volunteer.

If interested please contact Cindy Wilson at Scholarships@mwsug.org .













SAS Global Forum 2018 Call for Content is Open

September 13, 2017

SAS Global Forum 2018 Call for Content

SAS Global Forum 2018 is now accepting content submissions!


Your ideas – they have the potential to make a big impact. So why not share them? Consider presenting your know-how at the premier conference for SAS® users – a conference that draws more than 5,000 professionals from around the world.

  • Highlight your insights
  • Highlight your experience
  • Share what you have learned - others are learning too

Another reason to submit
Did you know you can get published? If your submission is selected, you’ll have the opportunity to publish your paper in a journal – if your topic is about analytics, business intelligence or business analytics.

Need help with your topic?
We have a mentor program designed with you in mind. So if you need a little help bringing your idea to life, our experienced mentors will help you do just that.

Learn more about submitting your ideas here.



2017 Green Thumb Award Announced

May 2, 2017

2017 Green Thumb Award

Congratulations Paul Kaefer




Who is Contributing to sasCommunity

Apr 17, 2014
Check out the User Contribution Scores page to see who is contributing content or editing content on sasCommunity.


Browse the history of What's New announcements.



Blogs

 

Content

 

Tips

 

Forums



Join sasCommunity.org Get Involved Sasopedia Events User Groups
9,416 UserIds have been created on sasCommunity.org!