05-03-2016 08:43 AM
I want to search for list of drugs in oracle database. can I list all the drugs in proc sql in where clause as below?
(A.PRODUCT_DESC_1 CONTAINS ('ARIPIPRAZOLE',' ASENAPINE',BREXPIPRAZOLE)
I got ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, )
05-03-2016 09:09 AM
05-03-2016 09:19 AM
The syntax is incorrect, you need a contains for each argument, definitely a bit cumbersome.
A.PRODUCT_DESC_1 CONTAINS ('ARIPIPRAZOLE') or CONTAINS ('ASENAPINE') or ...
05-03-2016 09:44 AM
05-03-2016 10:07 AM
No, like is used for pattern matching. Why are you looking for drug names by the way? Should you data not be encoded with WHODrug codes - that is not only safer (you don't miss ones) its simpler as well because you can use higher level terms to bring out groups of related drugs. Also its standard in the industry.
Need further help from the community? Please ask a new question.