Macro Functions Listed by Category

DBCS

Name	Syntax and Description
%KCMPRES, %QKCMPRES Macro Functions	%KCMPRES (text \| text expression) %QKCMPRES (text \| text expression) Compresses multiple blanks and removes leading and trailing blanks. Product: Base SAS Document: SAS National Language Support (NLS): Reference Guide
%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 Guide
%KLEFT, %QKLEFT Macro Functions	%KLEFT (text \| text expression) %QKLEFT (text \| text expression) Left-aligns an argument by removing leading blanks. Product: Base SAS Document: SAS National Language Support (NLS): Reference Guide
%KLENGTH Macro Function	%KLENGTH (character string \| text expression) Returns the length of a string. Product: Base SAS Document: SAS National Language Support (NLS): Reference Guide
%KSCAN, %QKSCAN Macro Functions	%KSCAN (argument, n<,delimiters > ) %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 Guide
%KSUBSTR, %QKSUBSTR Macro Functions	%KSUBSTR (argument, position<, length> ) %QKSUBSTR (argument, position<, length> ) Produce a substring of a character string. Product: Base SAS Document: SAS National Language Support (NLS): Reference Guide
%KUPCASE, %QKUPCASE Macro Functions	%KUPCASE (character string \| text expression) %QKUPCASE (character string \| text expression) Convert values to uppercase. Product: Base SAS Document: SAS National Language Support (NLS): Reference Guide

Last updated: March 30, 2026