It's hard to know if you have any variables that are numeric, but you treat as strings in the table and the opposit. So, first you can verify that the variables &COMPANY_NAME._S34, &COMPANY_NAME._S33 and c&Company_name._33v34 are strings. And that the variables FlagSingle, FlagCLEAN_UNI_NAME and FlagTHE are numeric. I can't see what you are doing with the macro input variable No. Try using options mprint mlogic symbolgen; Btw, should it be c&Company_name._33v34? that is, should the c be infront of the company name? Another way to find the culprits would be to temporarily remove half the code it to try to find the row that gives the error. Then remove half of the code again and so on, till you find it! 🙂 Also, I would probably use the compbl(stringVar) function, it removes multiple blanks from a character string. So, no need to have double checks for double and triple spaces.
... View more