Hey, I just want to add a comma after a lot of numbers. before 1234567 89012345 after 1234567, 89012345, I have tried it with catx, but it does not function. Then I tried it with cats and on first sight it seems to function. But a closer look showed me that the comma ends as soon as the figure changes from seven-digit to eight-digit. From this point on there are no commas after the numbers. And at the end I want to have the new column in an excel file. But the systems told me that the file cannot be opened or repaired as it is damaged. data want set order order_no_str = put(lngorder_no, 8.); format order_no_str$100.; order_no_str=cats(order_no_str,’, '); If length(order_no_str)>90 then do; put 'ERROR: …'; end; ods excel file '\\abc\agency\…\order2020.xlsx’; run; How can I solve these problems? Thanx a lot! Caro
... View more