SAS Stored Process and SAS Visual Analytics

Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives.

** Things under legendu.net/outdated are outdated technologies that the author does not plan to update any more. Please look for better alternatives. **

SAS Stored Process

1. %stpbegin and %stpend initialize the output delivery system (ODS). They are not needed if you don't have to use ODS.

2. *ProcessBody; (don't forget the semicolon, this an example of using comment as markup)

3. It seems that SAS 9.2 is messy on this, so be aware of the version of SAS that you are using.

4. It it recommended that you begin all stored process (regardless of the server types) with %global declarations for all of you input parameters followed by the ProcessBody; comment. In SAS 9.3, the ProcessBody; is not needed

5. Special characters: ampersand (&), apostrophe('), percent sign (%), quotation marks ("), and semicolon (;). Be care about accepting these characeters from user client.

6. accepting multiple values is messy and can result in errors if input values is the same as one of the generated variables ....

7. use masked single line for password entry

8. It's suggested that you always require non-blank input for a textbox. Otherwise, the stored process might run without prompt on SVA.

9. it's recommended to store source code in metadata (available in sas 9.3)

10. the header function (stpsrv_header) must be placed before any code that writes results to _webout.)

11. The stpsrv_header is data step function used to add or modify a header

SAS Visual Analytics

1. To insert the Stored Process, navigate to "Insert->Other->Stored Process".

2. use the original address fix the problem of SAS Visual Analytics

3. SVA is for large data, but since we work on servers, we have to upload data. How much time do we need to upload, e.g., 10G data in an average corparate network?