Macro Functions Listed Alphabetically

B C E H I K L N Q R S U V

Name	Syntax and Description
%BQUOTE Macro Function	%BQUOTE(character-string) Mask special characters and mnemonic operators in a resolved value at macro execution. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%CMY Macro Function	%CMY(cyan, magenta, yellow); creates an RGB color name from numeric CMY component values. Product: SAS/GRAPH Document: SAS/GRAPH: Reference for SAS Viya Workbench
%CMYK Macro Function	%CMYK(cyan, magenta, yellow, black); creates a CMYK color name from numeric CMYK component values. Product: SAS/GRAPH Document: SAS/GRAPH: Reference for SAS Viya Workbench
%CNS Macro Function	%CNS(CNS-color-name); creates a SAS/GRAPH HLS color name from a color-naming scheme (CNS) color name. Product: SAS/GRAPH Document: SAS/GRAPH: Reference for SAS Viya Workbench
%EVAL Macro Function	%EVAL(expression) Evaluates arithmetic and logical expressions using integer arithmetic. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%HLS Macro Function	%HLS(hue, lightness, saturation); creates an HLS color name from numeric HLS component values. Product: SAS/GRAPH Document: SAS/GRAPH: Reference for SAS Viya Workbench
%HLS2RGB Macro Function	%HLS2RGB(HLS-color-name); creates an RGB color name from an HLS color name. Product: SAS/GRAPH Document: SAS/GRAPH: Reference for SAS Viya Workbench
%HSV Macro Function	%HSV(hue, saturation, value); creates an HLS color name from numeric HSV component values. Product: SAS/GRAPH Document: SAS/GRAPH: Reference for SAS Viya Workbench
%INDEX Macro Function	%INDEX(source-string, target-string) Returns the position of the first character of a string. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%KINDEX Macro Function	%KINDEX (source, string) Returns the position of the first character of a string. Product: Base SAS Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
%KLEFT Macro Function	%KLEFT (text \| text expression) Left-aligns an argument by removing leading blanks. Product: Base SAS Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
%KLENGTH Macro Function	%KLENGTH (character string \| text expression) Returns the length of a string. Product: Base SAS Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
%KSCAN Macro Function	%KSCAN (argument, n<,delimiters > ) Search for a word that is specified by its position in a string. Product: Base SAS Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
%KSUBSTR Macro Function	%KSUBSTR (argument, position<, length> ) Produce a substring of a character string. Product: Base SAS Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
%KUPCASE Macro Function	%KUPCASE (character string \| text expression) Convert values to uppercase. Product: Base SAS Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
%LENGTH Macro Function	%LENGTH(character-string) Returns the length of a string. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%NRBQUOTE Macro Function	%NRBQUOTE(character-string) Masks special characters, including & and %, and mnemonic operators in a resolved value at macro execution. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%NRQUOTE Macro Function	%NRQUOTE(character-string) Masks special characters, including & and %, and mnemonic operators in a resolved value at macro execution. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%NRSTR Macro Function	%NRSTR(character-string) Masks special characters, including & and %, and mnemonic operators in constant text during macro compilation. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%QKLEFT Macro Function	%QKLEFT (text \| text expression) Left-aligns an argument by removing leading blanks. Product: Base SAS Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
%QKSCAN Macro Function	%QKSCAN (argument, n<,delimiters > ) Search for a word that is specified by its position in a string. Product: Base SAS Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
%QKSUBSTR Macro Function	%QKSUBSTR (argument, position<, length> ) Produce a substring of a character string. Product: Base SAS Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
%QKUPCASE Macro Function	%QKUPCASE (character string \| text expression) Convert values to uppercase. Product: Base SAS Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench
%QSCAN Macro Function	%QSCAN(character-string, n<, charlist<, modifiers>>) Searches for a word and masks special characters and mnemonic operators. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%QSUBSTR Macro Function	%QSUBSTR(character-string, position<, length>) Produces a substring and masks special characters and mnemonic operators. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%QSYSFUNC Macro Function	%QSYSFUNC(function(arguments)<, format>) Executes functions and masks special characters and mnemonic operators. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%QUOTE Macro Function	%QUOTE(character-string) Mask special characters and mnemonic operators in a resolved value at macro execution. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%QUPCASE Macro Function	%QUPCASE(character-string) Converts a value to uppercase and returns a result that masks special characters and mnemonic operators. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%RGB Macro Function	%RGB(red, green, blue); creates an RBG color name from numeric RGB component values. Product: SAS/GRAPH Document: SAS/GRAPH: Reference for SAS Viya Workbench
%RGB2HLS Macro Function	%RGB2HLS(RGB-color-name); creates an HLS color name from an RGB color name. Product: SAS/GRAPH Document: SAS/GRAPH: Reference for SAS Viya Workbench
%SCAN Macro Function	%SCAN(character-string, n<, delimiters<, modifiers>>) Searches for a word that is specified by its position in a string. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%STR Macro Function	%STR(character-string) Mask special characters and mnemonic operators in constant text at macro compilation. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%SUBSTR Macro Function	%SUBSTR(character-string, position<, length>) Produce a substring of a character string. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%SUPERQ Macro Function	%SUPERQ(macro-variable-name) Masks all special characters and mnemonic operators at macro execution but prevents further resolution of the value. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%SYMEXIST Macro Function	%SYMEXIST(macro-variable-name) Returns an indication of the existence of a macro variable. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%SYMGLOBL Macro Function	%SYMGLOBL(macro-variable-name) Returns an indication as to whether a macro variable is global in scope. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%SYMLOCAL Macro Function	%SYMLOCAL(macro-variable-name) Returns an indication as to whether a macro variable is local in scope. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%SYSEVALF Macro Function	%SYSEVALF(expression<, conversion-type>) Evaluates arithmetic and logical expressions using floating-point arithmetic. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%SYSFUNC Macro Function	%SYSFUNC(function(arguments)<, format>) Execute SAS functions or user-written functions. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%SYSGET Macro Function	%SYSGET(environment-variable) Returns the character string that is the value of the environment variable passed as the argument. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%SYSMACEXEC Macro Function	%SYSMACEXEC(macro-name) Returns an indication of the execution status of a macro. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%SYSMACEXIST Macro Function	%SYSMACEXIST(macro-name) Returns an indication of the existence of a macro definition in the Work.SASMacr or Work.SASMacn catalog. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%SYSMEXECDEPTH Macro Function	%SYSMEXECDEPTH Returns the nesting depth of macro execution from the point of the call to %SYSMEXECDEPTH. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%SYSMEXECNAME Macro Function	%SYSMEXECNAME(nesting-level) Returns the name of the macro executing at a requested nesting level. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%SYSPROD Macro Function	%SYSPROD(product-code) Reports whether a SAS software product is licensed at the site. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%UNQUOTE Macro Function	%UNQUOTE(character-string) During macro execution, unmasks all special characters and mnemonic operators for a value. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%UPCASE Macro Function	%UPCASE(character-string) Convert values to uppercase. Product: Base SAS Document: SAS Macro Language Reference for SAS Viya Workbench
%VALIDCHS Macro Function	%VALIDCHS(dsnm=dataset_name, libnm=libref_name<ENCODING=encoding_name,><COMPATIBLE=encoding_name)> Validates the character(s) encoding compatibility for data set variables. Product: Base SAS Document: SAS National Language Support (NLS) Reference for SAS Viya Workbench

Last updated: June 5, 2026