Keep Values of Variable FAERS Database

alamrikd — Wed, 09 Nov 2022 00:02:55 GMT

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

Re: Keep Values of Variable FAERS Database

andreas_lds — Wed, 09 Nov 2022 07:35:48 GMT

Please post the log of all the steps using "insert code" button.

Are you sure that the value is written in all lowercase?

topic Keep Values of Variable FAERS Database in New SAS User

Keep Values of Variable FAERS Database

Re: Keep Values of Variable FAERS Database