Menu
Is it possible, as a third party, to develop a SAS PROC? I'm thinking of something like a matlab toolbox or an R package.
I've looked everywhere for info on how to do this, and the lack of discussion leads me to believe this is Not Done. Can anyone point to counterexamples, preferably with some insight into both the technical and business issues involved?
602
PROC FEDSQL enables the user to access multiple data sources all within one query, as opposed to a different query for each new data source that PROC SQL would do previously. Multiple data sources are combined in a query in PROC FEDSQL when one or more SELECT statements are used to produce a dataset.
A SAS program is a sequence of steps that you submit to SAS for execution. Each step in the program performs a specific task. Only two kinds of steps make up SAS programs: DATA steps and PROC steps. A SAS program can contain a DATA step, a PROC step, or any combination of DATA steps and PROC steps.
Proc Means being an in-database enhanced procedures SAS will try to convert the proc syntax into SQL code and send it to the database.
A Proc is a procedure described by PROC commands. Its first line must contain the code PQ to identify it to the system as a Proc. The remaining lines contain PROC commands. Usually, a Proc is created as an item with the Editor; however, any process which can write an item to a file can be used to create a Proc.
You can create custom PROCs using the SAS/TOOLKIT product if you have it licensed. I don't think it is widely used by SAS customers. I did a very trivial example with it many years ago just to see what was involved. I think most SAS customers stick with using SAS Macro, SAS/AF and more recently PROC FCMP for their custom code bundling requirements (there are also ways of calling Java object methods and Windows DLL routines too).
The primary document is SAS/TOOLKIT Software: Usage and Reference, Version 6, First Edition and it looks like it is only available for purchase as there is no PDF link like there is for most of the other SAS docs. SAS Usage Note 15647: Documentation for SAS/TOOLKIT® software explains that there is no single document available for SAS9 - you use the V6 document and the various changes and enhancements documents since V6 - the usage note lists them all for you.
You might also be interested in the following old SUGI23 paper for some background: Statistical Development Using SAS/TOOLKIT® Software
190
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
