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
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.