Good day, I am having a problem with a multiple values prompt, no matter how many names I put in the prompt, it only returns the first name on the list, in this case it returns records for Hunter and the rest it doesn't. below is the code i am using I tried where clause with 'IN operation, the = operation and now the LIKE operation' but the results are the same. Thank you so much for the assistance. Kind regards data Resident_Name_Search; set FNS_DETAIL_O; where valuedate between "&value_date_min."d and "&value_date_max."d and ( upcase(R_SURNAME_OR_LEGALENTITYNAME) like upcase("&resident_customer") or upcase(R_NAME_OR_TRADINGNAME) like upcase("&resident_customer") or upcase(INDIVIDUAL3PARTYSURNAME) like upcase("&resident_customer") or upcase(INDIVIDUAL3PARTYNAME) like upcase("&resident_customer") ); run;
... View more
