How to add function list in Notepad++

In SAS Proc SQL code like this can be use to create a function list in NotePad++. It makes code navigation easy.

CREATE TABLE WORK.TEMP_SECMOVE_1 AS

Now go to Notepad++. open up %appdata%/Notepad++/functionList.xml

Add following to the associationMap section:

        <association userDefinedLangName="SAS" id="sas_function"/>

Add to the parser section:

        <parser id="sas_function" displayName="SAS">
            <function
                mainExpr="^[\s]{0,}(CREATE TABLE|INSERT INTO)[\s]{1,}[\w._]{1,}">
                <functionName>
                    <funcNameExpr expr=".*"/>
                </functionName>
            </function>
        </parser>

This website is very helpful for one to learn Regular Expression.

https://regex101.com

It allows you to see result in real time.

Leave a Reply

Your email address will not be published. Required fields are marked *