Transcript slides
PharmaSUG China 2012 SAS® Data Query and Edit Checks with HTML5 Sy Truong, Meta-Xceed, Inc., Fremont, CA Overview • Data Step to HTML5 Google Like Query • Functionality First • Software Validation • Implementation Lesson Learned • Concluding Thin Client Suggestions 2 SAS® Data Query and Edit Checks with HTML5 "We have found that offering a highquality user experience leads to increased traffic and strong word-ofmouth promotion." - Sergey Brin Co-Founder Google 3 SAS® Data Query and Edit Checks with HTML5 Data Step to HTML5 and XML • Obtaining Optimal User Experience • Desktop to Flash to HTML5 • Users Expect Google, Facebook and Amazon • Delivery DATA STEP and SQL to All Users 4 SAS® Data Query and Edit Checks with HTML5 Functionality Driven Development • • • • • • • 5 Browser Access Searching and Viewing Data Query Expression Builder Compounded Queries Derived Variables Joining Data Frequency and Means SAS® Data Query and Edit Checks with HTML5 Formal Validation • Change Request 6 SAS® Data Query and Edit Checks with HTML5 Formal Validation • Automating IQ – Installation Qualification 7 SAS® Data Query and Edit Checks with HTML5 Formal Validation • Automating IQ – Installation Qualification 8 SAS® Data Query and Edit Checks with HTML5 Formal Validation • Steps of OQ – Operational Qualification 9 SAS® Data Query and Edit Checks with HTML5 Formal Validation • Effects of PQ – Performance Qualification 10 SAS® Data Query and Edit Checks with HTML5 Software Implementation • Step 1 – Authenticate Users 11 SAS® Data Query and Edit Checks with HTML5 Software Implementation • Step 1 – Authenticate Users HTML Form 12 SAS® Data Query and Edit Checks with HTML5 Software Implementation • Step 1 – Authenticate Users Error Check 13 SAS® Data Query and Edit Checks with HTML5 Software Implementation • Step 2 – Viewing SAS Datasets 14 SAS® Data Query and Edit Checks with HTML5 Software Implementation • Step 2 – Viewing SAS Datasets 15 SAS® Data Query and Edit Checks with HTML5 Software Implementation • Step 2 – Viewing SAS Datasets 16 SAS® Data Query and Edit Checks with HTML5 Software Implementation • Step 2 – Viewing SAS Datasets 17 SAS® Data Query and Edit Checks with HTML5 Software Implementation • Step 3 – Creating a Query where age > 18 ; 18 SAS® Data Query and Edit Checks with HTML5 Software Implementation • Step 3 – Creating a Query 19 SAS® Data Query and Edit Checks with HTML5 Software Implementation • Step 3 – Creating a Query 20 SAS® Data Query and Edit Checks with HTML5 Software Implementation • Step 4 – Managing and Running Queries Combine Criteria: Criteria 1 and (Criteria 2 or Criteria 3) 21 SAS® Data Query and Edit Checks with HTML5 Software Implementation • Step 4 – Managing and Running Queries 22 SAS® Data Query and Edit Checks with HTML5 Software Implementation • Step 4 – Managing and Running Queries 23 SAS® Data Query and Edit Checks with HTML5 Users Perspective • No Programming Necessary • No Installation Required • Ubiquity Access 24 SAS® Data Query and Edit Checks with HTML5 Conclusion • • • • 25 Automate Task with User Interface Simplicity of Google Like Interface Marriage of HTML5 Frontend and SAS Backend Minimal Approach is Effective SAS® Data Query and Edit Checks with HTML5 Contact Information Sy Truong E-mail: [email protected] 26 SAS® Data Query and Edit Checks with HTML5