topic Re: merging cells in CSV in SAS Programming

merging cells in CSV

Pnong — Thu, 26 Jun 2025 09:12:39 GMT

Hi All,

Which codes to use to address the problem where the decription appears in the next cell? I wish to turn the informaiton which has over 5000 rows into a table .For example:t changing the Table 1 which is csv format to Table 2

Table 1 Csv format

85415900,"Other semiconductor devices, other than semiconductor-based transducers, other
than photosensitive devices, nesoi"

Table 2

HS code	Description
85415900	Other semiconductor devices, other than semiconductor-based transducers, otherthan photosensitive devices, nesoi".

Re: merging cells in CSV

Kathryn_SAS — Thu, 26 Jun 2025 10:47:30 GMT

You may have an embedded carriage return in your quoted string. You can try the following:

https://support.sas.com/kb/26/065.html

Re: merging cells in CSV

Tom — Thu, 26 Jun 2025 13:39:31 GMT

From the description is looks like the CSV file has end-of-line characters in the value of one of the fields.

If you are lucky it only has CR or LF in the field value and uses CR-LF as the end-of-line marker.

Try reading the file using the TERMSTR=CRLF option on the INFILE (or FILENAME) statement.

If the fields contain the same characters as used for the end-of-line markers then you will need to preprocess the file. Since it looks like the field with the end-of-line marker is quoted you can use something that counts the number of quotes on a line to detect and remove or replace them.

Try this macro to make a copy of the CSV file with the embedded CR and LF characters replaced (or removed):

https://github.com/sasutils/macros/blob/master/replace_crlf.sas