Rapid Decision Support SAS Macro Package

Three-dimensional_graphAfter much testing, we are now ready to re-launch the SPIKEware Rapid Decision Support SAS Macro package!  Over 250 time-tested SAS macros to make your everyday SAS Programming steps much easier!

  • Sorting and grouping
    • Sort a whole lot of SAS data sets with the same by variable
    • Sort a very large SAS data set using less memory
    • Sort a list of text values in a string
    • Easily identify exact and near duplicates for removal or data scrubbing
  • SAS metadata tools
    • Return the number of observations in a SAS data set
    • Return the number of variables in a SAS data set
    • Return the label, format, or informat of a variable in a SAS data set
    • Return a list of all character or numeric variables in a SAS data set
  • Data lookup functions
    • Return the value of a variable in a SAS data set for the nth observation
    • Return the formatted value of a variable in a SAS data set for the nth observation
    • Return the value of a variable in one record based on the value of another variable in the same record
  • SAS Reporting tools
    • Stem and leaf report
    • Bullet graphs
    • “Check-All-That-Apply” frequency report
    • Quick and easy exception reports
    • Pull a random sample from a SAS data set
    • Print every value of a single variable on as few output pages as possible
    • Compare two or more SAS data set variable names, types, lengths, formats, and labels
  • New SAS macro functions
    • Mathematical functions: %ABS, %MEAN, %MIN, %MAX, %SUM, %TRANSLATE, and more
    • Trigonometric functions:  %SIN, %COS, %TAN, and more
    • Text functions:  %BYTE, %RANK, %REPEAT, %REVERSE, and more
    • Operating system functions:  %CURRENTPATH, %DOSPATH, %FILEPATH, %DATAMEM, and more
    • Functions that return a constant:  %PI, %E, %BIG, %DATETIME, and more
  • Legacy SAS macros
    • Read in and write out a comma separated file
    • Read in and write out to a Microsoft Excel File
    • Create a PARETO chart
    • Encrypt and decrypt a SAS data set
  • And so many more!!

We use these SAS macros daily–sometimes for everyday task

Download now for free

SAS, The SAS Software System, and SAS Macro Language are registred trademarks of SAS Institute Inc. in Cary, NC, USA.  SPIKEware is not affiliated with The SAS Institute.

Microsoft Excel is a registreed trademark of Microsoft.  SPIKEware is not affiliated with Microsoft.