topic FCMP functions in PROC SQL in SAS Programming

FCMP functions in PROC SQL

Cristina_Garcia — Tue, 18 Jan 2022 10:28:38 GMT

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!

Re: FCMP functions in PROC SQL

Kurt_Bremser — Tue, 18 Jan 2022 10:42:19 GMT

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

Re: FCMP functions in PROC SQL

Kurt_Bremser — Tue, 18 Jan 2022 10:47:42 GMT

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;