Your SAS programs, embedded in web apps and elsewhere

SAS Code to Create a Stored Process

Reply
Contributor
Posts: 28

SAS Code to Create a Stored Process

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.

Trusted Advisor
Posts: 1,300

Re: SAS Code to Create a Stored Process

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.

Valued Guide
Posts: 3,208

Re: SAS Code to Create a Stored Process

Seems to me you are looking for the batch interfaces export / import

SAS(R) 9.4 Intelligence Platform: System Administration Guide, Third Edition (preparing)

SAS(R) 9.4 Intelligence Platform: System Administration Guide, Third Edition (running import)

---->-- ja karman --<-----
Contributor
Posts: 28

Re: SAS Code to Create a Stored Process

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.

Valued Guide
Posts: 3,208

Re: SAS Code to Create a Stored Process

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.   

---->-- ja karman --<-----
Ask a Question
Discussion stats
  • 4 replies
  • 815 views
  • 0 likes
  • 3 in conversation