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.

Click here to submit a tip.


A free SAS getting-started guide - January 21 

Accurately Calculate AUC in SAS - February 17 

Adding a User in SAS Management Console - April 16 August 11 December 22 

Adding superscripted footnote references to a report - August 25 January 6 

Alternating Logistic Regression - February 7 May 21 September 18 

Anyspace function: search for the carriage return - June 29 November 8 

Appending datasets efficiently - August 19 December 30 

Automatically Separating Data into Excel Sheets - October 14 

Automatically opening Excel workbooks created by the ExcelXP tagset - April 17 August 12 December 23 

Bit XOR function in SAS - June 18 October 27 

Box Cox Transformation - March 2 

Calculating Ages - April 4 December 7 July 28 June 3 October 3 

Caution with the TRANWRD Function! - July 5 March 18 November 14 

Change decimal places in PROC FREQ - April 7 August 2 December 11 May 28 September 27 

Changing FONT color - June 5 October 5 

Changing or Suppressing the Default SAS Splash Screen on Windows - February 11 May 11 September 11 

Changing the SAS Web Report Studio Banner - February 5 May 19 September 16 

Changing your titles in ODS Content Page - December 16 

Checking for a data set - July 2 November 11 

Comprehensive list of statistics produced by SAS - February 22 

Controlling text height in titles and footnotes - August 31 February 20 January 14 May 2 

Convert MISSING to 0 - July 12 March 22 November 25 

Counting Words in a List - June 30 November 9 

Create An Ad-hoc Measure on an OLAP Cube, without the OLAP Administrator - April 8 August 3 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 - April 24 August 21 January 1 

Creating Candlestick Chart in SAS - January 19 

Creating a SAS Data Set with Another Operating Systems Data Representation - January 30 May 8 September 7 

Creating relative links in ODS HTML - January 7 

Creating your own datetime format - December 15 

Deploying a Custom Add-In Task - December 3 July 24 March 30 

Detailed Directory Listing from PROC CONTENTS - January 20 May 5 September 4 

Detected Characters For the ANY and NOT Functions - February 8 

Detecting outliers using boxplot - July 6 November 15 

Determining Nature of SAS Files via their File Extensions - April 12 August 7 December 18 February 15 

Determining the Setting of Groups of SAS Options - April 3 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 March 20 November 26 

Diagnosing authentication issues on Unix - February 23 

Do not use SAS random numbers for encryption - February 10 

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

Drawing Lines above/below the Output - April 26 August 23 February 19 January 3 

Easy Way to Get All Variable Names From a Dataset - September 23 

Easy Way to Research SAS System Requirements Across Computer Platforms and Operating Systems - June 12 October 18 

Editor Abbreviations - May 30 September 29 

Editor Abbreviations in SAS Enterprise Guide - October 9 

Effect coding and class variables in PROC LOGISTIC - June 28 March 15 November 7 

Embedding Links in a Title - April 11 August 6 December 17 May 27 September 26 

Encrypting script in JMP - February 25 

Enhanced Editor Shortcuts - May 23 September 20 

Enterprise Guide Resources - October 21 

Estimate the Size of a Future SAS Data Set - May 16 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 August 5 December 14 

Finding Multiple Occurrences - June 7 March 4 October 11 

Generating random number seed from the system clock - July 19 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 all data and fields information in a directory - February 13 May 15 September 14 

Gini Coefficient in SAS - June 4 October 4 

Give a Presentation at a Local SAS Users Group - May 20 September 21 

Great Reference for SAS Functions, Informats, and Formats - April 21 August 16 December 27 

Handling Transcoding Error - January 25 

Have you tried the MISSING function yet? - April 13 August 8 December 19 

Heteroskedasticity in Proc Reg - April 30 August 29 January 12 

How to add SAS Code on the WIKI - August 26 January 9 

How to ask a statistics question - July 4 March 17 November 13 

How to see Recent Changes - July 1 November 10 

I want to hear the sound of SOUNDEX - February 3 May 13 September 12 

Importing a Style Sheet - June 20 March 7 October 28 

Include Debugging Code in Your Programs - June 10 October 16 

Increasing the Size of an Index Page - June 25 March 12 November 4 

Inheriting Column Attributes (SQL) - April 18 August 13 December 24 

Inserting rows in a specified order (SQL) - April 25 August 22 January 2 May 26 September 25 

Jump-start PROC REPORT - January 16 September 1 

Limiting File Download Size Using SAS/Connect - April 2 December 6 July 27 

Local format using NLS and Locale - January 5 

Make DATA your friend - April 15 August 10 December 21 


Map insets - July 17 March 23 November 27 

Measure SAS Performance with the LOGPARSE SAS Macro - December 2 July 23 March 29 

Measure Who is Using SAS and What Products They are Using with RTRACE - May 17 September 19 

Missing Values in Classification Variables - June 14 March 6 October 19 

Modifying PDF Bookmark Text - February 16 

Multiple Reports Per Page - July 21 March 27 November 20 

ODS Tip Sheets - August 18 December 29 

Obtain the Amount of Computer Memory Available to SAS - April 19 August 14 December 25 

Order of SAS Operator Evaluation - March 1 

PROC DATASETS Efficiencies - June 11 October 17 

PROC TRANSPOSE, using the IDLABEL to label the variable created - June 6 October 10 

Page X of Y - October 7 

Pointing to Multiple Report Items On One Define Statement - July 20 March 26 November 30 

Pound sign using picture format - July 9 November 21 

Predicting events and not non-events in PROC LOGISTIC - May 31 September 30 

Program run time - November 19 

Protecting your data with a password - November 18 

Read Files From Web Sites Into Your SAS Program - February 28 May 25 September 24 

Reading SAS Data Sets FTP-ed From Other Operating Systems - June 27 March 14 November 6 

Recent changes - June 16 October 25 

Removing a library reference using the libname function - October 15 

Represent numerics as strings with no loss of precision - February 9 

SAS Global Forum Idea Request - January 15 

SAS Qualification Tools Ensure SAS is Installed and Operating Correctly - February 6 May 18 September 17 

SAS TableEditor TagSet - June 22 March 9 October 30 

SAS/Connect Can Upload More Than Just SAS Data Sets - June 13 March 5 October 24 

SASware Ballot Voting Now Open - November 17 

SUM Statement and the Implied SUM Function - April 22 August 17 December 28 

SVD in SAS - October 20 

Sample SAS Data Sets for Developing SAS Programs - April 29 August 28 January 11 

Schedule SAS Programs with SYSTASK and WAITFOR - April 27 August 24 January 4 

Searching Options - January 31 May 9 September 8 

Searching User Group Papers - June 26 March 13 November 5 

SecretSQL: Keeping Your Passwords Safe - January 24 May 7 September 6 

Setting Browser Title with the stpbegin macro - February 21 January 17 May 3 September 2 

Setting Default Values for Macro Parameters - June 8 October 12 

Simple space saving - July 10 March 19 November 23 

Sleep Function Under Unix and Linux - January 18 May 4 September 3 

Specifying directory paths that work on Window and Unix - February 1 May 10 September 9 

Stacking REPORT Headers - December 4 July 25 March 31 

Start date: 1st Jan, 1960 - October 6 

Static Dates in RTF Output - August 20 December 31 

Suppressing the Batch Dialog when running SAS in Batch Mode - February 2 May 12 September 10 

The SAS XML Mapper - July 7 November 16 

Tip Sheets on support.sas.com - June 24 March 11 November 3 

Tweak PROC FASTCLUS for closest match lookup - January 28 

Updating an Excel Table the Excel Libname - June 9 October 13 

Use SYSRPUT to determine whether a SAS/Connect session failed - December 1 July 22 March 28 

Use The HASH Object to Sort Your Data - October 8 

Use The SAS Sample Program Libraries - August 30 January 13 May 1 

Use Your SAS Programming Skills in SAS Enterprise Guide - January 29 

Use the HOLIDAY Function to Compute the Date of a US or Canadian Holiday - June 15 October 26 

Use the OBS= Option to Save Time While Testing - June 1 October 1 

Use the TRANSLATE function to validate data - April 23 

Useful Enhanced Editor macros - April 20 August 15 December 26 

User Specific Autoexecs in Enterprise Guide - October 23 

Using &SQLOBS to report on empty sets - April 6 December 9 February 27 July 30 May 24 September 22 

Using ?? in the INPUT Statement - February 4 May 14 September 13 

Using GETOPTION to Save and Restore Options - April 1 December 5 July 26 

Using IFC to Conditionally Execute Global Statements - March 3 

Using JMP with base SAS - January 8 

Using MSGLEVEL = I - February 14 June 2 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 The Asterisk to Comment Macro Code - February 12 

Using the &SYSUSERID Macro Variable - January 26 

Using the LOCK Statement for Exclusive Use of a SAS Data Set - June 19 October 29 

Using the PATHNAME Function - February 26 

Using the SAS Stored Process Web Application: Changing the Default/Welcome Page - April 28 August 27 January 10 

Using the SAS Stored Process Web Application: Securing Your SAS Stored Processes by Limiting Debugging Options - January 23 May 6 September 5 

Using the SAS V9 CALL SYMPUTX Routine - April 5 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 - June 17 October 31 

Validate the format of ICD-9 codes - May 29 September 28 

Variable selection in regression - June 23 March 10 November 1 

Where also - April 14 August 9 December 20 


Personal tools