Dear All, I have millions of recorde in a Dataset, need to get selected Names from Name field using contains or Like function in Proc sql; Ex:- Name XXXXX ACADEMY YYYY AGENCES YYYY ZZZZ ZZZZZ ZZZZ AAA COMPANY BBBB BBBB ; Out put should be like Name XXXXX ACADEMY YYYY AGENCES YYYY AAA COMPANY For this Quirey am using proc sql; create table want as select Name from have where Name contains "AGENCES" or Name contains "COMPANY" or Name contains "ACADEMY" or Name contains " AGENCES " or Name contains " COMPANY " or Name contains " ACADEMY " or Name contains " AGENCES" or Name contains " COMPANY" or Name contains " ACADEMY" ; quit; I Have orizinal Name Field Observation Count is 1,00,00,000 selected Name(Contains) count is 5,000 Instead of Conains I can use "Like" function, but it is showing in log window as Macro name is not resolved for some specific Names: Ex: - "%X", "%SYS" Please help me out , how can i create Index on Name field and reduce the system processing time. Thanks in Advance.
... View more