Hello, I am using FAERS database for my project. I am trying to select only one drug from the variable "drugname". I used where and if statments but I get error all the time.   Here is my code: libname kete'c:\users\alamrikd\Desktop'; run; data kete.drug12q4; infile 'c:\users\alamrikd\Desktop\DRUG13Q1.txt' dlm='$' dsd truncover firstobs=2; input primaryid :$10. caseid :$8. drug_seq role_cod :$2. drugname :$30. prod_ai :$50. val_vbm :$1. route :$10. dose_vbm :$30. cum_dose_chr cum_dose_unit :$7. dechal :$1. rechal :$1. lot_num :$20. _exp_dt :$10. @ ; run; proc contents data = kete.drug12q4; run; proc print data=kete.drug12q4(obs=3); run;   data kete.metformin; set kete.drug12q4; where drugname = 'metformin'; run;     I want select only observations for metformin, could you help me how to subset the data based on that?   Thank you ... View more