mp_validatecol.sas File Reference

Used to validate values in a data step. More...

Go to the source code of this file.

Detailed Description

Useful when sanitising inputs, to ensure that they arrive with a certain pattern. Usage:

data test;
  infile datalines4 dsd;
  input;
  libds=_infile_;
  %mp_validatecol(libds,LIBDS,is_libds)
datalines4;
some.libname
!lib.blah
%abort
definite.ok
not.ok!
nineletrs._
;;;;
run;

For more examples, see mp_validatecol.test.sas

Tip - when contributing, use https://regex101.com to test the regex validity!

Parameters

[in]	incol	The column to be validated
[in]	rule	The rule to apply. Current rules: ISINT - checks if the variable is an integer ISLIB - checks if the value is a valid libref (NOT whether it exists) ISNUM - checks if the variable is numeric LIBDS - matches LIBREF.DATASET format FORMAT - checks if the provided format is syntactically valid
[out]	outcol	The variable to create, with the results of the match

SAS Macros

• mf_getuniquename.sas

Related Macros

• mp_validatecol.test.sas

Version

9.3

Definition in file mp_validatecol.sas.