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

handouts MEL question

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

4 Users

0 Reactions

79 Views

RSS

sgoru

(@sgoru)

Posts: 14

Eminent Member

Topic starter

Hi,

I need to add a MEL expression in a handout.

patients aged 20 years and older who do NOT have an active diagnosis of hypertension

how do i write this?

I tried doing like below but getting compiler error.

{IF (PATIENT_AGE()>=18 and match(PROB_AFTER("delimited"),1,"ICD-401.9") == 0) THEN "yes" ELSE "no" ENDIF}

i'm getting below compiler error:

{IF (PATIENT_AGE()>=18 and match(PROB_AFTER("delimited"),1,"ICD-401.9") == 0) <-COMPILER ERROR NEARBY: Expect THEN keyword or COMMA. Instead had IDENTIFIER after RIGHT PAREN

can you suggest something please?

Posted : January 19, 2015 11:36 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

You know, I have never seen "AND" or "OR" used in MEL syntax. I wonder if you need to nest the IF statements to create that logic?

Posted : January 21, 2015 3:22 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Worked fine for me in a quick text after replacing all the quotes from the copy with quotes in Notepad++

{IF (PATIENT_AGE()>=18 and match(PROB_AFTER("delimited"),1,"ICD-401.9") == 0) THEN
"yes" ELSE "no" ENDIF}

Posted : January 21, 2015 1:11 pm

sgoru

(@sgoru)

Posts: 14

Eminent Member

Topic starter

I tried the same.. re-typed everything in notepad and copy pasted in EMR, then everything worked. strange! but thank you.

Posted : January 22, 2015 3:27 am

dsacco00

(@dsacco00)

Posts: 6

Active Member

The issue is smart quotes. Those are the fancy quotation marks the text editor pulls in to make it look nicer, which are NOT the same generic quotation marks in standard text. This is a problem that drives me crazy in writing scripts. If there's a nonprinted character in there, or something else nonstandard, it gives you unhelpful error messages. I've had occasion where I couldn't figure out what was wrong with my code, so I just erased the original and retyped it, and it worked fine, with no apparent difference between the texts.

One caveat with the above script - I'd use "ICD-401", rather than "ICD-401.9". ICD-401.9 is only one subset of hypertension, with the rest being 401.x

Dave

Posted : January 30, 2015 5:15 am

sgoru

(@sgoru)

Posts: 14

Eminent Member

Topic starter

My code is actually working with "ICD-401.9" as well. like you said, when i typed the whole expression in notepad and copy pasted in EMR, it works.

Posted : January 30, 2015 5:20 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 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