Menu
▾
▴
#45 Allow for testing of Stored Processes
open
nobody
None
v1.1
not_relevant
Enhancement_Request
New_Features
3-moderate
2015-06-25
2012-07-20
No
Stored processes are SAS programs which are stored on a SAS server and documented in a SAS metadata server. Their purpose is to be called from various SAS or other applications (SAS EG, SAS Information Delivery Portal, from Java or .NET applications etc.). SAS programs designated to be deployed as stored processes can be tested with SASUnit, but only before their deployment and additional testing is necessary as to correct passing of parameters and correct return of results.
The following is necessary
- Establish a method to call stored processes from test scenarios, to receive results and to store them in the test scenario environment in order to able to user them in asserts. Stored processes can be called by a http request to the SAS stored process web application or by PROC STP.
- Retrieve information about success of the execution of the stored process and write to test database
- Use standard assertions to results delivered by the stored process
Discussion
Anonymous
STPs may be called from a SAS Client like the EG, but are mainly used in the browser. Therefore a framework with focus on web testing like selenium should be used for this purpose.
Selenium for instance can be used to test STP prompts and all types of output delivered by the STP. Therefore I would suggest to use SASUnit for all macros used by the STP, but to use a web testing framework to test the STP itself.