SAS Stored Processes: A Practical Guide to Developing Web Applications

Description

Customize the SAS Stored Process web application to create amazing tools for end users. This book shows you how to use stored processes―SAS programs stored on a server and executed as required by requesting applications. Never before have there been so many ways to turn data into information and build applications with SAS. This book teaches you how to use the web technologies that you frequently see used on impressive websites. By using SAS Stored Processes, you will be able to build applications that exploit CSS, JavaScript, and HTML libraries and enable you to build powerful and impressive web applications using SAS as the backend. While this approach is not common with SAS users, some have had amazing results. People who have SAS skills usually do not have web development skills, and those with web development skills usually do not have SAS skills. Some people have both skills but are unaware of how to connect them with the SAS Stored Process web application. This book shows you how to leverage your skills for success. What You Will Learn Know the benefits of stored processesWrite your own tools in SASMake a stored process generate its own HTML menuPass data between stored processesUse stored processes to generate pure JavaScriptUtilize data generated by SASConvert a SAS program into a stored process Who This Book Is For SAS programmers looking to improve their existing programming skills to develop web applications, and programming managers who want to make better use of the SAS software they already license Table of Contents About the Author About the Technical Reviewer Chapter 1: Introduction Background What’s a Stored Process? Benefits of Stored Processes Other Key Features of Stored Processes Skills Needed SAS Products Required Summary Chapter 2: Developing Applications Development Models Freestyle Approach V-Model Agile Architectural Concepts Useful Documents to Produce Source Control Systems Environments for Developing Web Applications Ways to Develop with SAS Commonly Used SAS Tools Write Your Own Tools in SAS Simple Techniques for Building Applications with Stored Processes Useful Tools for Building Web Applications Lint Tools IDE Tools Using a JavaScript IDE JavaScript Debuggers Code Comparison Tools Summary Chapter 3: HTML Importance of Using HTML5 HTML Basics FORM Tag Ways to Generate HTML Basic ODS Custom HTML PROC STREAM Writing Your Own Custom HTML STPBEGIN and STPEND Macros General Techniques to Add HTML to a Web Page Macro Language HTML Forms Making a Stored Process Generate Its Own HTML Menu Form Attributes Persistence – How to Pass Data Between Stored Processes Storage Cookies Files or Tables URL Where to Put HTML Code, JavaScript Libraries, Images, and More? Summary Chapter 4: JavaScript Basic Example of a JavaScript Program Writing and Testing Debugging JavaScript Using JavaScript with HTML Basic DOM Using Stored Processes to Generate Pure JavaScript How Data Is Stored and Used How SAS Stored Processes Can Feed Data to Objects More About Where to Put Files on Your Web Server Directories Relative Paths Specifying Libraries Building Interactivity with JavaScript Pop-Up Windows Validating Form Fields Linking to One or More Other URLs Summary Chapter 5: JavaScript Libraries Benefits of a Library Choosing a JavaScript Library to Use As a Framework Recommended Libraries Content Delivery Networks (CDNs) jQuery Getting Started Selecting Elements in jQuery Selecting by Tag Name Selecting by ID Selecting by Class Other Ways to Select Things Fundamental jQuery Techniques Actions Summary Chapter 6: Data Dynamic Data Using Stored Processes to Create Dynamic Data How SAS Stored Processes Can Feed Data to Objects Static Data CSV Making a CSV with a Data Step Using PROC EXPORT to Make CSV SASHELP.SAS in CSV XML Reading XML Data into SAS Using the XML Engine to Create SASHELP.CLASS in XML JSON Example of JSON Read in JSON Using JSON Lint Using a Data Step to Make JSON Using Proc JSON SASHELP.SAS in JSON Summary Chapter 7: Stored Processes Converting a SAS Program into a Stored Process Creating a Stored Process Creating a Stored Process with Management Console Prompting from Management Console Using Enterprise Guide to Make a Stored Process Prompting in Enterprise Guide Modifying a Stored Process Choosing a Prompt Type 1. Text 2. Text Range 3. Hyperlink 4. Numeric 5. Numeric Range 6. Date 7. Date Range 8. Time 9. Time Range 10. Timestamp 11. Timestamp Range 12. Data Source 13. Data Source Item 14. File or Directory 15. Color 16. Data Library 17. Variable Adding Dependencies Using Input Streams and Output Prompts Summary Chapter 8: SAS Stored Process Web Application Index Page Sample Stored Processes Reserved Macro Parameters Macro Variables Used with %stpbegin _ACTION Combining Values on _ACTION JSPs Used with _ACTION=FORM _DEBUG _GOPT_DEVICE _GOPT_HSIZE _GOPT_VSIZE _GOPT_XPIXELS _GOPT_YPIXELS _GOPTIONS _ODSDEST _ODSOPTIONS _ODSSTYLE _ODSSTYLESHEET _RESULT Automatic Macro Variables in Stored Processes Run via SAS Stored Process Web Application _METAPERSON _METAUSER _PROGRAM _SRVNAME _SRVPORT _STPERROR _URL _USERNAME How to Use Macro Variables Step-by-Step Guide to Building a Web Application Using Stored Processes Step 1: Query Builder Step 2: Convert Query into Stored Process Step 3: Modify Stored Process Step 4: Access Stored Process Web Application Step 5: Run Stored Process from Excel Step 6: Adding Graphs Step 7: Apply a Parameter A Note About Authentication Creating an HTML Menu for Our Stored Process Step 8: Use HTML Forms to Run Stored Processes Uploading Files with a Stored Process Example: Uploading Three Files Passing Multiple Parameters of the Same Name How to Use Sessions Sessions with Graphs Logs That Record Information About Stored Processes Stored Process Server Logs Workspace Server Logs Pooled Workspace Server Logs Metadata Server Logs Object Spawner Logs Linking Stored Processes Stored Process Example Loading a Stored Process into Part of a Web Page Other Recommended JavaScript Libraries Grids jqGrid Highcharts D3 Summary Chapter 9: SAS Procedures PROC STP PROC JSON PROC STREAM Streaming with a Data Step Streaming with PROC STREAM Streaming RTF Files with PROC STREAM DOSUB PROC HTTP Example Accessing a Web Page Example Using a Web Service PROC EXPORT Use Code with a Macro Variable for the Table Name Call Stored Process Passing Parameter for Table Use Code in JavaScript to Feed Objects PROC IMPORT Summary Index