topic Re: Template for SAS stored processes in Administration and Deployment

Template for SAS stored processes

ggold — Tue, 02 Jun 2015 21:36:01 GMT

In order to automate our release process, I’m attempting to generate a template for SAS stored processes which are used as part of our production system.

The process we are attempting is as follows:

Export a stored process from SAS Management Console which generates a *.spk package.
Rename the .spk to .zip and uncompress this file and edit the contents directly including “ConnectionMapping.xml”, “DeployMap.xml”, and “TransportMetadata”. I’m doing this noting that ConnectionMapping and DeployMap both say . However, I am only editing the folder name of the stored process from ‘Analytics’ to ‘@AnalyticsEnvironment’
Compress these edited files to a *.zip and rename this back into an *.spk package
Import the package back into the SAS Console.

However, this gives me the following Import Error: “No package metadata.”

Is there a better way to do this? If not, how can I resolve this error?

My SAS and OS information are as follows:

Product Name: Office Analytics

SAS software release: SAS 9.4M2

Operating system: Windows Server 2012 R2

Re: Template for SAS stored processes

Quentin — Wed, 03 Jun 2015 00:15:55 GMT

I haven't tried it, but maybe the batch export and import tool would meet your needs?

http://support.sas.com/documentation/cdl/en/bisag/67481/HTML/default/viewer.htm#p16u72wwciy3y0n1wq3iarcqr116.htm

Re: Template for SAS stored processes

jakarman — Wed, 03 Jun 2015 19:49:07 GMT

Yep Quentin, that is one of the options having those tools to do the replacement. Another is avoiding the need for any replacement at all by using environment vars.
Nothing there to change, no need for an update of source/settings. This is a better fulfillment of those requirements with release management that you shouldn't change anything when deploying after the testing/validating.