base Directory Reference

Regular Base SAS Macros.

More...

Detailed Description

These macros have the following attributes:

  OS independent
  Not metadata aware
  No X command
  Prefixes:  _mf_, _mp_

Macros starting mf_ are macro functions and can be used in assignment statements. Those starting mp_ are macro procedures, which generate SAS statements, and must therefore be applied accordingly.

Files
file	mf_abort.sas [code]
	Abort, ungracefully.
file	mf_existds.sas [code]
	Checks whether a dataset OR a view exists.
file	mf_existfeature.sas [code]
	Checks whether a feature exists.
file	mf_existfileref.sas [code]
	Checks whether a fileref exists.
file	mf_existfunction.sas [code]
	Checks if a function exists.
file	mf_existvar.sas [code]
	Checks if a variable exists in a data set.
file	mf_existvarlist.sas [code]
	Checks if a set of variables ALL exist in a data set.
file	mf_getapploc.sas [code]
	Returns the appLoc from the _program variable.
file	mf_getattrc.sas [code]
	Returns a character attribute of a dataset.
file	mf_getattrn.sas [code]
	Returns a numeric attribute of a dataset.
file	mf_getengine.sas [code]
	Returns the engine type of a SAS library.
file	mf_getfilesize.sas [code]
	Returns the size of a file in bytes.
file	mf_getkeyvalue.sas [code]
	retrieves a key value pair from a control dataset
file	mf_getplatform.sas [code]
	Returns platform specific variables.
file	mf_getquotedstr.sas [code]
	Adds custom quotes / delimiters to a delimited string.
file	mf_getschema.sas [code]
	Returns the database schema of a SAS library.
file	mf_getuniquefileref.sas [code]
	Assigns and returns an unused fileref.
file	mf_getuniquelibref.sas [code]
	Returns an unused libref.
file	mf_getuniquename.sas [code]
	Returns a shortened (32 char) GUID as a valid SAS name.
file	mf_getuser.sas [code]
	Returns a userid according to session context.
file	mf_getvalue.sas [code]
	Retrieves a value from a dataset. If no filter supplied, then first record is used.
file	mf_getvarcount.sas [code]
	Returns number of variables in a dataset.
file	mf_getvarformat.sas [code]
	Returns the format of a variable.
file	mf_getvarlen.sas [code]
	Returns the length of a variable.
file	mf_getvarlist.sas [code]
	Returns dataset variable list direct from header.
file	mf_getvarnum.sas [code]
	Returns the position of a variable in dataset (varnum attribute).
file	mf_getvartype.sas [code]
	Returns variable type - Character (C) or Numeric (N)
file	mf_getxengine.sas [code]
	Returns the engine type of a SAS fileref.
file	mf_isblank.sas [code]
	Checks whether a macro variable is empty (blank)
file	mf_isdir.sas [code]
	Checks whether a path is a valid directory.
file	mf_loc.sas [code]
	Returns physical location of various SAS items.
file	mf_mkdir.sas [code]
	Creates a directory, including any intermediate directories.
file	mf_mval.sas [code]
	Returns a macro variable value if the variable exists.
file	mf_nobs.sas [code]
	Returns number of logical (undeleted) observations.
file	mf_trimstr.sas [code]
	Removes character(s) from the end, if they exist.
file	mf_uid.sas [code]
	Creates a unique ID based on system time in friendly format.
file	mf_verifymacvars.sas [code]
	Checks if a set of macro variables exist / contain values.
file	mf_wordsinstr1butnotstr2.sas [code]
	Returns words that are in string 1 but not in string 2.
file	mp_abort.sas [code]
	abort gracefully according to context
file	mp_appendfile.sas [code]
	Append (concatenate) two or more files.
file	mp_assert.sas [code]
	Generic assertion.
file	mp_assertcols.sas [code]
	Asserts the existence (or not) of columns.
file	mp_assertcolvals.sas [code]
	Asserts the values in a column.
file	mp_assertdsobs.sas [code]
	Asserts the number of observations in a dataset.
file	mp_base64copy.sas [code]
	Convert a file to/from base64 format.
file	mp_binarycopy.sas [code]
	Copy any file using binary input / output streams.
file	mp_cleancsv.sas [code]
	Fixes embedded cr / lf / crlf in CSV.
file	mp_copyfolder.sas [code]
	A macro to recursively copy a directory.
file	mp_createconstraints.sas [code]
	Creates constraints.
file	mp_createwebservice.sas [code]
	Create a web service in SAS 9 or Viya.
file	mp_csv2ds.sas [code]
	Efficient import of arbitrary CSV using a dataset as template.
file	mp_deleteconstraints.sas [code]
	Delete constraionts.
file	mp_deletefolder.sas [code]
	A macro to delete a directory.
file	mp_dirlist.sas [code]
	Returns all files and subdirectories within a specified parent.
file	mp_distinctfmtvalues.sas [code]
	Creates a dataset containing distinct formatted values.
file	mp_dropmembers.sas [code]
	Drops tables / views (if they exist) without warnings in the log.
file	mp_ds2cards.sas [code]
	Create a CARDS file from a SAS dataset.
file	mp_ds2csv.sas [code]
	Export a dataset to a CSV file.
file	mp_ds2fmtds.sas [code]
	Converts every value in a dataset to it's formatted value.
file	mp_ds2inserts.sas [code]
	Export a dataset to SQL insert statements.
file	mp_filtercheck.sas [code]
	Checks an input filter table for validity.
file	mp_filtergenerate.sas [code]
	Generates a filter clause from an input table, to a fileref.
file	mp_filtervalidate.sas [code]
	Checks a generated filter query for validity.
file	mp_getcols.sas [code]
	Creates a dataset with column metadata.
file	mp_getconstraints.sas [code]
	Get constraint details at column level.
file	mp_getdbml.sas [code]
	Extract DBML from SAS Libraries.
file	mp_getddl.sas [code]
	Extract DDL in various formats, by table or library.
file	mp_getmaxvarlengths.sas [code]
	Scans a dataset to find the max length of the variable values.
file	mp_gsubfile.sas [code]
	Performs a text substitution on a file.
file	mp_guesspk.sas [code]
	Guess the primary key of a table.
file	mp_hashdataset.sas [code]
	Returns a unique hash for a dataset.
file	mp_include.sas [code]
	Performs a wrapped %include.
file	mp_jsonout.sas [code]
	Writes JSON in SASjs format to a fileref.
file	mp_lib2cards.sas [code]
	Convert all library members to CARDS files.
file	mp_lib2inserts.sas [code]
	Convert all data in a library to SQL insert statements.
file	mp_lockanytable.sas [code]
	Mechanism for locking tables to prevent parallel modifications.
file	mp_lockfilecheck.sas [code]
	Aborts if a SAS lock file is in place, or if one cannot be applied.
file	mp_mdtablewrite.sas [code]
	Create a Markdown Table from a dataset.
file	mp_perflog.sas [code]
	Logs the time the macro was executed in a control dataset.
file	mp_prevobs.sas [code]
	Enables previous observations to be re-instated.
file	mp_recursivejoin.sas [code]
	Returns all children from a hierarchy table for a specified parent.
file	mp_resetoption.sas [code]
	Reset an option to original value.
file	mp_runddl.sas [code]
	An opinionated way to execute DDL files in SAS.
file	mp_searchcols.sas [code]
	Searches all columns in a library.
file	mp_searchdata.sas [code]
	Searches all data in a library.
file	mp_setkeyvalue.sas [code]
	Logs a key value pair a control dataset.
file	mp_stprequests.sas [code]
	Capture session start / finish times and request details.
file	mp_streamfile.sas [code]
	Streams a file to _webout according to content type.
file	mp_testjob.sas [code]
	Runs arbitrary code for a specified amount of time.
file	mp_testservice.sas [code]
	Will execute a test against a SASjs web service on SAS 9 or Viya.
file	mp_testwritespeedlibrary.sas [code]
	Tests the write speed of a new table in a SAS library.
file	mp_tree.sas [code]
	Recursively scans a directory tree to get all subfolders and content.
file	mp_unzip.sas [code]
	Unzips a zip file.
file	mp_updatevarlength.sas [code]
	Change the length of a variable.
file	mp_validatecol.sas [code]
	Used to validate variables in a dataset.
file	mp_wait4file.sas [code]
	Wait until a file arrives before continuing execution.
file	mp_webin.sas [code]
	Fix the _WEBIN variables provided to SAS web services.
file	mp_zip.sas [code]
	Creates a zip file.