I am able to determine the no of spaces on the fly in C#: Public Function replaceTabWithSpace(ByVal lineToReplace As String) As String Dim textWithSpaces = String.Empty Dim textValues = lineToReplace.Split(ControlChars.Tab) For Each val As String In textValues textWithSpaces += Convert.ToString(val) & New String(" "c, 4 - val.Length Mod 4) Next Return textWithSpaces End Function However, since I am new to SAS programming, I don't know how is it done in Base SAS. Also, since the files are existing files, asking the coder to take care of tabs is not an option.
... View more
