Hi Team, We were trying to import a csv file with | (pipe) delimited, but after importing either the columns are getting shifted to next column or its populating as blank. Please find the samples data and code below. Please help us to resolve the issue with your suggestion. Your help will be highly appreciated. CSV file: 101|}|Test 1|0}||Last 101|}|Test Line|0}||Last 101|}|Test|0}|12|Last 101|}|Test Other|0}|12|Last Code using to extract the data: Data Test; Infile '' DSD DLM="|" Truncover; Input ID : 3. TestZD1. Name : $20. TestZD2 ZD2. Last : $5.; Run; Values are shifting to next variable if using ZDw. informats. Not able to use the colon (:) operator while extracting into ZDw. informat. & getting warning messages if using the same. WARNING 151-185: List input is incompatible with the specified binary informat. Formatted input will be used.
... View more