https://communities.sas.com/t5/SAS-Procedures/Proc-SQL-Support-for-Custom-Functions/m-p/36417#M9155 Have you looked at using PROC FCMP to build/store a function, and then use it in your SQL step? Sat, 20 Nov 2010 21:49:48 GMT ArtC 2010-11-20T21:49:48Z https://communities.sas.com/t5/SAS-Procedures/Proc-SQL-Support-for-Custom-Functions/m-p/36416#M9154 Is it possible for PROC SQL to support custom functions. For example, prior to executing my select query it is necessary to invoke the following custom function<BR /> fms.fms_multiorg.set_org_id( 707 ). Any quittance would be greatly appreciated. Thu, 18 Nov 2010 21:22:56 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-SQL-Support-for-Custom-Functions/m-p/36416#M9154 JDMTX 2010-11-18T21:22:56Z https://communities.sas.com/t5/SAS-Procedures/Proc-SQL-Support-for-Custom-Functions/m-p/36417#M9155 Have you looked at using PROC FCMP to build/store a function, and then use it in your SQL step? Sat, 20 Nov 2010 21:49:48 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-SQL-Support-for-Custom-Functions/m-p/36417#M9155 ArtC 2010-11-20T21:49:48Z