CSV2DS - files with missing column names about macros HOT 3 CLOSED

The current code should already be replacing empty names with VARnnn where nnn is the variable number. Can you provide an example file that causes the trouble?

from macros.

The only way I could re-create something like that problem is to (1) have VALIDVARNAME=ANY set. (2) Write the CSV file using TERMSTR=CRLF (3) Tell %CSV2DS() to read the file using TERMSTR=LF. In that case it will create a variable whose name is the single CR character that it read from the file. Which when printed will look a lot like a space.

from macros.

Closing this issue. Use the right setting for TERMSTR when reading the file. %csv2ds("myfile.csv" termstr=crlf).

from macros.