SAS® Data Query and Edit Checks with HTML5 Sy Truong, Meta-Xceed, Inc. (MXI), Fremont, CA Ale Gicqueau, Clinovo, Sunnyvale, CA ABSTRACT DATA SQL SAS STEP A SAS A DATA DATA A IT SAS A SAS DATA SAS HTML5 SAS STEP, HTML5 XML DATA SAS NEW (GOOGLE) PARADIGM HTML5 SQL SAS STEP HTML5 (W3C), HTML5. HTML5 SAS The specific project which drove the development of Syview was established when the manager at a multi-national Pharmaceutical company noticed that SAS programmers were spending a lot of time writing one-off SAS scripts to query SAS datasets after it has been exported from the relational database. The request came from different sources including data managers who are skilled with SQL and tools used with the relational database, but are not SAS programmers. This presented an opportunity to have a solution for users who are SAS novices, yet allowing them to perform the same queries through a user friendly interface. Some of the functionality that was requested by these users includes the following: Browser Access The ability to access the data and perform queries from a web browser such as Internet – Explorer. No other software is needed to be loaded on the user’s machine.
SAS® Data Query and Edit Checks with HTML5 Sy Truong, Meta-Xceed, Inc. (MXI), Fremont, CA Ale Gicqueau, Clinovo, Sunnyvale, CA ABSTRACT SQL SAS DATA STEP SAS SAS SAS SAS HTML5 SAS DATA STEP, HTML5 XML SAS NEW (GOOGLE) PARADIGM HTML5 SQL SAS DATA STEP HTML5 (W3C), HTML5. HTML5 SAS The specific project which drove the development of Syview was established when the manager at a multi-national Pharmaceutical company noticed that SAS programmers were spending a lot of time writing one-off SAS scripts to query SAS datasets after it has been exported from the relational database. The request came from different sources including data managers who are skilled with SQL and tools used with the relational database, but are not SAS programmers. This presented an opportunity to have a solution for users who are SAS novices, yet allowing them to perform the same queries through a user friendly interface. Some of the functionality that was requested by these users includes the following: Browser Access – The ability to access the data and perform queries from a web browser such as Internet Explorer. No other software is needed to be loaded on the user’s machine. A IT A A DATA DATA A
sas_data_query.1.12.2012.docx