Hi, I have a data file. "data.ods". But this file contain some pattern that I need to replace. (Replace the pattern "|^'|" to "|^-|"). So I implemented a data step to do that and It worked as expected. After this conversion I need to save the results as a new file (data1.txt).   However the data in data1.txt seems got truncated after some number of characters in each row. (data in data.ods has the delimiter |^)   As an example: let say that data.ods looks like this  (using toy data) abs|^ssass|^uuwawaaa|^hdadaaaaaaaaaaaaaaaaaaaaaaaaaaa|^sasasssas 122|^sasa|^'|^sassasasaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaassasasas|^dasas 432|^ssadasa|^sassa|^sassasasaaaaaaaaaaaaaaaaaaaaaaaaaaaahsasaassdada|^ffwa 3122|^sasdada|^'|^sassasasaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaadadada|^fdaaas   Then data1.txt looks like this:   abs|^ssass|^uuwawaaa|^hdadaaaaaaaaaaaaaaaaaaaaaaaaaaa|^sa 122|^sasa|^-|^sassasasaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa 432|^ssadasa|^sassa|^sassasasaaaaaaaaaaaaaaaaaaaaaaaaaaaa 3122|^sasdada|^-|^sassasasaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa   Here is my code: Could anyone help me to resolve this issue?  Thank you very much   filename ipt_file "data.ods"; %let out_file=data1.txt; data _null_; infile ipt_file truncover; file "&out_file" ; input; modified_line = tranwrd(_infile_, "|^'|", "|^-|"); /* Output the modified_line with a new line character */ put modified_line; datalines; run;   ... View more