Tip in Use

From sasCommunity
(Redirected from Category:Tip in Use)
Jump to: navigation, search

An alphabetical listing of Tips that have already been scheduled for use, along with the date(s) that they were used are listed below:

Search Tips:

Click Here to Submit a Tip.



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 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 December 22 

Adding superscripted footnote references to a report - August 25 

Aligning with a Put Function - June 3 

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 December 30 

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 and Within Group Counters - March 20 

Bit XOR function in SAS - October 27 

Box Cox Transformation - July 16 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 - September 11 

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 directory exists - April 14 

Check if a variable exists in a dataset - April 18 

Checking for a data set - July 2 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 - June 30 November 9 

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 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 

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 - July 6 November 15 

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 

Dynamically Insert and Append SAS Format and Macro Libraries within a SAS Program - September 8 

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 - July 3 March 16 November 12 

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 

Generating random number seed from the system clock - March 25 November 29 

Get Process ID (PID) of SAS Tasks Running on Unix and Linux - June 21 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 - August 16 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 January 12 

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 - July 1 November 10 

INFORMAT Modifiers on the INPUT Statement - May 27 

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 - June 25 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 

Jump-start PROC REPORT - January 16 

K Nearest Neighbor in SAS - May 20 

LIBREF function return value - April 25 

Limiting File Download Size Using SAS/Connect - July 27 

Local format using NLS and Locale - January 5 

Make DATA your friend - August 10 December 21 


Making any repeatable task a file related menu item - December 5 

Map insets - July 17 March 23 November 27 

March 7 - 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 

ODS Tip Sheets - August 18 December 29 

Obtain the Amount of Computer Memory Available to SAS - August 14 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 - July 9 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 November 6 

Recent changes - June 16 

Remotely subset a large dataset - May 1 

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 

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 - June 22 March 9 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 - August 17 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 - June 26 March 13 November 5 

SecretSQL: Keeping Your Passwords Safe - May 7 

Selecting a Random Sample of Observations - February 15 

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 

Simple space saving - July 10 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 - September 9 

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 December 31 

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 - September 10 

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

The SAS Supervisor - May 12 

The SAS XML Mapper - July 7 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 - June 24 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 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 - August 15 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 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 NOTE, WARNING, ERROR in Your Program's Generated Messages - July 8 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 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 - June 23 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 

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