Hi ,
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
12458999 aripiparzole
23456731 risperidone
45677888 aripiprazole
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
Thanks
Hi I wanted to add to my previous question.
What I actually need is to create a variable to link NDC to drug
For example,
if NDC (12345678 12458999 45677888) then drug= A;
This is what I want to accomplish.
Thanks
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.