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

You don't have to memorize the exact syntax and all of the options of PROC EXPORT or PROC IMPORT, or go fumbling for the documentation every time you need to use them. Instead, create a PROC EXPORT template and a PROC IMPORT template for yourself using the wizards in SAS Display Manager. Then, copy and modify either template in your programs to suit your particular needs.

In SAS Display Manager, select: <File>, then <Export Data>. Choose the SASHELP.CLASS SAS data set just to have something to work with. Then, go through all of the subsequent windows, choosing all of the available options. When you get to the window that states:

The EXPORT wizard can create a file containing PROC EXPORT commands that can be used in SAS programs to export this data again. If you want these statements to be generated, enter the filename where they should be saved.

...simply choose a directory and then a meaningful program name, such as "Export to Excel Template.sas". When you click <Finish>, you will have a SAS program that looks something like this:

PROC EXPORT DATA= SASHELP.CLASS
            OUTFILE= "C:\Documents and Settings\RAITHEL_M\SAS Class.XLS" 
            DBMS=EXCEL LABEL REPLACE;
     RANGE="SAS Class"; 
     NEWFILE=YES;
RUN;

You can reverse this process with the Import Data wizard to create a PROC IMPORT template.

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

Western Users of SAS Softward Conference in Long Beach, CA

August 8, 2017

Western Users of SAS Software

Early registration ends August 21, 2017
Join us Sept. 20-22 at the Hyatt Regency Long Beach in sunny Long Beach, California!
Register now for the best deal!

Register by Aug. 21 to take advantage of our lowest prices of the season!

Sharpen Your SAS® Skills!
Attending WUSS 2017 will provide you with access to SAS experts, authors, presentations, tutorials, demos, workshops and training seminars. There is something for everyone from beginner to expert!

  • Presentations from SAS
  • Eleven academic sections ranging from Beginner’s Techniques to Industry Solutions
  • More than 100 presentations, posters, panels and hands-on workshops

SAS® Essentials Workshop
Taught by Susan Slaughter (co-author of The Little SAS Book) – No extra fee!

  • How SAS Thinks: SAS Basics I
  • Introduction to DATA Step Programming: SAS Basics II
  • Introduction to SAS Procedures: SAS Basics III




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,386 UserIds have been created on sasCommunity.org!