Hi All, Currently I'm working to import data that contain (",") as a delimiter. Since the source data is coming from txt format then I'm using infile and setting the format, and it works. But apparently, some data has a "fake" delimiter which it should be not counted as a delimiter value. Can you please to help me to solve the issue? Here's the sample data: Data test; Delimiter=' , ' ; Input No Company Type; Datalines; 1,Barata,PT,A 2,Riley,A 3,,B ; Run; The expectation Barata,PT shouldn't being divided into 2 cells.
... View more