Hello everyone,
I have three variables, drug_ID, drug_name, and strength. Here is an example of the data format for these three variables:
drug_ID drug_name strength
1 A/B/C 5 mg-10 mg-5 mg
2 D 10 mg
3 E/F 7 mg-15mg
4 E/B 13 mg-8 mg
where A, B, ... are active ingredients of a drug. As you can see, for each observation, each active ingredient has a specific strength (in dosage). Also, note that A, B, ... are just examples. In the data, each ingredient may have different strings, e,.g., A = acetaminophen, B = codeine, etc.
Now, my question is that how can I return the strength for each active ingredient for each drug_ID? For example, for drug 1, I need to return 5, 10, and 5 mg for A, B, and C, respectively. Any help/idea is appreciated!
You can use SCAN function on both variables.
Please post how do you want to format your output ?
you could try something as below
data have;
input drug_ID$ drug_name$ 16- 22 strength$ 34-49;
cards;
1 A/B/C 5 mg-10 mg-5 mg
2 D 10 mg
3 E/F 7 mg-15mg
4 E/B 13 mg-8 mg
;
data want;
set have;
do i=1 to countw(drug_name,'/');
drug=scan(drug_name,i,'/');
dose=scan(strength,i,'-');
output;
end;
drop i;
run;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: