General A Simple Technique for Outputting a Data Set to a CSV File Controlling Print Settings Within a Windows Environment Syntax Checking Turning off Autoscroll to improve run times Getting Previous Values of the Same Variable Referencing BY group values within Titles Removing Procedure Titles The COMPBL Function for Compressing Embedded Blanks Sorting variable names alphabetically Dealing with duplicate keys Dates in foreign languages Want your reports to reflect the actual date/time they were printed? SAS for… The power of SYMBOLs Testing conditions efficiently Get the length right You may very well think that… they’re a waste of time, but I couldn’t possibly not comment! Beware of the “<>”! Using Boolean values for variables Using SELECT-WHEN-END WHERE as an output data set option The versatile colon NOMISSINGCHECK option when using UPDATE Moving Data Proc FCMP for Scrabble Useful Library Reference Names Useful Functions When Comments Go Bad *NEW* Maximum display size for graphics *NEW* Displaying absent combinations of classification variables *NEW* Excel functions in SAS 9.2 *NEW* Using Proc SUMMARY to Produce Multiple Tables with Varying Statistics *NEW* How will interest changes affect your mortgage payment? *NEW*
Formats Creating an Output Data Set from a Format Including an existing format within a format definition Reserved words for Proc Format Handling case with an informat Two nations divided by uncommon date formats How do I build a format from a dataset? Use multiple formats on a single column Vector-valued formats with SCAN Rounding Your Formats *NEW*
Proc SQL Proc SQL Merge Outputting a List Of Values from a Data Set to a Macro Variable Outputting a List Of Values to a Series of Macro Variables How to improve SQL merges Regular expressions in Proc SQL *NEW*
Macro Outputting macro generated code to a file using MPRINT Viewing The Values Of All Current Macro Variables Deleting Macro Variables Macro loops by month How to pass a varying list of parameters to a macro Stored macros – Where’s the source? Macros to handle lists The PLOTIT macro Using the MPRINTNEST Option Conditionals in macros *NEW* SAS Macro for Undoing a PROC APPEND *NEW*
System Settings Change your default file path Creating an external file in the SAS workspace The USER library