Web-Based Integration of Data Collection and Reporting Based on
Contents
1. Ree Aiea M Atow Sorting Resuts PAORA Check here to generate detailed SAS log and debug report oo a a a aee feel omen oat abet Tesron ownrzns poe vest azo 22 nos ROS 1 oumrzos ocTRORE sing woane asm Po mo __Josocross12 2249 sac 2 04 01 2008 04 21 2008 20080526 BHD ae Src ae aes epee FRS 1 02 03 2008 02 03 2008 o amp o No _ 24aPRo8 22 29 02 DeMons TESTo005 02 11 2008 pone Test eoo 40 wcr wer 1 02 11 2008 02 11 2008 Just testing Sw Not Eligible p5APRos 14 35 28 TESTo006 02 03 2008 pone mest 890 29 wcr wcr 1 02 03 2008 02 03 2008 testing BHD _ NotEigiwe f fsaPRos 14 35 05 monomo foe rer o sae 5e sam coe faeson enoed a o a vo pruners Figure 5 NMDS V Case Management Depending upon the user type a debug feature is available to the user While such debug features are usually not recommended for SAS IntrNet driven dynamic websites the addition of this feature for specific users was deemed acceptable since NMDS V is only accessible via the Kaiser DOR Intranet As the use of SAS IntrNet was new to some Kaiser DOR staff involved in this project use of the debug feature allows a high level SAS user to better understand program flows when familiarizing themselves with the details of the NMDS V system design To handle all the different actions that can be triggered by the screen shown above2. 1000 309 854 sace 4 100 o na 139 525 20 1000 343 808 Pp sa o a a oo 100 20 o so M 4a oo w oo R wo 154 708 wer 2n f 100 4 J oo ns ng 20 93 3 734 s 10 19 oo s amp s 2 998 1980 730 NMDS Data Base Activity as of June 10 2009 Daily NMDS Data Base Activity During the Last 3 Weeks as of June 10 2009 Activity includes Adding New Records as well as Editing Previously Submitted Records NS Ez nL EZ ON C7 Week amp Day of Submission Responsible NMDS Facility MEE Hay MM Not Provided B Not Reviewed I on ME Ros MS sc E scH SFO ME wer Download high resolution PDF version of this chart Figure 9 NMDS V Activity Report Excerpt The database activity report can be used to track the number of records in the data base along with abstractor progress NMDS V KP NCAL Report Choose an Outcome Measure NICU Admissions Select one or more facilities 7 Hayward V Oakland Sacramento Santa Clara V San Francisco Walnut Creek Select Un Select All NMDS Facilities 7 Check to view subset options based on birth date and or birth weight and or gestational age 1 Check to view exclusion options JV Check to view stratification options Stratification variables optional up to 3 M Year of Birth 7 Gestational Age weeks Birth Weight 7 Inborn Outborn Status Dischar
3. Figure 4 NMDS V Administrator Access For instance the user type of data abstractor will be immediately placed in the data entry environment A report user will be placed in the environment for report generation A review only user may access all data and reports but may not modify any data Upon logon the administrator user type is presented with the choices shown in Figure 4 The administrator has access to all data entry functions data base activity reports specific administrator only tasks and all real time reports The administrator only tasks include user management functions such as addition and removal of NMDS V users updating information resetting the password for NMDS V users and other functions In the top right section of each NMDS screen the user id along with additional navigational choices for the current screen is provided DATABASE ACCESS The main case management screen that handles access to the NMDS V data bases is shown in Figure 5 When the screen is initially loaded the bottom panel is empty The user can specify any of the criteria listed at the top to retrieve a list of infant records meeting the selected criteria In the example in Figure 5 the only criterion entered was the MRN All infants are displayed in the list whose MRN starts with the four characters TEST NMDS V KP NCAL Case Management said MRN TEST _ EF Mom MRN Last Name _ DOB From To Fac of Birth Fac zl Elig zl Complete ji z
4. Pie poeg Discharge me aes NMDS Baby FirstName JOHN J oi Ros _ 04 01 2008 04 01 2008 BHD 05 26 2008 No AKA ozjsac o41 2008 o421 2008 BHD _ osv2e2008 No Gender Female z Add Stay Delete Last Stay Date of Birth 04 01 2008 Birth Weight 490 Submit Details Gestational Age 22 First hospital ROS Notes Mother MRN Test a only be added in the Transport History section for NMDS eligible Mother Last Name DONE Once you have added the stay information entered all the information on this enc gt screen and submitted it clicking on a stay s admission date will give you access test date 20080526 BH aa to the data entry screens for the detailed NMDS record The information on this infant was first retrieved from the IC file on Previous comments 26MAY 08 07 22 50 and last updated on 130CT08 09 15 50 New comment NMDS Eligible Ves Regular Stay Figure 6 NMDS V Case Detail Management Key components of one the SAS macros called are shown below S6MACRO getCaseDetails history N 6GLOBAL mrn commonwwwroot maxstays _debug browser sysslash faclist KPlist NMDSlist usertype ieee FILENAME out CATALOG amp _tmpcat caseDetail html header information DATA nulls INFILE amp extHTMLpath sysslash nmdstop html truncover LRECL 2000 FILE out LRECL 2000 INPUT infile 2000 infile RESOLVE infile PUT infile RUN additional header informati
5. _webout INPUT infile S32755 INFILE RESOLVE infile PUT infile RUN SEND SELSE DO valid logon 6LET rco sSYSFUNC APPSRV_SESSION CREATE 3600 DATA _NULL_ SET kaiser users READ xxxxxxX WHERE userid 6userid AND pw amp Password CALL SYMPUT keycode keycode CALL SYMPUT usertype usertype RUN SdisplayMessage SEND MEND logonKaiser If the user is not found or if the password is incorrect the program copies an invalidlogon html file that resides on the application server to the _webout destination see Figure 3 Logon NMDS V NCAL KP DOR INVALID UserlD and or Password Try Again Figure 3 NMDS V Failed Logon If the logon credentials are authenticated the user can start using the application NMDS V FEATURES SUMMARY Describing each of the NMDS V features in detail is beyond the scope of this presentation therefore this section briefly outlines each function and how it was implemented SAS DATA SETS Since SAS is the primary analytic tools used by the DOR selecting SAS data sets for all NMDS V data files was a logical choice USER SPECIFIC FEATURES The logon process not only authenticates the user but also associates a user type with each user The set of NUDS V features or modules that appears after the logon process is specific to each user type NMDS V KP NCAL Administrator Logon NMDS V Data Entry Transport Database Data Base Activity Administrative Tasks NMDS Reports
6. END ELSE DO Go here if there are mo Observations in sub ea SEND ee DATA _null_ INFILE amp extHTMLpath amp sysslash LOWCASE getCaseDetails html truncover LRECL 2000 FILE out LRECL 2000 MOD INPUT infile 2000 infile RESOLVE infile PUT infile RUN DATA _NULL_ FILE out LRECL 2000 MOD p PUT lt form name CcaseManagement action amp URL method post gt PUT lt input type hidden name ToDo value caseManagement gt PUT lt input type hidden name _program value progs nmds sas gt PUT lt input type hidden name _service value amp service gt PUT lt input type hidden name _debug value amp debug gt PUT lt input type hidden name _sessionid value amp sessionid gt PUT lt input type hidden name keycode value amp keycode gt PUT lt input type hidden name userid value amp userid gt PUT lt input type hidden name _server value amp server gt PUT lt input type hidden name _port value amp port gt PUT lt form gt Leal PUT lt body gt PUL t lt ptnl at RUN DATA _NULL_ FILE _webout URL amp _replay caseDetail html PUL lt Seripe gt 7 location replace Tr url altel Tat y LASOPI eae RUN SMEND getCaseDetails DATA ENTRY PHASE II Providing detailed eligibility information via the N
7. L SLET logfilefolder home xxx intrnet nmds5 logs SLET sysslash STR OPTIONS MAUTOSOURCE SASAUTOS amp nmdsprgs maclib sasautos SLET edsfiles amp nmdsroot cpqcc edsfiles SEND SMEND initialize initialize S6LET nmdsFromEmail nmdssupport nsmtp kp org S6setOptions S6LET errorcode 0 6LET maxstays 24 sgonmds The program nmds sas also performs several initialization tasks As many of the SAS modules used by NMDS V were developed in a windows environment several global variables that are needed by the application are defined system specific After the initialization step is complete yet another SAS macro is called sgonmds In fact each request that comes from the web server is routed to this gatekeeper macro Depending upon the ToDo parameter sent with the web form the macro gonmds routes the request to the correct SAS program Peal ZLE amp ToDo EQ logon THEN DO S6logonkaiser SEND Kee For the logon request the macro logonkaiser is called This macro finally checks the supplied userid and password against a password protected database with allowed users S6MACRO logonKaiser 6GLOBAL userid password keycode browser usertype sysslash DATA check SET kaiser users READ xxxxxx WHERE userid userid AND pw amp Password RUN SLET valid snumobs check SIF amp valid 0 THEN SDO invalid logon 6LET keycode FAILED DATA _NULL_ INFILE amp extHTMLpath amp sysslash invalidlogon html TRUNCOVER FILE
8. MDS V screen shown in Figure 6 initiates an NMDS record for an eligible infant As a customized data entry system NMDS V allows several types of eligibility For instance an infant might have been in the NICU for less than 24 hours and mostly for observation This eligibility type will require a different set of forms compared to an acutely ill infant Depending upon eligibility type NMDS V will provide the appropriate set of forms Note that NMDS V is a stay based system in other words if an infant had stays at several different hospitals data for each stay is collected separately The forms needed to enter stay information for each eligible infant can be accessed in two ways Through the screen shown in Figure 5 by clicking on the stay number in column 9 or through the screen shown in Figure 6 by clicking on the stay number in the Transport History table The screen that opens up once a user has clicked on the stay number is displayed in Figure 7 The top section cannot be edited by a user and Is used to display key information on the infant and stay that is currently abstracted The navigation band highlights the default abstraction form the ID or Infant Demographic form The navigation form gives access to all abstraction forms applicable dependent on eligibility type stay number and infant disposition The HTML needed for each abstraction form is stored on the application server A user request for a specific form triggers a SAS program on th
9. Web Based Integration of Data Collection and Reporting Based on SAS Foundation Technologies Beate H Danielsen Health Information Solutions Rocklin CA Soora Wi Kaiser Permanente Division of Research Oakland CA Eileen M Walsh Kaiser Permanente Division of Research Oakland CA ABSTRACT The variety of database statistical analysis and reporting software products available to today s organizations makes it increasingly difficult to identify the best combination of products that fits the needs of a project Many factors have to be considered when making this choice such as product features product support support staff timeline long term planning ease of use and product stability Faced with the challenges of supporting a legacy web based data collection application that utilized Java JavaScript and Oracle and an increasing demand for rapid generation of reports and data sets the Northern California Kaiser Permanente s Division of Research DOR decided to move its regional registry of neonatal intensive care patient outcomes to a SAS driven web based application This presentation summarizes how the SAS system was used to create a web based application called the Neonatal Minimum Data Set NMDS to provide a one stop solution for a data collection b data reporting c analytic data base generation d advanced reporting including sophisticated analytical methods and e monitoring of specific QI goals by clinical staff across th
10. e Northern California region 174 words INTRODUCTION The Kaiser Permanente Neonatal Minimum Data Set NMDS is in its fifth version NMDS V of on line data collection from Kaiser Permanente s Neonatal Intensive Care Units NICU permitting rapid retrieval of neonatal and perinatal care Statistics From its inception NMDS has created a high quality data repository that establishes relationships between demographic diagnostic and physiologic factors with associative outcomes of in hospital deaths duration of stays major invasive procedures and major morbidity data to conduct complex statistical outcome and research analyses Additionally the NMDS has served as a go to resource for various internal and external reporting requirements Before launching NMDS V with the SAS system NMDS evolved from MS Access to SQL to Oracle Although the NUDS using Oracle satisfied the continual need to collect data and provide a data repository for research the maintenance and ease of enhancements were challenging Specifically the system required a single staff member to understand an array of tools such as HTML JSP JDBC Oracle tables triggers stored procedures and SAS Therefore adding a new variable required a significant amount of expertise and time Additionally for ease of use for all staff the Oracle tables were periodically converted to SAS and the application did not provide any on line static or dynamic reports Since the DOR utiliz
11. e application server that will load the correct form and generate JavaScript to populate the form with any information that has previously been stored in the NMDS data bases NMDS V KP NCAL Data Entry Baby MRN TESTOO01 Last Name DOE First Name JOHN DOB 04 01 2008 Stay Number 2 or Stay Facility sac Admit Date 04101 2008 Disch Date 0421 2008 Stay Type REG Admin E P sa w sp VENT OD Region moo q Infant and mother comment MRN TESTOOO1 maternal drug use during pregnancy BHD Baby Last Name DoE i Baby First Name JOHN AKA Gender Female A Birth Weight 490 grams Head Circumference 89s cm Birth Sequence 1 of iz Date Time of Birth Date 040172008 Time 23 30 m Gestational Age Weeks 22 Days 6 First Hospital Birth Location Othe E Apgar Scores 4 Min M Not Done 5 Min 5 Not Done 10 Min V Not Done Any DRR ves E aa i Cardiac Delivery Room Oxygen Yes z Bag Mask Yes z TE es E R citation a D SE Epinephrine No J EndotrachealTube No Suction formEc No E cpap i Infant Exposed to Drugs Cocaine Crack Only lf Other or more than 1 drug enter description E Fetal Complications IUGR Y z Distress N B Anomaly lv Other x Description 7 Figure 7 NMDS V Data Entry ID Section JavaScript is also used to verify the consistency of information entered within each section a
12. eate health info solutions com Web http www health info solutions com SAS and all other SAS Institute Inc product or service names are registered trademarks or trademarks of SAS Institute Inc in the USA and other countries indicates USA registration Other brand and product names are trademarks of their respective companies
13. es SAS for its primary statistical and data management tool it was evident that NUDS V use SAS technologies The following paper provides an overview of SAS Foundation Technology methods specifically Base SAS SAS Graph and SAS IntrNet used not only to collect and maintain a rich research database but to enhance NMDS with advanced reporting and QI monitoring NMDS V APPLICATION GOALS Based on experience with the previous data collection mechanisms the following goals were set for NUDS V e Web based e User friendly environment for data abstractors with relevant help screens and an intuitive user environment e SAS data sets e Production application ready in fewer than 6 months e Data integrity features that check for data consistency issue error alerts record completeness e Integrated user management of at least 5 different user types administrator abstractor transport system specialist reviewer report generator with different levels of database and system access ability to handle up to 20 concurrent users e Integrated support of database generation to meet needs of multiple constituents national and statewide patient outcome registries payer sponsored quality benchmarking programs and regional and local QI initiatives by KP clinical staff e Integrated reporting on user database and analytic activity e SAS programming for adding deleting maintaining databases and all reporting features e Ability to archive older da
14. ge Disposition 7 SNAP I Score 7 S minute APGAR Check here to generate detailed SAS log and debug report Subset Options Date of Birth None Gestational Age None Birthweight None Exclusion Options Delivery Room Deaths Download as Excel File NICU Admissions 3239 m ns on at soar et es Figure 10 NMDS V Analytic Report NMDS V allows analytic reports on NICU volumes as well as a variety of process and outcome measure of NICU performance such as use of antenatal steroids nosocomial infections surfactant treatment chronic lung disease surgeries ROP etc The report allows several customization options As the data base reporting module had secondary priority this is the area that will see the most changes and improvements in the coming year INTEGRATED SUPPORT OF DATABASE GENERATION TO MEET NEEDS OF MULTIPLE CONSTITUENTS One major goal of the NMDS V application was support of the generation of secondary databases needed for the participation in national QI programs One such program is the California Perinatal Quality Care Collaborative CPQCC http Awww cpgcc org All NUDS V Kaiser facilities participate in this QI effort One participation requirement is the submission of information on selected NICU infants The automatic generation of CPQCC compliant data bases has been fully integrated into NMDS V see Figure 10 NICU infant eligibility for CPQCC ID assignment for the purpose of CPQCC data updates and CPQCC rec
15. he parameter _service processes the request to the correct application server The parameter _program identifies the SAS program that is run on the application server in response to the request in this case the program nmds sas is called which has to be present in the program library progs that must be defined on the application server The parameter ToDo is also sent with this request It is needed for the program nmds sas to run correctly Once this form is successfully processed by the web server and sent as a request to the application server the application server will process it by running the SAS code in nmds sas shown below SMACRO initialize 6GLOBAL commonwwwroot nmdsroot extHTMLpath wzpath logfilefolder sysslash faclist KPlist NMDSlist edsfiles SLET faclist ZLET KPlist LET NMDSlist HAY OAK WCR SCH SFO SAC SIF amp sysscp EQ WIN THEN DO SLET commonwwwroot nmds SLET nmdsprgs c projects Kaiser DOR SLET nmdsroot c projects Kaiser DOR SLET extHTMLpath amp nmdsprgs externalHTML SLET logfilefolder c SASInt 1 nmds logs SLET wzpath c progra l utilit l winrar SLET sysslash STR OPTIONS MAUTOSOURCE SASAUTOS amp nmdsprgs maclib sasautos SLET edsfiles c projects Kaiser l1 cpgqcec edsfiles OPTIONS NOXWAIT 7 not a unix option SEND SELSE DO SLET commonwwwroot SLET nmdsroot home xxx nmds5 app SLET nmdsprgs home xxx nmds5 app SLET extHTMLpath amp nmdsroot externalHTM
16. ion was in use for several months users asked for the ability to easily generate a list of infants along with the list of items not yet abstracted The flexibility of the chosen environment allowed this implementation with ease DATA ENTRY PHASE Data entry occurs in two phases In the first phase eligibility of each NICU infant is ascertained and information from all stays at a Kaiser facility along with basic demographic information is captured Eligibility screening of all infants born at a Kaiser facility or transferred to a Kaiser NICU occurs primarily through a case finding program that queries the KP admission discharge databases pertaining to a maternal and newborn record This process is complemented by the inspection of delivery room and NICU logs Clicking on any of the MRN hyperlinks in the result table in Figure 5 triggers the submission of an associated form and generates the screen shown in Figure 6 through the gatekeeper program gonmds sas see page 3 SIF amp ToDo EQ getDetails THEN DO SIF SSTR amp mrnil EQ NEWMRN STHEN SLET waitmsg STR Loading Case Detail Screen SELSE SLET waitmsg STR Retrieving Details for Infant 6getCaseDetails history yY SEND fal Information present on the requested case is pulled from the NMDS V databases and used to populate the form NMDS V KP NCAL Case Management Details Details of eligibility Transport History MRN TEST0001 Click here for help Baby Last Name DOE
17. nd across sections Data entry errors are clearly marked as shown in the example in Figure 8 Baby First Name DONE AKA The page se x Gender Female E j Birth Weight 490 grams aiiin aber is invalid Head Circumference 189 cm Please correct Birth Sequence E of 2 Date Time of Birth Date 04 01 2008 Time 23 30 Figure 8 NMDS V JavaScript Error Checks Upon submission of each form hidden form variables route the submission to the SAS application server lt input type hidden name ToDo value updateTheme gt lt input type hidden name theme value ID gt lt input type hidden name Stay_no value 1 gt lt input type hidden name st_ent_dt value gt lt input type hidden name _program value progs nmds sas gt lt input type hidden name _service value nmds gt lt input type hidden name _debug value 0 gt lt input type hidden name _sessionid value SyylIAyDL52 gt lt input type hidden name _server value nmdsserver gt lt input type hidden name _port value 51028 gt lt input type hidden name userid value XYZ gt lt input type hidden name thisusertype value admn gt A section in the gatekeeper macro goNMDS sas see page 3 allows us to identify the SAS macros called for each abstraction area SELSE SIF amp ToDo EQ updateTheme THEN DO SupdateTheme am
18. on specific for getCaseDetails DATA _null_ INFILE amp extHTMLpath sysslash SLOWCASE getCaseDetailsHead html truncover LRECL 2 000 FILE out LRECL 2000 MOD INPUT infile 2000 infile RESOLVE infile PUT infile RUN DATA sub LENGTH facVisl facVis12 3 SET nmds allInfants WHERE COMPRESS mrno EQ amp mrnI AND _recent EQ Y CALL SYMPUT updsrc _ updsSrc RUN PA define populateForm function to populate the form with the information for the selected MRN SIF SEVAL Snumobs sub gt 0 THEN DO DATA _null_ SET sub FILE out LRECL 2000 MOD PUT lt script type text javascript language JavaScript gt Ls PUT lt PUT function populateForm PUT document CMDETform mrnI value mrno IF nm_1 gt THEN PUT document CMDETform inf_lname value nm 1 1 IF nm f gt THEN PUT document CMDETform inf_fname value nm f 1 IF sex gt THEN DO PUT i for var 1 0 1i lt document CMDETform sex options length it PUT if document CMDETform sex options i value sex 1 PUT document CMDETform sex selectedIndex i PUT bt END ae PUT i PUT gt PUT lt seript gt PUL lt 7 tead gt PUT lt body style margin top 10px margin left 2px margin right 2px Q7 PUL onload javeascripl pOopulbacverorm 4 gt PUT lt form name CMDETToOrm action Mg URL method post RUN S
19. ord management is accessible through the CPQCC management administrator feature This integration alone has saved hundreds of data entry hours NMDS V KP NCAL CPOCC Administration Bany uan croceo Fat SFO E 008 From bom eassn Doom E ay eae Assign CPOCC Ds A Retesh Lint A Gererate EDS Fie amp Anhesh List 7 Chack here to generate fie wit af records isted not wal Dose Changes once last LOS Me ee io generate detaies SAS bg and desu U records found Chick on Stay lumber te oo to NOG screena Click on he CPOCC ID te view the nformabon sant to CPOCC Gort table by Column Dy clicking of cauma heaser S B se Vomerete Least EDS File EDS File Dete inetd 1auNow 14 474 ve O44 DSO4ISPULENOR 13 31 OF p awe 1aunow 14 47 4 ves 044 S082 TER pI ziza Mo FMES 0440 DSO42S ena j 1 JUNOT 14 57 38 tet No O1AUNOG 14 474 aE T soars Figure 11 NMDS V Integrated CPQCC Administration Another data collection and reporting requirement handled by NMDS V is a transport component California Perinatal Transport System CPeTS collecting additional data on acute infant transports Additionally the NMDS V datasets are used to generate hundreds of ad hoc reports on clinical indicators of interest to perinatal clinicians and organizational leadership at the individual hospital and aggregate regional levels NEXT STEPS After successfully implementing the core set of features integration of legacy data and additional reporting functions will expand the u
20. p theme update with information entered by user doTheme amp theme ve display screen SEND a NMDS V CONTEXT SENSITIVE HELP For each item collected on the abstraction form context sensitive help is available by clicking on the item header The help information is available as static HTML files residing on the web server these HTML files are generated using SAS based on the user manual While the help screen HTML files on the web server have to be updated each time the user manual is changed the update steps require no user intervention besides running the SAS program and uploading the generated HTML to the web server As user manual updates are infrequent this implementation route was easy and acceptable INTEGRATED REPORTING ON DATABASE ACTIVITY AND ON NICU STATISTICS Users with administrator rights can at any time generate current database activity reports The reports show the volume of infants likely eligible partially and fully abstracted by user NMDS facility and other key variables An excerpt of the report is shown in Figure 9 NMDS Record Completeness by Responsible NMDS Facility through June 10 2009 Click on a column header to sort table by the column values Facility Brief Stays Complete farsa ed neoe anselli Complete Complete Total Stays Complete Not Provided 6 1000 oo 9 100 133 3 a te ot ss 100 2 o j o 40 NA oo 161 9 108
21. s all processing and generates a result in HTML to display back to the user LOGON PROCESS AS AN EXAMPLE This section explains the logon script as a simple example of the control flow in NMDS V Figure 2 shows the logon screen Logon Kaiser Permanente NCAL NMDS V UseriD Password ra Logon Figure 2 NMDS V Logon Screen The logon screen consists of a form requesting a user id and password The relevant part of the HTML form is shown below lt h2 gt Logon Kaiser Permanente NCAL NMDS V lt h2 gt lt table gt lt tr gt lt td style text aligqn right padding top 20px padding right 20px S gt UserlD lt td gt lt td style text align left padding top 20px gt lt tr gt lt tr gt lt td style text align right padding top 20px padding right 20px gt Password lt td gt lt td style text align left padding top 20px gt lt td gt lt tr gt lt tr gt lt td colspan 2 style text align center padding top 30px gt lt td gt lt tr gt lt table gt lt form gt All elements of the form that are sent to the application server upon submission are highlighted Note the use of the action parameter of the form cgi bin broker cgi that instructs the web server to find what action to take by looking at the broker cgi script Also note the parameters that are needed to send this request to the correct place These parameters are hidden to the user T
22. sefulness of NMDS V within the next year CONCLUSION The application was developed in the time frame required and went into production in February 2008 It has been endorsed with enthusiasm by the various staff layers involved Thus far the choice of SAS for all data management and reporting function has been shown to be a stable and dynamic choice Depending upon an organization s needs and level of expertise with SAS our experience has shown that relying on SAS Foundation Technologies for all aspects of data collection analysis and reporting and combined with basic web design tools HTML JavaScript and CSS can be a very successful venture integrating multiple functions in a seamless design with stable performance for multiple simultaneous users RECOMMENDED READING 1 Hendersen D Building Web Applications with SAS IntrNet A Guide to the Application Dispatcher SAS Press 2007 2 Pratter F Web Development with SAS by Example SAS Press 2 Edition 2006 3 Carpenter A Carpenter s complete guide to the SAS macro language SAS Press 2 Edition 2004 4 Flanagan D JavaScript The Definitive Guide O Reilly Media 5 Edition 2006 5 Musciano C Kennedy B HTML amp XHTML The Definitive Guide O Reilly Media 6 Edition 2006 CONTACT INFORMATION Your comments and questions are valued and encouraged Contact the author at Name Beate Danielsen Enterprise Health Information Solutions Work Phone 916 435 4676 E mail b
23. several HTML forms are used For instance along with the visible form components the hidden form components below are associated with the user performing a search lt input type hidden name ToDo value selectCases gt lt input type hidden name casesPresent value N gt lt input type hidden name _program value progs nmds sas gt lt input type hidden name _service value nmds gt lt input type hidden name _sessionid value b21iTnyDL52 gt lt input type hidden name _server value nmdsserver gt lt input type hidden name _port value 51028 gt lt input type hidden name userid value XYZ gt lt input type hidden name _debug value 0 gt Depending upon the user type associated with the userid the gatekeeper program gonmds sas see page 3 routes the request to the execution of the correct set of SAS macros SELSE SIF amp ToDo EQ selectCases STHEN DO SIF amp usertype EQ ro STHEN DO EN selectCases SEND SELSE SDO SCcheckIC S6selectCases SEND SEND fie The list generated has several hot links that allows access to additional screens needed to manage the information abstracted for the NICU patients The case management screen was designed to explicitly address the needs of the NMDS V application based on experience with previous data entry applications and tasks that need to be performed repeatedly and efficiently For instance after the applicat
24. ta perform backups track data edits e Integration of legacy data collected for prior years NMDS V APPLICATION OVERVIEW The NMDS V application requires knowledge of HTML JavaScript Cascading Style Sheets and SAS particularly SAS Macro language HTML is used to interact with the user JavaScript is used to implement dynamic form features such as error checking and issuing user alerts if implausible data points are entered Data is collected on web forms and then submitted to SAS using SAS IntrNet All data sets are stored as SAS data sets The application server service is set up as a Socket service working on one request at a time in the order in which the requests are made This setup was sensible since the total number of concurrent users is small and each type of request is handled in fractions of a second Figure 1 displays the control flow in NMDS V The user initiates a request from a client on the KP intranet through the NMDS web server The web server sends the request to the application server The application server processes the request and sends the result of the request back to the web server The web server handles the display of the result to the client Figure 1 Control Flow in NMDS V Files maintained on the web server include all JavaScript needed to perform error checking a set of HTML documents providing context sensitive help when requested by the user and a set of cascading style sheets The application server handle
Download Pdf Manuals
Related Search