CCMDB Data cleaner.mdb general information

• The data cleaning tool is run by the Data Processor.
• It is an Access program which is also know as data cleaner.mdb program.
• It is located on Pagasa's C drive (need more information).
• Original SAS data checking/cleaning queries developed by Julie in SAS who obtained input from Trish, data collectors or others where she needed.
• Tina was developing these checks in Access so that others who are not familiar with SAS programming can run or add additional queries into it when needed.
• Pagasa was running the queries and distributing problem ID, by email, fax or phone to data collectors.
• data cleaner.mdb was outputting many false +ve's, and collectors were complaining about the number of items they were being required to check that were not errors.
• The data cleaner.mdb was reviewed by Trish with Pagasa. The problems found and also the original items in the data cleaning.mdb list from Julie is posted below. The list of checks for this program that were are X drive were also transcribed to this list.
• There are a number of queries that Julie listed that she wanted in Access that had not yet been completed.
• Some of these checks can be included in the Access program that data collectors use before they send there data. These checks should be added there when they are ID'd and taken out of our Data Cleaner.
• Those checks that required TISS data to be available need to be included in this in office data cleaner.mdb program.