cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Carbon
‎09-14-2018
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Extracting dosage and unit of measurement from a string variable

by Calcite | Level 5 in SAS Programming
‎09-13-2018 07:54 PM
‎09-13-2018 07:54 PM
Hello,   Thank you kindly for your time to reply to my question. Much appreciated.  Best regards, ... View more

Re: Extracting dosage and unit of measurement from a string variable

by Calcite | Level 5 in SAS Programming
‎09-13-2018 02:36 AM
‎09-13-2018 02:36 AM
Hello,   Thank you very much for getting back to me and your feedback. I can now provide a detailed extract of my data (substring of interest is highlighted):   DRUG 10MG TAB (INGREDIENT) DRUG 10MCG/HRTRANPATCH (INGREDIENT) DRUG50MCGTAB (INGREDIENT) DRUG 50/8MG TAB (INGREDIENT, INGREDIENT) DRUG100/25TAB (INGREDIENT; INGREDIENT) DRUG13.125GSACH (PWDR) (INGREDIENT 3350; INGREDIENT; INGREDIENT) DRUG SZ 50MG TAB DRUG SZ 500MGCAP DRUG 5MG/ML MIXT (INGREDIENT) DRUG 20MCG/H DRUG 3.3G/5ML DRUG 1.25G BLUE (INGREDIENT BLUE 1.25G TAB) DRUG D 1000IU CAP DRUG500MG/5MLTEXT (INGREDIENT INGREDIENT) DRUG240 240MG/5 EL (INGREDIENT) DRUG SR-CAP 200MG/25MG (INGREDIENT/INGREDIENT) DRUG 5/2.5MG TAB (INGREDIENT;INGREDIENT) DRUG TAB 310/.35MG (INGREDIENT; INGREDIENT) DRUG MR-TAB 100MG 100MG MR-TAB (INGREDIENT) DRUG 5/5 5MG/5MG TAB (INGREDIENT/INGREDIENT) DRUG 600MG/200IU TAB (INGREDIENT & INGREDIENT)   The units of measurements are determined as g, mg, mcg, ml and iu. In terms of issue with two drugs, there is a variable that identifies two generic components of medication (INGREDIENT) using the ATC code. I just need to extract the corresponding dosage values and units.    Could you please give me an example of using prxposn based on my data. I understand that it also involves prxparse and prxmatch, but have very sketchy understanding of these commands.    Thank you.  ... View more

Extracting dosage and unit of measurement from a string variable

by Calcite | Level 5 in SAS Programming
‎09-12-2018 12:46 AM
‎09-12-2018 12:46 AM
 Hello,   I need to create two variables - one with dosage (number) and another with units of measurement (string - mg, mgs, mL or iu) using free text medication records that do not appear to follow any structured pattern and some of them have entries that complicate scanning the digits, for example:   DRUG 357860 25mg TAB - [problem: two numbers and only one of them is dosage, another is a part of drug name] Drug_1/Drug_2 1 liquid 50/8mL - [problem: two numbers for two different drugs separated by /] Drug 250mgs TAB (250mgs) - [problem: double entry of the same dosage] Drug 80 iu text - [space between dosage and unit]   The predominant format is DRUG NAME 123mg TEXT. The observations that have two drugs with two dosage values would create two variables with two separate dosages - Drug 1 and Drug 2.   I tried to use scan and compress, but I don't know how to separate numbers that are part of a drug name from dosage values. Any ideas on how to approach this?   I would appreciate any advice. My apologies if I missed similar postings. I tried to search, but couldn't find an exact match.    Thank you, ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-14-2018 12:36 AM
Quick links