11-01-2017 09:21 AM
I have a claims dataset that has RX look up file which contains NDC, GPI, and generic drug name
This is how the look up file looks like
So for example;
NDC generic name
12345678 aripiprazole HCL
Because some generic names has two parts even though they are referring to the same medication (so aripiprazole HCL is the same drug as aripiprazole), I am not sure how to proceed.
I want to be able to group NDC and create a new variable to referred to it
so the new table should look like this
NDC generic name Drug
12345678 aripiprazole HCL A
12458999 aripiparzole A
23456731 risperidone R
45677888 aripiprazole A
11-01-2017 09:44 AM
Hi I wanted to add to my previous question.
What I actually need is to create a variable to link NDC to drug
if NDC (12345678 12458999 45677888) then drug= A;
This is what I want to accomplish.
11-01-2017 09:49 AM