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.
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.
Check out the Tip of the Day page for details about this effort.
MWSUG 2017 Call for Junior Professional Applications
September 19, 2017
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 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.
2017 Green Thumb Award Announced
May 2, 2017
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.
|Join sasCommunity.org||Get Involved||Sasopedia||Events||User Groups|