As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Category talk:Tip in Use

From sasCommunity
Jump to: navigation, search

Is there a way to tell when a tip was the tip of the day? --JackHamilton 16:49, 6 April 2009 (UTC)


If you look at the History for a tip you should see a comment on what day it was scheduled for. The value shown in the History tab is the summary line from the edit page. We have tried to fill in the value when a tip is sheduled. The vast majority of scheduled tips have that value - but there are a few cases where the value was not quite right. --Don Henderson 17:18, 6 April 2009 (UTC)


Thought that perhaps the new DPL facility could perhaps be used for this. Still need to do some testing, but is this what you were asking about Jack?

%SASDIFF Differential File Comparison Macro
June 21 


ABS Function

October 24 


A free SAS getting-started guide

January 21 


Access Local SAS Directories in SAS/Connect with the INHERITLIB Option

September 23 


Accessing Internet APIs from DS2

September 9 


Accessing multiple location through one library.

September 6 


Accurately Calculate AUC in SAS

July 14 


Adding URL Links to a Web Report Studio Report

May 6 


Adding a User in SAS Management Console

April 16 August 11 


Adding a date and time stamp message to the SAS Log

January 12 


Adding superscripted footnote references to a report

August 25 


Aligning with a Put Function

June 3 


Almost automatic PROC REPORT code generator

July 9 


Alternating Logistic Regression

September 18 


Another Way to Use the SUBSTR Function

May 31 


Anyspace function: search for the carriage return

November 8 


Appending datasets efficiently

August 19 


April 3

Not currently scheduled.


Assign libraries to a path relative to current folder

April 22 


Automatically Separating Data into Excel Sheets

October 14 


Automatically assign Unix environment variables to SAS macro variables

July 25 


Automatically opening Excel workbooks created by the ExcelXP tagset

April 17 August 12 December 23 


BETWEEN does mean between

December 22 


Between and Within Group Counters

March 20 


Bit XOR function in SAS

October 27 


Box Cox Transformation

March 2 


CCC in Proc Cluster

January 6 


Calculate logarithm of any base

September 21 


Calculating Ages

December 7 


Calculating Distance on the map

March 1 


Calculating Exact Age with the YRDIF Function

February 7 


Caution with the TRANWRD Function!

July 5 March 18 November 14 


Change decimal places in PROC FREQ

August 2 December 11 September 27 


Changing FONT color

October 5 


Changing or Suppressing the Default SAS Splash Screen on Windows

August 17 


Changing the Delimiter when Using ODS CSV

February 13 


Changing the SAS Web Report Studio Banner

February 5 


Changing the default prompt on login from SAS/Connect

April 21 


Changing your titles in ODS Content Page

December 16 


Check if a WHERE clause is valid

March 16 


Check if a directory exists

April 14 


Check if a variable exists in a dataset

April 18 


Checking for a data set

November 11 


Clearing a library of data

April 27 


Cochran-Mantel-Haenszel Test using PROC FREQ

September 1 


Compile a Java program with PROC GROOVY

April 24 


Comprehensive list of statistics produced by SAS

February 22 


Compress("") Returns a Zero-Length Character String

October 26 


Controlling text height in titles and footnotes

January 14 


Conversion from Excel Date to SAS Date

February 29 


Convert MISSING to 0

July 12 March 22 November 25 


Corrected Sum of Squares in PROC NLIN

August 30 


Counting Words in a List

November 9 


Counting and miscounting occurrences using SQL

November 6 


Create An Ad-hoc Measure on an OLAP Cube, without the OLAP Administrator

August 1 December 12 


Create a CSV file without column names/headers in row 1

April 9 August 4 December 13 


Create a PROC IMPORT or PROC EXPORT Template Program for Ease of Use

August 21 January 1 


Create a function key to clear the log and output and return to the SAS program

June 1 


Create an Informat from a User-Defined Function

January 30 


Creating Candlestick Chart in SAS

January 19 


Creating ZIP files with ODS

August 6 


Creating a SAS Data Set with Another Operating Systems Data Representation

May 8 


Creating a flag avoiding the If ... Then Structure

July 16 


Creating an Ordered Subset using PROC RANK

July 10 


Creating relative links in ODS HTML

January 7 


Creating your own datetime format

December 15 


Cronbach's Alpha in SAS

May 28 


Ctrl + / is a quick and easy way to comment out SAS code

May 4 


DATA Step Comparison Operators Are Non-Associative

October 25 


Dataset COMPRESS option compresses the size of the SAS dataset

June 9 


Datasets DELETE is Case Sensitive in Excel - but SQL DROP isn't

February 14 


December 22

Not currently scheduled.


Declaring Macro variables on remote host

June 23 


Deduping using Proc Sort

August 24 


Deploying a Custom Add-In Task

July 24 


Derivation of Mathematical Constants in SAS

May 9 


Detailed Directory Listing from PROC CONTENTS

September 4 


Detected Characters For the ANY and NOT Functions

February 8 


Detecting outliers using boxplot

November 15 


Determine Product Release Levels

July 1 


Determine the Location of the Executing Program

May 22 


Determining Nature of SAS Files via their File Extensions

April 12 August 7 December 18 


Determining the Setting of Groups of SAS Options

December 8 July 29 


Determining the number of observations in a SAS data set efficiently
January 22 


Determining the setting of a particular SAS option

July 13 November 26 


Diagnosing authentication issues on Unix

February 23 


Different sorting options for variable names with Proc CONTENTS

January 3 


Displaying a time value as a duration

October 3 


Do not use SAS random numbers for encryption

February 10 


Don't mess up your Data - Option OUTSORT in PROC SURVEYSELECT

October 22 


Double negatives to normalize a boolean value

April 7 


Drawing Lines above/below the Output

August 23 February 19 


Durbin Watson Test in Regression

June 29 


Dynamic ALTLOG or LOG

June 24 


Dynamically Insert and Append SAS Format and Macro Libraries within a SAS Program

August 14 


Easy Way to Get All Variable Names From a Dataset

September 29 


Easy Way to Research SAS System Requirements Across Computer Platforms and Operating Systems

June 12 


Easy way to input date/times that contain an imbeded space

August 27 


Editor Abbreviations

May 30 


Editor Abbreviations in SAS Enterprise Guide

October 9 


Effect coding and class variables in PROC LOGISTIC

March 15 November 7 


Embedding Links in a Title

April 11 December 17 September 26 


Embedding the Flash Version of JMP's Bubble Plot into MS PowerPoint 2007

September 2 


Encrypting script in JMP

February 25 


Enhanced Editor Shortcuts

September 20 


Enterprise Guide - Turning Off the ODS output file creation by code

May 25 


Enterprise Guide Resources

October 21 


Estimate the Size of a Future SAS Data Set

September 15 


Estimating the Size of New SAS Data Sets

November 12 


Execution Time Macro Variable Resolution

December 29 


Exploiting the Metadata in SAS Dictionary Tables and Views

April 10 December 14 


Explore config

April 30 


February 11

Not currently scheduled.


Federal Fiscal Year Date Conversion

May 17 


Find the LAST Non-Missing Value in a List of Variables

April 29 


Finding Multiple Occurrences

October 11 


Finding the Position of the First Non-Digit in a String

May 21 


Forcing all Character Variables when Importing a CSV File

July 6 


Generating random number seed from the system clock

March 25 November 29 


Get Process ID (PID) of SAS Tasks Running on Unix and Linux

March 8 November 2 


Get the Metadata Path for the Currently Running Stored Process

July 18 March 24 November 28 


Getting % sign in PROC TABULATE

September 3 


Getting Model Statistics into SAS data set from PROC LOGISTIC

September 7 


Getting Started with SAS and Hadoop

March 7 


Getting all data and fields information in a directory

May 15 


Gini Coefficient in SAS

June 4 


Give a Presentation at a Local SAS Users Group

July 15 


Great Reference for SAS Functions, Informats, and Formats

December 27 


Handling Transcoding Error

January 25 


Handling trailing and leading blanks in SAS Macro Variable

March 30 


Handy %PUT syntax for mvarName=text output

June 17 


Have you tried the MISSING function yet?

April 13 August 8 December 19 


Heteroskedasticity in Proc Reg

August 29 


Highlighting report cells with no data

April 4 


How to Display values for every row of an Order or Group Report-Item in Proc Report without using an Alias

April 2 


How to add SAS Code on the WIKI

January 9 


How to ask a statistics question

July 4 March 17 November 13 


How to list global macro variables in alphabetical order

June 6 


How to see Recent Changes

November 10 


INFORMAT Modifiers on the INPUT Statement

May 27 


INTNX function with Federal Fiscal Year

June 25 


I want to hear the sound of SOUNDEX

September 12 


Image files that SAS can't load into pdf or rtf documents

February 3 


Images as text - use Base 64 encoding

April 3 


Implement Elastic Net Algorithm in SAS

January 23 


Implement Regularized Discriminant Analysis in SAS

February 6 


Importing a Style Sheet

October 28 


Include Debugging Code in Your Programs

June 10 


Increasing the Size of an Index Page

March 12 November 4 


Index to SAS-L Chance to Make SAS-L History Posts

May 3 


Inheriting Column Attributes (SQL)

August 13 December 24 


Inserting rows in a specified order (SQL)

August 22 January 2 September 25 


Interleaving

April 5 


JMP can enhance Excel usage

February 11 


January 12

Not currently scheduled.


July 3

Not currently scheduled.


July 6

Not currently scheduled.


July 7

Not currently scheduled.


July 8

Not currently scheduled.


July 9

Not currently scheduled.


Jump-start PROC REPORT

January 16 


June 22

Not currently scheduled.


June 24

Not currently scheduled.


K Nearest Neighbor in SAS

May 20 


LIBREF function return value

April 25 


Legend for Proc Univariate Using Annotate

July 17 


Limiting File Download Size Using SAS/Connect
July 27 


Local format using NLS and Locale

January 5 


Macro Language Formatted Look-up

September 10 


Make DATA your friend

August 10 December 21 


Making Macro Variables READONLY

June 22 


Making any repeatable task a file related menu item

December 5 


Map insets

March 23 November 27 


March 16

Not currently scheduled.


March 7

Not currently scheduled.


March 9

Not currently scheduled.


Marketing Research Macros

May 18 


McNemar Statistics

July 23 


Measure SAS Performance with the LOGPARSE SAS Macro

March 29 


Measure Who is Using SAS and What Products They are Using with RTRACE

September 19 


Missing Values in Classification Variables

June 14 


Modifying PDF Bookmark Text

February 16 


Modifying SAS Explorer's "View in Excel"

June 7 


Multiple Dataset Options

May 5 


Multiple Reports Per Page

March 27 November 20 


Music in SAS

April 26 


November 6

Not currently scheduled.


Now You Can Use the IN Operator in a Macro

July 7 


ODS Tip Sheets

August 18 


Obtain the Amount of Computer Memory Available to SAS

December 25 


Order of SAS Operator Evaluation

June 28 


PROC DATASETS Efficiencies

October 17 


PROC SQL Join Algorithms and the METHOD Option

October 4 


PROC TRANSPOSE, using the IDLABEL to label the variable created

October 10 


Page X of Y

October 7 


Plotting Residuals in Linear Regression

July 28 


Pointing to Multiple Report Items On One Define Statement

March 26 November 30 


Pound sign using picture format

November 21 


Predicting events and not non-events in PROC LOGISTIC

September 30 


Program run time

November 19 


Protecting your data with a password

November 18 


Quick Check for Missing or Invalid Data Using Formats

May 16 


Rank of a matrix

May 29 


Read Files From Web Sites Into Your SAS Program

February 28 


Read Zipped Files Directly

April 28 


Reading SAS Data Sets FTP-ed From Other Operating Systems

March 14 


Recent changes

June 16 


Reg Exp Substitution in Proc Format

December 30 


Remotely subset a large dataset

May 1 


Removing License Alias

March 9 


Removing a library reference using the libname function

October 15 


Renaming Variables with suffix

July 30 


Replace Missing Character Values with a Character String

April 19 


Represent numerics as strings with no loss of precision

February 9 


Resolving a macro variable within single quotes

June 26 


Retaining Quotes in a Input statement

July 22 


Retrieving the First Character

August 5 


SAS/Connect Can Upload More Than Just SAS Data Sets

June 13 


SAS Global Forum Idea Request

January 15 


SAS Qualification Tools Ensure SAS is Installed and Operating Correctly

September 17 


SAS TableEditor TagSet

October 30 


SAS can manage your temporary external files

June 18 


SASware Ballot Voting Now Open

November 17 


SPSS Importing Errors

June 27 


SUM Statement and the Implied SUM Function

December 28 


SVD in SAS

October 20 


Sample SAS Data Sets for Developing SAS Programs

August 28 January 11 


Saving Your Work with the SAS Display Manager Autosave Feature

February 1 


Saving some or all of your keyboard macros/abbreviations in one step

April 6 


Schedule SAS Programs with SYSTASK and WAITFOR

January 4 


Searching Options

January 31 


Searching User Group Papers

March 13 November 5 


SecretSQL: Keeping Your Passwords Safe

May 7 


Selecting a Random Sample of Observations

February 15 


September 11

Not currently scheduled.


September 8

Not currently scheduled.


September 9

Not currently scheduled.


Setting Browser Title with the stpbegin macro

February 21 January 17 


Setting Data using Data list

July 20 


Setting Default Values for Macro Parameters

October 12 


Setting Shortcuts for Code Snippet in EG

December 31 


Simple space saving

March 19 November 23 


Simulating Streaming Output in a Workspace Server

February 17 


Sleep Function Under Unix and Linux

January 18 


Sorting a sorted data

August 26 


Sorting an Array in Descending Order

October 16 


Sorting of variables by name inside a data set

May 10 


Spanning Headers in REPORT

April 15 


Specifying a list of variables

May 11 


Specifying directory paths that work on Window and Unix
August 15 


Splitting into one table can be faster

July 3 


Stacking REPORT Headers

December 4 March 31 


Start date: 1st Jan, 1960

October 6 


Starting SAS pointing to a directory of interest

April 20 


Static Dates in RTF Output

August 20 


Strip Blanks from PROC SQL-Created Macro Variable Values

October 18 


Summarize data in a rolling window

April 8 


Suppressing the Batch Dialog when running SAS in Batch Mode

August 16 


Text Indentation and Forced Linefeed (Carriage Return) with the ExcelXP Tagset

March 5 


The SAS Supervisor

May 12 


The SAS XML Mapper

November 16 


This Page Intentionally Left Blank

May 23 


Timekeeping at User Group presentations

December 3 


Tip Sheet for SAS/IML Language

June 19 


Tip Sheets on support.sas.com

March 11 November 3 


Top level directory in web-based STP list

June 20 


Tutorial Dialog in 2nd Base SAS Session

June 8 


Tweak PROC FASTCLUS for closest match lookup

January 28 


Two steps in one with Proc SQL – summarize and create macro variable

July 19 


Unexpected NOTE becomes ERROR

September 22 


Unriddle encoding in SAS Visual Analytics

January 24 


Updating an Excel Table the Excel Libname

October 13 


Use BYVAL to Write Better Titles

October 19 


Use CALL MISSING to Set a List of Variables to Missing

December 2 


Use CATX and IFC to Build a Concatenated List of Treatments

January 20 


Use IS MISSING and IS NULL with Numeric or Character Variables

May 26 


Use PROC SQL to Create SAS Data sets from Excel files

June 30 


Use SAS DM Commands to Save and then Clear Your SAS Log

June 2 


Use SYSRPUT to determine whether a SAS/Connect session failed

December 1 March 28 


Use The HASH Object to Sort Your Data

October 8 


Use The SAS Sample Program Libraries

January 13 


Use X Commands within a SAS Program to Issue Commands to Windows or MS-DOS

May 13 


Use Your SAS Programming Skills in SAS Enterprise Guide

January 29 


Use the BETWEEN-AND Operator to Search an Inclusive Range of Values

September 16 


Use the CONTAINS Operator as an Alternative to the INDEX Function

September 13 


Use the HOLIDAY Function to Compute the Date of a US or Canadian Holiday

June 15 


Use the OBS= Option to Save Time While Testing

October 1 


Use the RESOLVE Function to Build a List into a Macro Variable

July 21 


Use the SOURCE2 Option with %include to Get a Detailed Log

May 19 


Use the TRANSLATE function to validate data

April 23 


Useful Enhanced Editor macros

December 26 


User Specific Autoexecs in Enterprise Guide

October 23 


Using &SQLOBS to report on empty sets

December 9 February 27 


Using ?? in the INPUT Statement

May 14 


Using Date Prompts in Stored Procesess

July 2 


Using GETOPTION to Save and Restore Options

April 1 July 26 


Using IFC to Conditionally Execute Global Statements

March 3 


Using JMP with base SAS

January 8 


Using MSGLEVEL = I

October 2 


Using Multilabel Formats to Expand or Duplicate Data

July 8 


Using NOTE, WARNING, ERROR in Your Program's Generated Messages

November 22 


Using PATHNAME to Retrieve a Physical Path

July 11 March 21 November 24 


Using PROC RANK to Generate Percentiles

February 18 


Using REPLACE and REPEMPTY Together

February 20 


Using SPANROWS To Repeat Values Across Pages

September 24 


Using The Asterisk to Comment Macro Code

February 12 


Using UPDATE to Collapse a Data Set

June 11 


Using formulas in Excel and actual values in HTML and PDF output

December 6 


Using the &SYSUSERID Macro Variable

January 26 


Using the FLYOVER style attribute to display long text strings

February 2 


Using the LOCK Statement for Exclusive Use of a SAS Data Set

October 29 


Using the NOQUOTELENMAX Option

August 31 


Using the PATHNAME Function

February 26 


Using the RENAME Function to Rename SAS Data Sets, Catalogs, OS Files, and Directories

August 3 


Using the SASMSG function for table lookup

May 2 


Using the SAS Stored Process Web Application: Changing the Default/Welcome Page

January 10 


Using the SAS Stored Process Web Application: Securing Your SAS Stored Processes by Limiting Debugging Options

September 5 


Using the SAS V9 CALL SYMPUTX Routine

December 10 July 31 


Using the SYSSCP and SYSSCPL Macro Variables

February 24 


Using the ZIP engine to read zip files

September 11 


Using the sasdemo account in BI/EBI projects

January 27 


Utilize SAS Audit Files to Keep Track of SAS Data Set Updates

October 31 


Validate the format of ICD-9 codes

September 28 


Variable selection in regression

March 10 November 1 


Voice Mining with Text Mining

February 4 


Waiting for LOCKed datasets.

May 24 


Web mining with SAS %TMFILTER macro

September 14 


Weighting in PROC CORR

June 5 


Where also

August 9 December 20 


Where is TEMP

March 6 


Would you like additional capabilities when exporting data to Excel?

September 8 


You can use Google to search sascommunity.org for tips and articles

March 4 


--Don Henderson 21:42, 6 April 2009 (UTC)


That's pretty close, but I think it should include the year as well.

Also, one of the entries seems to create an error, %DPL-1.7.4 ... --JackHamilton 22:11, 6 April 2009 (UTC)

Year is not used as we have 366 Tip of the Day pages for the 366 days of the year (including leap years). So once we get to 2010, we reuse those pages and scheule new tips. This was modeled after the Wikipedia Tip of the Day mechanism - partly so we could leverage all the work done there for scrolling, etc. The Wikipedia site stopped including the year in their process in early 2008. And the error you pointed out is one of the things that needs to be researched/tested. I am learning the template and dpl facilities (in my spare time) in order to support the site. And there are certain special characters that cause problems and trying to determine how to deal with such characters is on the list - but the list is long. --Don Henderson 22:31, 6 April 2009 (UTC)


Found and implemented a fix for the entry that produced the %DPL-1.7.4 ... error. The problem was the '=' sign in the page name. That is now fixed. Not sure what other special characters might be an issue. --Don Henderson 03:26, 21 April 2009 (UTC)


The page Tip in Use was created using DPL similar to the above. That page will replace the category page. This talk page will not be moved however. --Don Henderson 22:14, 24 April 2009 (UTC)