Does anyone know if its possible to create a stored process purely in code? I would like to use this to quickly deploy similar process to other servers as opposed to exporting and importing via the gui.
It can be done through the SAS Java API, an example of which is available in the documentation here: com.sas.services.storedprocess.metadata (SAS Foundation Services)
Unless you are familiar with Java, it's probably not an approach I would recommend you taking.
Seems to me you are looking for the batch interfaces export / import
I'd like to have something so that I could change properties on the stored process. An example would be changing the expected input parameters of the stored process. Importing and exporting do not allow me to modify these variables before stored process creation.
Within the import you can change some properties SAS(R) 9.4 Intelligence Platform: System Administration Guide, Third Edition (subprop to an external file)
There are more batch tools. But a complete code generation approach as batch job looks to me overkill. You have to develop and test at some moment.
Importing to an other metadataserver is saying you don not have en enterprise approach for your enterprise intelligence platform. Why not?
It could be the same topic as a discussion that I have with some DBA or not as programmer educated people.
Suppose you want to support several databases with exactly the same structure and using the same code but needing variation by physical content and physical naming (authorization). A complete metadata defined definition cannot solve that. doing that definiton as external defined does solve that.
In that case the modifications are done in the usermods files at the appserver context. Supporting different/many appserver context is a logical; approach.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.