SasCommunity Tip of the Day RSS

From sasCommunity
Jump to: navigation, search

Tip of the Day:Submitting a Tip
It's easy to submit Tip of the Day for sasCommunity!

  • First, type a title in the box at right. Type after "Tips:" prefix. Be sure to pick a descriptive name for your Tip.
  • Click Submit a Tip to use the template.
  • Start writing. That's it!
Example, Tips:Your Tip and Tips:Your Other Tip

Tip: Avoid using punctuation characters, e.g., periods, question marks, and so on, as the last character of your article name. And please also review sasCommunity:Titles for some best practices on article titles.

Your Tip will be reviewed by the sasCommunity team and then scheduled for publishing.
*Note: you must log-in or create a sasCommunity UserID first

Attention All Tipsters

We've changed the Tip of the Day template to make it easier to use and so that it provides a direct link to your user page (where your points/status is shown). That new template works for tips submitted from this point forward. For previously submitted Tips, there is no way to automatically update them. But you can update your tips and earn 100 points by simply updating your Tip pages. Simply replace the following text:

{{SubmittedBy|....|........}}
   with   
<div style="float:right">Submitted By ~~~</div>

To access all of your tips:

  • click on my contributions in the upper right corner of the browser window
  • select the Tips namespace
  • select Search

to get a list of all of the tips you contributed to. But please only update those that you actually created.

More Details

See this Screen Shot as an Example:

Tips.jpg

Click image to enlarge

Important Tip of the Day Submission Guidelines:

  • Do a bit of searching. Start with the list of tips which have already been proposed. Even if there is no pre-existing tip, there may already be an article on the topic which can be cited or expanded upon.
  • Replace "INSERT YOUR TEXT HERE" in the template with your tip.
  • Replace other upper case text with the appropriate details for your tip.
  • Use plain text (no WIKI or HTML formatting).
  • Do not change or delete any other text in the template.
  • Keep Tips short (no more than a couple of sentences).
  • Link to another internal page or external Web site to provide more details if needed.
  • Remember to save your work by clicking the template's Save Page button!
  • Make sure to include any appropriate category tags. Take a look at the Sasopedia pages to get a sense for what categories might be appropriate.
  • Make sure you are watching the page and that your preferences are set to notify you when someone comments on your submitted tip.

Tip of the Day:January 3

sasCommunity Tip of the Day

When writing programs, SAS ignores the case of variable names. However when it comes to display the variables names, say with Proc CONTENTS, then the case does matter for the sorting of the variable names.

Proc CONTENTS provides the ORDER= option to sort the variable names in different ways. See the code sample below on how the ORDER= option affects the variable name sorting.

data work.myvars;
  length 
    Aa aa2 aa1 Aa10
    Bb bb2 bb1 Bb10
    Zz zz1 Zz10
    $ 8
  ;
run;
title "variables names sorted with the default";
ods select variables;
proc contents data=work.myvars;
run;
 
title "variables names sorted with order=ignorecase";
ods select variables;
proc contents data=work.myvars order=ignorecase;
run;
 
title "variables names sorted with order=casecollate";
ods select variables;
proc contents data=work.myvars order=casecollate;
run;



Submitted By Md4



Feel free to comment on this tip.


[[Tip of the Day:Error: Invalid time.|Prior tip]] - [[Tip of the Day:Error: Invalid time.|Next tip]] - Random Tip

Submit a Tip


Tip of the Day:January 1

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.


[[Tip of the Day:Error: Invalid time.|Prior tip]] - [[Tip of the Day:Error: Invalid time.|Next tip]] - Random Tip

Submit a Tip