Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

while loop

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

5 Users

0 Reactions

63 Views

RSS

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

Topic starter

Is anyone familiar with "while" loops?

I am trying to run a loop where an array of ICD10 codes is matched against the patient's problem list. I want it loop through all of the ICD10 codes i ask it to until it finds a match.
The FOR-DO loop will slow the search way down. Any help would be GREATLY appreciated. Thanks,

Posted : February 15, 2017 12:53 pm

Lee

(@lee-cooper)

Posts: 348

Reputable Member

Not much difference between a while and for loop. It really is a matter of style.

With the while loop, you exit the loop when your defined condition is no longer met and that has it's uses, but I typically will utilize a for loop with a break command once my condition is met.

for ...

condition met

break

endfor

Does what you want and exits the loop preventing unwanted iterations once your condition is met. I suspect that is your concern?

Posted : February 15, 2017 8:03 pm

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

I do this routinely in identifying patients with a given Dx by IC10 codes. I have a dashboard for monitoring compliance with PQRI/NQF measures which requires this to be done. In addition, I use similar code for checking if the patient is on a given drug class. The code is more than fast enough. If you would like a copy of the code, contact me directly. Delighted to talk to you. Agree with prior post.

Posted : February 16, 2017 3:15 am

carlosjr

(@carlosjr)

Posts: 10

Active Member

If you are doing this through SQL, another option is to join the two sets and see if you have a result. You could store the result in a temporary table and continue on your processing. This will increase your performance because you don't have to loop through every record.

Posted : February 16, 2017 6:03 am

ronmoses

(@ronmoses)

Posts: 158

Estimable Member

I agree with @carlosjr... a table join would be the proper way to achieve this. If you're in CPS, you'd link on PROBLEM.ICD10MasterDiagnosisID > MasterDiagnosis.MasterDiagnosisID. The MasterDiagnosis table will contain the ICD10 code. That should get you what you need.

Posted : February 17, 2017 6:21 am

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

Topic starter

Exactly right. Thank you so much. Works perfectly!

Posted : February 17, 2017 12:32 pm

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0