For example, this macro can be used to set all instances of 'NULL' to the empty string.

DenullifyDataset.sas - Sets to empty all text fields in a dataset are equal to a given value.

Can be used, for example, to convert all Y/N flags to 1/0 flags, or vise versa.

ConvertFlags.sas - Converts all flags in all character fields in a dataset from one defined set of two values to another defined set of two values.

Zipped folder also contains a set Pytest unit tests for delete_superfluous_records.py – (Version 0.1) April 11, 2022

DeleteSuperfluousRecords.py - A Python implementation of DeleteSupefluousRecords.sas.

In this case, the record with the complete middle name has more complete information than the other records, so this macro will delete the other records. An example is with name data, where one record has a first name, last name and a complete middle name, and other records have the same first and last names, but they have only the middle initial or no initial at all. A superfluous record here means a record that contains information that is a strict subset of another record.

DeleteSuperfluousRecords.sas - Deletes superfluous records from a data set.

Which data sets that are copied can be filtered using a regular expression filter.

CopyDataSetsToWorkbook.sas – Copies all the data sets in a SAS library to an Excel workbook.

Possible metadata types include all those available in SAS's Dictionary Table. Example metadata types include the record count (RecordCount), the creation date (crdate), the number of columns (nvar) and the column names (ColumnNames).

GetLibraryMetadata.sas - Creates a report in the form of a data set that contains user-selected metadata types for each data set in a library.

A useful macro for optimizing space required to store variables in a SAS dataset.

SQUEEZE.sas –Developed by Ross Bettinger, with slight modifications by ERDC.

This is a very useful macro for characterizing all the variables in a dataset, especially “wide” datasets where it might be onerous to manually run PROC FREQ against each variable.

ProcFreqCubed.sas - Analyzes a SAS dataset by running PROC FREQ against every column in the dataset.CreateResearchlds.sas - Creates a research identifier based on, but completely masks, some other confidential identifier such as SSN, Student_Id, or Person_Id.If you do use our macros, we would appreciate it if you would acknowledge the original contributor of the material. We place all ERDC macros listed on this page into the public domain. ERDC releases all rights to these macros.Since other states and other entities might find them useful, we are making these SAS macros available to the public. New and enhanced options for macro statements that enable you to create secure macros and to integrate macros with other parts of your SAS programs.įor more information, read What’s New in the SAS 9.4 Macro Facility.ERDC has developed several SAS macros to assist us in the cleaning and linking of education data.

New automatic macro variables that enable you to reduce the amount of text that is needed to perform common tasks.

A new appendix entitled 'SAS Macro Facility Error and Warning Messages' that lists all SAS macro error and warning messages, their causes, and their solutions.

A new appendix entitled 'SAS Macro Examples' that contains several programs and descriptions.

The SAS 9.4 Macro Language Facility has the following enhancements: The macro facility is provided with Base SAS software. Macros can also be stored and shared among multiple users. The rest of SAS receives those statements and uses them in the same way it uses the ones that you enter in the When you use a macro name in a SAS program or from aĬommand prompt, the macro facility generates SAS statements and commands as needed. You can work with the names that you created rather than with the text itself. To character strings or groups of SAS programming statements.

The macro facility enables you to assign a name The macro facility is a tool for extending and customizing SAS and for reducing the amount of text that you must enter to do common tasks.

Sas macro