File List

List of Files Used in the Macro-Core Library

[detail level 123]

► base	Regular Base SAS Macros
mf_abort.sas	Abort, ungracefully
mf_dedup.sas	De-duplicates a macro string
mf_deletefile.sas	Deletes a physical file, if it exists
mf_existds.sas	Checks whether a dataset OR a view exists
mf_existfeature.sas	Checks whether a feature exists
mf_existfileref.sas	Checks whether a fileref exists
mf_existfunction.sas	Checks if a function exists
mf_existvar.sas	Checks if a variable exists in a data set
mf_existvarlist.sas	Checks if a set of variables ALL exist in a data set
mf_fmtdttm.sas	Returns E8601DT26.6 if compatible else DATETIME19.3
mf_getapploc.sas	Returns the appLoc from the _program variable
mf_getattrc.sas	Returns a character attribute of a dataset
mf_getattrn.sas	Returns a numeric attribute of a dataset
mf_getengine.sas	Returns the engine type of a SAS library
mf_getfilesize.sas	Returns the size of a file in bytes
mf_getfmtlist.sas	Returns a distinct list of formats from a table
mf_getfmtname.sas	Extracts a format name from a fully defined format
mf_getkeyvalue.sas	Retrieves a key value pair from a control dataset
mf_getplatform.sas	Returns platform specific variables
mf_getquotedstr.sas	Adds custom quotes / delimiters to a delimited string
mf_getschema.sas	Returns the database schema of a SAS library
mf_getuniquefileref.sas	Assigns and returns an unused fileref
mf_getuniquelibref.sas	Returns an unused libref
mf_getuniquename.sas	Returns a shortened (32 char) GUID as a valid SAS name
mf_getuser.sas	Returns a userid according to session context
mf_getvalue.sas	Retrieves a value from a dataset. If no filter supplied, then first record is used
mf_getvarcount.sas	Returns number of variables in a dataset
mf_getvarformat.sas	Returns the format of a variable
mf_getvarlen.sas	Returns the length of a variable
mf_getvarlist.sas	Returns dataset variable list direct from header
mf_getvarnum.sas	Returns the position of a variable in dataset (varnum attribute)
mf_getvartype.sas	Returns variable type - Character (C) or Numeric (N)
mf_getxengine.sas	Returns the engine type of a SAS fileref
mf_increment.sas	Increments a macro variable
mf_isblank.sas	Checks whether a macro variable is empty (blank)
mf_isdir.sas	Checks whether a path is a valid directory
mf_isint.sas	Returns 1 if the variable contains only digits 0-9, else 0
mf_islibds.sas	Checks whether a string follows correct library.dataset format
mf_loc.sas	Returns physical location of various SAS items
mf_mkdir.sas	Creates a directory, including any intermediate directories
mf_mval.sas	Returns a macro variable value if the variable exists
mf_nobs.sas	Returns number of logical (undeleted) observations
mf_trimstr.sas	Removes character(s) from the end, if they exist
mf_uid.sas	Creates a unique ID based on system time in friendly format
mf_verifymacvars.sas	Checks if a set of macro variables exist AND contain values
mf_wordsinstr1andstr2.sas	Returns words that are in both string 1 and string 2
mf_wordsinstr1butnotstr2.sas	Returns words that are in string 1 but not in string 2
mf_writefile.sas	Creates a text file using pure macro
mp_abort.sas	Abort gracefully according to context
mp_appendfile.sas	Append (concatenate) two or more files
mp_applyformats.sas	Apply a set of formats to a table
mp_assert.sas	Generic assertion
mp_assertcols.sas	Asserts the existence (or not) of columns
mp_assertcolvals.sas	Asserts the values in a column
mp_assertdsobs.sas	Asserts the number of observations in a dataset
mp_assertscope.sas	Used to capture scope leakage of macro variables
mp_base64copy.sas	Convert a file to/from base64 format
mp_binarycopy.sas	Copy any file using binary input / output streams
mp_chop.sas	Splits a file of ANY SIZE by reference to a search string
mp_cleancsv.sas	Fixes embedded cr / lf / crlf in CSV
mp_cntlout.sas	Creates a cntlout dataset in a consistent format
mp_copyfolder.sas	A macro to recursively copy a directory
mp_coretable.sas	Create the permanent Core tables
mp_createconstraints.sas	Creates constraints
mp_createwebservice.sas	Create a web service in SAS 9, Viya or SASjs Server
mp_csv2ds.sas	Efficient import of arbitrary CSV using a dataset as template
mp_deleteconstraints.sas	Delete constraionts
mp_deletefolder.sas	A macro to delete a directory
mp_dirlist.sas	Returns all files and subdirectories within a specified parent
mp_distinctfmtvalues.sas	Creates a dataset containing distinct formatted values
mp_dropmembers.sas	Drops tables / views (if they exist) without warnings in the log
mp_ds2cards.sas	Create a CARDS file from a SAS dataset
mp_ds2csv.sas	Export a dataset to a CSV file WITH leading blanks
mp_ds2ddl.sas	A wrapper for mp_getddl.sas
mp_ds2fmtds.sas	Converts every value in a dataset to formatted value
mp_ds2inserts.sas	Export a dataset to SQL insert statements
mp_ds2md.sas	Create a Markdown Table from a dataset
mp_ds2squeeze.sas	Create a smaller version of a dataset, without data loss
mp_filtercheck.sas	Checks an input filter table for validity
mp_filtergenerate.sas	Generates a filter clause from an input table, to a fileref
mp_filterstore.sas	Checks & Stores an input filter table and returns the Filter Key
mp_filtervalidate.sas	Checks a generated filter query for validity
mp_getcols.sas	Creates a dataset with column metadata
mp_getconstraints.sas	Get constraint details at column level
mp_getdbml.sas	Extract DBML from SAS Libraries
mp_getddl.sas	Extract DDL in various formats, by table or library
mp_getformats.sas	Export format definitions
mp_getmaxvarlengths.sas	Scans a dataset to find the max length of the variable values
mp_getpk.sas	Extract the primary key fields from a table or library
mp_gsubfile.sas	Performs a text substitution on a file
mp_guesspk.sas	Guess the primary key of a table
mp_hashdataset.sas	Returns a unique hash for a dataset
mp_include.sas	Performs a wrapped %include
mp_init.sas	Initialise session with useful settings and variables
mp_jsonout.sas	Writes JSON in SASjs format to a fileref
mp_lib2cards.sas	Convert all library members to CARDS files
mp_lib2inserts.sas	Convert all data in a library to SQL insert statements
mp_loadformat.sas	Loads a format catalog from a staging dataset
mp_lockanytable.sas	Mechanism for locking tables to prevent parallel modifications
mp_lockfilecheck.sas	Aborts if a SAS lock file is in place, or if one cannot be applied
mp_makedata.sas	Create sample data based on the structure of an empty table
mp_md5.sas	Generates an md5 expression for hashing a set of variables
mp_perflog.sas	Logs the time the macro was executed in a control dataset
mp_prevobs.sas	Enables previous observations to be re-instated
mp_recursivejoin.sas	Returns all children from a hierarchy table for a specified parent
mp_replace.sas	Performs a text substitution on a file
mp_reseterror.sas	Reset when an err condition occurs
mp_resetoption.sas	Reset an option to original value
mp_retainedkey.sas	Generate and apply retained key values to a staging table
mp_runddl.sas	An opinionated way to execute DDL files in SAS
mp_searchcols.sas	Searches all columns in a library
mp_searchdata.sas	Searches all data in a library
mp_setkeyvalue.sas	Logs a key value pair a control dataset
mp_sortinplace.sas	Sorts a SAS dataset in place, preserving constraints
mp_stackdiffs.sas	Prepares an audit table for stacking (re-applying) the changes
mp_storediffs.sas	Converts deletes/changes/appends into a single audit table
mp_stprequests.sas	Capture session start / finish times and request details
mp_streamfile.sas	Streams a file to _webout according to content type
mp_testjob.sas	Runs arbitrary code for a specified amount of time
mp_testservice.sas	To be deprecated. Will execute a SASjs web service on SAS 9 or Viya
mp_testwritespeedlibrary.sas	Tests the write speed of a new table in a SAS library
mp_tree.sas	Recursively scans a directory tree to get all subfolders and content
mp_unzip.sas	Unzips a zip file
mp_updatevarlength.sas	Change the length of a variable
mp_validatecol.sas	Used to validate variables in a dataset
mp_wait4file.sas	Wait until a file arrives before continuing execution
mp_webin.sas	Fix the _WEBIN variables provided to SAS web services
mp_zip.sas	Creates a zip file
► ddl	Data Definition Language files
mddl_dc_difftable.sas	Difftable DDL
mddl_dc_filterdetail.sas	Filtertable DDL
mddl_dc_filtersummary.sas	Filtersummary DDL
mddl_dc_locktable.sas	Locktable DDL
mddl_dc_maxkeytable.sas	Maxkeytable DDL
mddl_sas_cntlout.sas	The CNTLOUT table generated by proc format
► fcmp	Macros for generating FCMP functions
mcf_getfmttype.sas	Returns the type of the format
mcf_init.sas	Sets up the mcf_xx functions
mcf_length.sas	Returns the length of a numeric value
mcf_string2file.sas	Adds a string to a file
► lua	Lua macros
ml_gsubfile.sas	Compiles the gsubfile.lua lua file
ml_json.sas	Compiles the json.lua lua file
► meta	Metadata Aware Macros
mm_adduser2group.sas	Adds a user to a group
mm_assigndirectlib.sas	Assigns library directly using details from metadata
mm_assignlib.sas	Assigns a meta engine library using LIBREF
mm_createapplication.sas	Create an Application object in a metadata folder
mm_createdataset.sas	Create an empty dataset from a metadata definition
mm_createdocument.sas	Create a Document object in a metadata folder
mm_createfolder.sas	Recursively create a metadata folder
mm_createlibrary.sas	Create a SAS Library
mm_createstp.sas	Create a type 1 Stored Process (9.2 compatible)
mm_createwebservice.sas	Create a Web Ready Stored Process
mm_deletedocument.sas	Deletes a Document using path as reference
mm_deletelibrary.sas	Deletes a library by Name
mm_deletestp.sas	Deletes a Stored Process using path as reference
mm_getauthinfo.sas	Extracts authentication info for each user in metadata
mm_getcols.sas	Creates a dataset with all metadata columns for a particular table
mm_getdetails.sas	Extracts metadata attributes and associations for a particular uri
mm_getdirectories.sas	Returns a dataset with the meta directory object for a physical path
mm_getdocument.sas	Writes the TextStore of a Document Object to an external file
mm_getfoldermembers.sas	Returns all direct child members of a particular folder
mm_getfoldertree.sas	Returns all folders / subfolder content for a particular root
mm_getgroupmembers.sas	Creates dataset with all members of a metadata group
mm_getgroups.sas	Creates dataset with all groups or just those for a particular user
mm_getlibmetadiffs.sas	Compares the metadata of a library with the physical tables
mm_getlibs.sas	Creates a dataset with all metadata libraries
mm_getobjects.sas	Creates a dataset with all metadata objects for a particular type
mm_getpublictypes.sas	Creates a dataset with all deployable public types
mm_getrepos.sas	Creates a dataset with all available repositories
mm_getroles.sas	Creates a table containing a list of roles
mm_getservercontexts.sas	Creates a dataset with all server contexts in all repos
mm_getstpcode.sas	Writes the code of an STP to an external file
mm_getstps.sas	Returns a dataset with all Stored Processes, or just those in a particular folder / with a particular name
mm_gettableid.sas	Get the metadata id for a particular table
mm_gettables.sas	Creates a dataset with all metadata tables for a particular library
mm_gettree.sas	Returns the metadata path and object from either the path or object
mm_gettypes.sas	Creates a dataset with all metadata types
mm_getusers.sas	Creates a table containing a list of all users
mm_getwebappsrvprops.sas	Retrieves properties of the SAS web app server
mm_spkexport.sas	Creates an batch spk export command
mm_tree.sas	Returns all folders / subfolder content for a particular root
mm_updateappextension.sas	Add or update an extension to an application component
mm_updatedocument.sas	Update the TextStore in a Document with the same name
mm_updatestpservertype.sas	Updates a type 2 stored process to run on STP or WKS context
mm_updatestpsourcecode.sas	Update the source code of a type 2 STP
mm_webout.sas	Send data to/from SAS Stored Processes
► metax	Metadata Aware Macros with X commmand
mmx_createmetafolder.sas	Creates a metadata folder
mmx_deletemetafolder.sas	Deletes a metadata folder
mmx_spkexport.sas	Exports everything in a particular metadata folder
► server	Macros used with sasjs/server
mfs_httpheader.sas	Sets the http headers in the SASjs/server response
ms_adduser2group.sas	Adds a user to a group on SASjs Server
ms_createfile.sas	Creates a file on SASjs Drive
ms_creategroup.sas	Creates a group on SASjs Server
ms_createuser.sas	Creates a user on SASjs Server
ms_createwebservice.sas	Create a Web-Ready Stored Program
ms_deletefile.sas	Deletes a file from SASjs Drive
ms_getfile.sas	Gets a file from SASjs Drive
ms_getgroups.sas	Fetches the list of groups from SASjs Server
ms_getusers.sas	Fetches the list of users from SASjs Server
ms_runstp.sas	Executes a SASjs Server Stored Program
ms_testservice.sas	Will execute a SASjs web service on SASjs Server
ms_webout.sas	Send data to/from sasjs/server
► tests	SASjs Tests
► base	Tests for Base macros
mcf_getfmttype.test.sas	Testing mcf_getfmttype.sas macro
mcf_init.test.sas	Testing mcf_init.sas macro
mcf_length.test.sas	Testing mcf_length.sas macro
mcf_string2file.test.sas	Testing mcf_string2file macro
mf_dedup.test.sas	Testing mf_dedup macro
mf_deletefile.test.sas	Testing mf_deletefile.sas macro
mf_existds.test.sas	Testing mf_existfileref macro
mf_existfileref.test.sas	Testing mf_existfileref macro
mf_existfunction.test.sas	Testing mf_existfunction macro
mf_existvar.test.sas	Testing mf_existvar macro
mf_fmtdttm.test.sas	Testing mf_fmtdttm macro
mf_getapploc.test.sas	Testing mf_getapploc macro
mf_getfilesize.test.sas	Testing mf_getfilesize macro
mf_getfmtlist.test.sas	Testing mf_getfmtlist macro
mf_getfmtname.test.sas	Testing mf_getfmtname macro
mf_getuniquefileref.test.sas	Testing mf_getuniquefileref macro
mf_getuniquelibref.test.sas	Testing mf_getuniquelibref macro
mf_getvarcount.test.sas	Testing mf_getvarlist macro
mf_getvarlist.test.sas	Testing mf_getvarlist macro
mf_increment.test.sas	Testing mf_increment macro
mf_isint.test.sas	Testing mf_isint macro
mf_islibds.test.sas	Testing mf_islibds macro
mf_verifymacvars.test.sas	Testing mf_verifymacvars macro
mf_wordsinstr1andstr2.test.sas	Testing mf_wordsinstr1andstr2 macro
mf_wordsinstr1butnotstr2.test.sas	Testing mf_wordsinstr1butnotstr2 macro
mf_writefile.test.sas	Testing mf_writefile.sas macro
mp_abort.test.nofix.sas	Testing mp_abort macro
mp_appendfile.test.sas	Testing mp_appendfile.sas macro
mp_applyformats.test.sas	Testing mp_applyformats.sas macro
mp_assert.test.sas	Testing mp_assert macro
mp_assertcolvals.test.sas	Testing mp_assertcolvals macro
mp_assertdsobs.test.sas	Testing mp_assertdsobs.sas macro
mp_assertscope.test.sas	Testing mp_assertscope macro
mp_base64copy.test.sas	Testing mp_base64copy.sas macro
mp_binarycopy.test.sas	Testing mp_binarycopy.sas macro
mp_chop.test.sas	Testing mp_chop.sas macro
mp_cleancsv.test.sas	Testing mp_cleancsv.sas macro
mp_cntlout.test.sas	Testing mp_cntlout.sas macro
mp_copyfolder.test.sas	Testing mp_copyfolder.sas macro
mp_coretable.test.sas	Testing mp_coretable.sas macro
mp_createwebservice.test.sas	Testing ms_createwebservice.sas macro
mp_deletefolder.test.sas	Testing mp_deletefolder.sas macro
mp_dirlist.test.sas	Testing mp_dirlist.sas macro
mp_ds2cards.test.sas	Testing mp_ds2cards.sas macro
mp_ds2csv.test.sas	Testing mp_ds2csv.sas macro
mp_ds2fmtds.test.sas	Testing mp_ds2fmtds.sas macro
mp_ds2inserts.test.sas	Testing mp_ds2inserts.sas macro
mp_ds2md.test.sas	Testing mp_ds2md.sas macro
mp_ds2squeeze.test.sas	Testing mp_ds2squeeze.sas macro
mp_filtercheck.test.sas	Testing mp_filtercheck macro
mp_filtergenerate.test.sas	Testing mp_filtergenerate macro
mp_filterstore.test.1.sas	Testing mp_filterstore macro
mp_filterstore.test.2.sas	Testing mp_filterstore macro with a format catalog
mp_filtervalidate.test.sas	Testing mp_filtervalidate macro
mp_getcols.test.sas	Testing mp_getcols macro
mp_getconstraints.test.sas	Testing mp_getconstraints.sas macro
mp_getddl.test.sas	Testing mp_getddl.sas macro
mp_getformats.test.sas	Testing mp_getformats.sas macro
mp_getmaxvarlengths.test.sas	Testing mp_getmaxvarlengths macro
mp_getpk.test.sas	Testing mp_getpk.sas macro
mp_gsubfile.test.sas	Testing mp_gsubfile.sas macro
mp_hashdataset.test.sas	Testing mp_hashdataset.sas macro
mp_init.test.sas	Testing mp_gsubfile.sas macro
mp_jsonout.test.1.sas	Testing mp_jsonout.sas macro
mp_jsonout.test.2.sas	Testing mp_jsonout.sas macro with special missings
mp_jsonout.test.3.sas	Testing mp_jsonout.sas macro with non-standard chars
mp_lib2inserts.test.sas	Testing mp_ds2inserts.sas macro
mp_loadformat.test.sas	Testing mp_loadformat.sas macro
mp_lockanytable.test.sas	Testing mp_lockfilecheck macro
mp_lockfilecheck.test.sas	Testing mp_lockfilecheck macro
mp_makedata.test.sas	Testing mp_makedata.sas macro
mp_md5.test.sas	Testing mp_md5.sas macro
mp_replace.test.sas	Testing mp_replace.sas macro
mp_reseterror.test.sas	Testing mp_reseterror macro
mp_resetoption.test.sas	Testing mp_resetoption macro
mp_retainedkey.test.sas	Testing mp_retainedkey macro
mp_searchcols.test.sas	Testing mp_searchcols.sas
mp_searchdata.test.sas	Testing mp_searchdata.sas
mp_sortinplace.test.sas	Testing mp_sortinplace.test.sas
mp_stackdiffs.test.sas	Testing mp_storediffs macro
mp_storediffs.test.sas	Testing mp_storediffs macro
mp_streamfile.test.sas	Testing mp_streamfile.sas macro
mp_validatecol.test.sas	Testing mp_validatecol.sas macro
mp_webin.test.sas	Testing mp_webin macro
mp_zip.test.sas	Testing mp_zip macro
► ddlonly	Tests for DDL macros
mddl_dc_difftable.test.sas	Difftable DDL test
mddl_dc_filterdetail.test.sas	Filtertable DDL test
mddl_dc_filtersummary.test.sas	Filtersummary DDL test
mddl_dc_locktable.test.sas	Locktable DDL test
mddl_dc_maxkeytable.test.sas	Maxkeytable DDL test
mddl_sas_cntlout.test.sas	Mddl_sas_cntlout ddl test
► sas9only	Tests for SAS Metadata macros
mm_getauthinfo.test.sas	Testing mm_getauthinfo macro
mm_spkexport.test.sas	Testing mm_webout macro
mm_webout.test.sas	Testing mm_webout macro
► serveronly	Tests for SASjs Server macros
mfs_httpheader.test.sas	Testing mfs_httpheader.sas macro
ms_adduser2group.test.sas	Testing ms_adduser2group.sas macro
ms_createfile.test.sas	Testing ms_createfile.sas macro
ms_creategroup.test.sas	Testing ms_creategroup.sas macro
ms_createuser.test.sas	Testing ms_createuser.sas macro
ms_createwebservice.test.sas	Testing ms_createwebservice.sas macro
ms_deletefile.test.sas	Testing ms_deletefile.sas macro
ms_getfile.test.sas	Testing ms_getfile.sas macro
ms_getgroups.test.sas	Testing ms_getgroups.sas macro
ms_getusers.test.sas	Testing ms_getusers.sas macro
ms_runstp.test.sas	Testing ms_runstp.sas macro
ms_testservice.test.sas	Testing ms_testservice.sas macro
ms_webout.test.sas	Testing ms_webout macro
► viyaonly	Tests for Viya macros
mfv_existfile.test.sas	Testing mfv_existfile macro function
mfv_existfolder.test.sas	Testing mfv_existfolder macro function
mv_createfile.test.sas	Testing mv_createfile macro
mv_createfolder.test.sas	Testing mv_createfolder macro
mv_createwebservice.test.sas	Testing mv_createwebservice macro
mv_deleteviyafolder.test.sas	Testing mv_deleteviyafolder macro function
mv_getfoldermembers.test.sas	Testing mv_getfoldermembers macro
mv_getjobcode.test.sas	Testing mv_getjobcode macro
mv_getjoblog.test.sas	Testing mv_createwebservice macro
mv_getjobresult.test.sas	Testing mv_createwebservice macro
mv_jobflow.test.1.sas	Testing mv_jobflow macro
mv_jobflow.test.2.sas	Testing mv_jobflow macro
mv_registerclient.test.1.sas	Testing mv_registerclient.sas macro
mv_registerclient.test.2.sas	Testing mv_registerclient.sas macro
mv_webout.test.sas	Testing mv_webout macro
► x-platform	Tests for cross-platform macros
mx_getcode.test.sas	Testing mx_getcode.test.sas macro
mx_testservice.test.sas	Testing mx_testservice.sas macro
► viya	Viya macros
mfv_existfile.sas	Checks whether a file exists in SAS Drive
mfv_existfolder.sas	Checks whether a folder exists in SAS Drive
mv_createfile.sas	Creates a file in SAS Drive
mv_createfolder.sas	Creates a viya folder if that folder does not already exist
mv_createjob.sas	Creates a Viya Job
mv_createwebservice.sas	Creates a JobExecution web service if it doesn't already exist
mv_deletefoldermember.sas	Deletes an item in a Viya folder
mv_deletejes.sas	Deletes a Viya Job, if it exists
mv_deleteviyafolder.sas	Creates a viya folder if that folder does not already exist
mv_getclients.sas	Get a list of Viya Clients
mv_getfoldermembers.sas	Gets a list of folder members (and ids) for a given root
mv_getgroupmembers.sas	Creates a dataset with a list of group members
mv_getgroups.sas	Creates a dataset with a list of viya groups
mv_getjobcode.sas	Extract the source code from a SAS Viya Job
mv_getjoblog.sas	Extract the log from a completed SAS Viya Job
mv_getjobresult.sas	Extract the result from a completed SAS Viya Job
mv_getjobstate.sas	Extract the status from a running SAS Viya job
mv_getusergroups.sas	Creates a dataset with a list of groups for a particular user
mv_getusers.sas	Creates a dataset with a list of users
mv_jobexecute.sas	Executes a SAS Viya Job
mv_jobflow.sas	Execute a series of job flows
mv_jobwaitfor.sas	Takes a table of running jobs and waits for ANY/ALL of them to complete
mv_registerclient.sas	Register Client and Secret (admin task)
mv_tokenauth.sas	Get initial Refresh and Access Tokens
mv_tokenrefresh.sas	Get an additional access token using a refresh token
mv_webout.sas	Send data to/from the SAS Viya Job Execution Service
► xplatform	Cross Platform, works on all SAS servers (Viya, EBI, SASjs)
mx_createwebservice.sas	Create a web service in SAS 9, Viya or SASjs
mx_getcode.sas	Fetches code from Viya Job, SAS 9 STP, or SASjs Server STP
mx_testservice.sas	Will execute a SASjs web service on SAS 9, Viya or SASjs Server