SMILE - Smart SAS Macros

SMILE stands for Smart SAS Macros - an Intuitive Library Extension

Smile contains various small SAS macros supporting various tasks of a SAS programmer. Some macros are inspired by other open source macros and some by available papers. A complete overview can be seen below. More detailed documentation can be found in the macro headers or on the documentation page.

Macro Overview

The following SAS macros are currently available:

Macro | Description ---|--- smile_attr_var |Function-style macro to return a variable attribute of a dataset. The following attributes are available: VARTYPE, VARLEN, VARLABEL, VARFMT and VARINFMT smile_attrc |Function-style macro to return a character attribute of a dataset. The following attributes are available: CHARSET, COMPRESS, DATAREP, ENCODING, ENCRYPT, ENGINE, LABEL, LIB, MEM, MODE, MTYPE, SORTEDBY, SORTLVL, SORTSEQ, TYPE smile_attrn |Function-style macro to return a numeric attribute of a dataset. The following attributes are available: ALTERPW, ANOBS, ANY, ARAND, ARWU, AUDIT, AUDIT_DATA, AUDIT_BEFORE, AUDIT_ERROR, CRDTE, ICONST, INDEX, ISINDEX, ISSUBSET, LRECL, LRID, MAXGEN, MAXRC, MODTE, NDEL, NEXTGEN, NLOBS, NLOBSF, NOBS, NVARS, PW, RADIX, READPW, REUSE, TAPE, WHSTMT, WRITEPW smile_ods_document_flat_label |Flat navigation and optionally re-label navigation for ODS DOCUMENT. The navigation bookmark level is reduced to one level only. Optionally a label can be applied to all content items or the navigation label can be removed completely. smile_pdf_merge |Merge multiple PDF files and create one bookmark entry per PDF file with PROC GROOVY and open-source Tool PDFBox smile_pdf_read_bookmarks |Read PDF Bookmarks into a SAS dataset with the variables level, title and page smile_replace_in_text_files |Replace text from all files contained in a folder with a different text smile_url_check |Check existence of URL and store result in return code, information can optionally be printed to the log smile_url_download |Downloads a file from an URL and store it locally on OUTFILE. Additionally return code can be stored and information can optionally be printed to the log.

Getting Started

The macros can be cloned or downloaded directly from the GitHub repository to use this within any SAS environment. The macros has been developed under SAS 9.4 Unix, but are likely to run on other operating systems and also under other SAS versions like from SAS 9.2.

To use the macros in any program, these can be included single by single via %INCLUDE "<macro>"; or the folder where the macros are located can be included into the SASAUTOS path OPTIONS SASAUTOS=(<path>, SASAUTOS);. The macros can also be stored into a SAS Macro store and used from there.

The macros could easily be made available in any SAS environment with internet connection with the following two statements:

FILENAME macros URL "https://raw.githubusercontent.com/KatjaGlassConsulting/SMILE-SmartSASMacros/main/all.sas";
%INCLUDE macros;

The repository is using the following structure:

Folder | Content --- |--- macros | This folder contains the core macros programs | General programs can be found here - test_* programs are available to check the functionality of macros results | Outputs generated through programs

License

The macros and programs are using the MIT-License. See LICENSE for more information.

Contact

These macros has been developed by Katja Glass Consulting. Feel free to reach me through my website or via LinkedIn.