Home

SAS Global Forum 2012 Attendees

Please visit this page for more information about the following papers:
  • An Advanced, Multi-Featured Macro Program for Reviewing Logs
  • Standardized Macro Programs for Macro Variable Manipulation
Welcome to my SAS macros sharing site! The best way to explore the macros available here is to search the site or review the categories.

The macros on this site were developed using SAS 9.1.3 and 9.2 on Windows. Many may work on non-Windows platforms. Before using any macro in production, please review the code, check for dependencies, and test the macro for compatibility within your system.

Feel free to contact me if you have any questions or feedback regarding these macros.

Categories

Documentation

  • Arguments - The header of each macro contains a list of arguments and a short description of the argument. Additionally, most arguments are validated as required, specific values, or criteria specific to the macro.
  • Documentation - Notes on some of the macros regarding the reasons behind the process.
  • Headers - Each macro contains a standard header section with metadata, including author, creation date, purpose, revisions, and arguments.
  • Feedback - Feel free to send me feedback, comments, questions, or even macro revisions!

Subscriptions

Subscribe to updates to all of the SAS macros on this website.

Downloads

Use Now

The following code will allow users to run a specified macro immediately in the current SAS session. The following examples use ObsMac. Replace "ObsMac" with the desired macro.

/* Download SiteMacros macro */
filename code url "http://goo.gl/j6QhS";
%include code / nosource;
filename code clear;
%SiteMacros(ObsMac);
To save a macro in an autocall library:
 
%SiteMacros(ObsMac, type=save, lib=macros);

Alternatively, to store a macro in a compiled macro catalog:
 
%SiteMacros(ObsMac, type=store, lib=macros);

Recent Updates

  • TransMerge.sas   11k - Apr 3, 2012, 7:53 AM by Chris S. (v3)
    ‎Transpose all columns in a data set, based on by variable(s) and an ID variable (for PROC TRANSPOSE), and re-merge all the columns back into one data set. The names of the columns are set to the original name as a prefix, with the ID added at the end, and an optional suffix.‎
  • LengthCheck.sas   4k - Feb 3, 2012, 9:45 AM by Chris S. (v1)
    ‎Output the maximum lengths for variables in a data set.‎
  • Freqs.sas   9k - Feb 16, 2016, 2:34 PM by Chris S. (v5)
    ‎Output frequencies for all variables in a data set, sent to one master data set.‎
  • TextID.sas   4k - Feb 3, 2012, 9:40 AM by Chris S. (v7)
    ‎Convert a (completely) text value to an ID that will be the same for the specific text each time it is run. This process can be valuable for adding an ID to a text value when no ID exists, and the same ID is needed for the same text values and each time it is run.Note that the macro is case sensitive, so if upper- and lower-case text need to have the same ID, the input data set should be modified first. The macro converts the text to its binary representation then sums up the numeric value for the entire field.Warning: If the input value contains numbers, it is possible the output may not be distinct by the input, since the sum of some numbers could be the same. This process is best for converting categories (i.e., alphabetic values only) to an ID. ‎
  • OpenProperties.sas   9k - Dec 28, 2011, 2:13 PM by Chris S. (v3)
    ‎Open the properties of the specified table. If blank, the last or copied table will be used. Based on the OpenTable macro.  ‎
Showing 5 files from page General Macros.