topic Re: Using User Defined Functions (PROC FCMP) in SAS Enteprise Guide Taks in SAS Enterprise Guide

Using User Defined Functions (PROC FCMP) in SAS Enteprise Guide Taks

HenriTheuwissen — Wed, 17 Apr 2019 11:24:08 GMT

I created functions, using PROC FCMP, and made these functions available to our users, who write SAS Code.

We also have several users, working in SAS Enterprise Guide, using tasks like the Query Builder.

I can use the user defined functions within the Query Builder, by typing the name of the function in the "Enter an expression" area in the 'Build an advanced expression' window .

Can I add the user defined functions to the list of functions pane, so the user can pick the function from the list, instead of having to type the syntax?

If Yes, what set-up is required for this?

Note: we use SAS Enterprise Guide 7.15 on a Linux platform

Looking forward to any feedback

Best regards,

Henri

Re: Using User Defined Functions (PROC FCMP) in SAS Enteprise Guide Taks

ChrisHemedinger — Wed, 17 Apr 2019 12:50:30 GMT

You can "teach" the Expression builder about new functions. You do this by editing the sasexpfunc.xml file in:

%appdata%\SAS\SharedSettings\7.1\Expressions\en

And optionally the dictfuncq2t.rtf file in the same folder (be sure to save as a native RTF file).

You would do this on one machine with EG, test it, and then copy these files to the same area for all users/machines who need them. These files are used/referenced by the EG install, not the SAS server (so running SAS on Linux is not a factor).

The format isn't documented, per se, but you should be able to use existing content to build from examples. If you totally mess it up, simply delete the files from the folder and restart EG -- fresh copies will magically appear.