FCMP functions in PROC SQL

[Cristina_Garcia]

Good morning,

We have a question about FCMP functions,
Do you know how functions defined with FCMP can be used in an PROC SQL?

We didn't find much documentation about it.

Thank you!

[Kurt_Bremser]

Overview: FCMP Procedure says yes. Scroll down to the list of procedures.

[Kurt_Bremser]

Maxim 4: Try It.

Run this:

proc fcmp outlib=work.funcs.myfunc;
function mytest(n);
x = n * 3;
return(x);
endsub;
quit;

options cmplib=work.funcs;

proc sql;
select mytest(age) from sashelp.class;
quit;