CCMDB Data cleaner.mdb general information: Difference between revisions
TOstryzniuk (talk | contribs) mNo edit summary |
TOstryzniuk (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
* | *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 an Access program which is also know as [[data cleaner.mdb]] program. | ||
*It is located on Pagasa's C drive (need more information). | *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. | *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. | *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. | *[[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. | ||