Hi everyone,
I am doing data cleaning and I would like to drop a lot of string "values" from a string variable.
I tried this expression with almost 100 strings, but the expression too long:
Could anyone give me a hint to do this in a better way, please?
Thanks a lot!
Michael
I am doing data cleaning and I would like to drop a lot of string "values" from a string variable.
I tried this expression with almost 100 strings, but the expression too long:
Code:
drop if inlist(description, "A.C.", "A.U.S.A.", "ABBEY", "AC CARS", "AC COBRA", "ACERBI", "ACI", "ACURA", "ADRIA", "ADRIA MOBIL", "ALKO-KOVER, ...") expression too long r(130);
Thanks a lot!
Michael
Comment