SAS Data Integrity Checks: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
No edit summary
Line 4: Line 4:


=== Discussion ===
=== Discussion ===
* I don't think reverse-engineering code is a good idea. Most of these query requests have resulted in further questions, and in order to discuss them they need to be in English, not SAS or SQL. Also, writing them out in English will finally document what is being done. Only Julie knows what she intended with any individual query she wrote, so she would be in the best position to state what checks should be transferred into the [[:Category: Cleaner.mdb Data Integrity Checks | data cleaner.mdb]]. I would suggest concentrating on checks that deal with individual patients for now, rather than checks that compare consecutive encounters, mostly because her implementation is probably more efficient at the latter, whereas ours will be slow at it until we are able to move to a different system. [[User:Ttenbergen|Ttenbergen]] 16:00, 27 October 2008 (CDT)
* I don't think reverse-engineering code is a good idea. Most of these query requests have resulted in further questions, and in order to discuss them they need to be in English, not SAS or SQL. Also, writing them out in English will finally document what is being done. Only Julie knows what she intended with any individual query she wrote, so she would be in the best position to state what checks should be transferred into the [[CCMDB Cleaner.mdb]]. I would suggest concentrating on checks that deal with individual patients for now, rather than checks that compare consecutive encounters, mostly because her implementation is probably more efficient at the latter, whereas ours will be slow at it until we are able to move to a different system. [[User:Ttenbergen|Ttenbergen]] 16:00, 27 October 2008 (CDT)
** Maybe Julie can identify checks that could be pulled ahead into [[:Category: Cleaner.mdb Data Integrity Checks | data cleaner.mdb]]... Ttenbergen 16:38, 2012 November 5 (EST)
** Maybe Julie can identify checks that could be pulled ahead into [[CCMDB Cleaner.mdb]]... Ttenbergen 16:38, 2012 November 5 (EST)




[[Category: SAS Data Integrity Checks]]
[[Category: SAS Data Integrity Checks]]

Revision as of 12:34, 7 November 2012

Julie runs checks that are not in Category:Data Integrity Checks. They are in in the CHK*.sas programs under the

  • X:\Julie\SAS\CriticalCare
  • X:\Julie\SAS\Medicine

Discussion

  • I don't think reverse-engineering code is a good idea. Most of these query requests have resulted in further questions, and in order to discuss them they need to be in English, not SAS or SQL. Also, writing them out in English will finally document what is being done. Only Julie knows what she intended with any individual query she wrote, so she would be in the best position to state what checks should be transferred into the CCMDB Cleaner.mdb. I would suggest concentrating on checks that deal with individual patients for now, rather than checks that compare consecutive encounters, mostly because her implementation is probably more efficient at the latter, whereas ours will be slow at it until we are able to move to a different system. Ttenbergen 16:00, 27 October 2008 (CDT)
    • Maybe Julie can identify checks that could be pulled ahead into CCMDB Cleaner.mdb... Ttenbergen 16:38, 2012 November 5 (EST)