BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
sashamal
Fluorite | Level 6

How to configure stored process server to execute certain SAS code on the end of each execution?

 

I need execute "proc printto; run;" on termination of each stored process automatically, whitout relation to content of the process.

 

Config option TERMSTMT="proc printto;run;" will work here?

1 ACCEPTED SOLUTION

Accepted Solutions
Sajid01
Meteorite | Level 14

I have done similar action using SAS Management Console as follows
Go to SASAPP/Logical Stored Process Server

and then right click and select Properties/Options/Request
Here there will be  boxes for initialization and termination program.
If it is desired to run the code at the end of the Stored process. 
Therefore, the  code can be written  to a file and its path included in the termination program text box and saved.
Appropriate privilege's are needed in the SMC to perform this action.
Please backup and take appropriate precautions/care.

View solution in original post

3 REPLIES 3
Sajid01
Meteorite | Level 14

I have done similar action using SAS Management Console as follows
Go to SASAPP/Logical Stored Process Server

and then right click and select Properties/Options/Request
Here there will be  boxes for initialization and termination program.
If it is desired to run the code at the end of the Stored process. 
Therefore, the  code can be written  to a file and its path included in the termination program text box and saved.
Appropriate privilege's are needed in the SMC to perform this action.
Please backup and take appropriate precautions/care.

sashamal
Fluorite | Level 6

Thank you, Sajid01! Have I restart Metadata server after these changes ?

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 470 views
  • 1 like
  • 2 in conversation