I am having trouble importing a CSV file using the DATA step where some of the column names have spaces. I have specified that a comma is the delimiter, but SAS is still breaking up the variable names into multiple columns. I am aware that using PROC IMPORT would solve this problem, but for various reasons, is not an option in my case. What am I missing? data &&sasname&i;
infile "&&path&i" delimiter="," dsd firstobs=2 truncover;
input &varlist;
run; My CSV looks like the following: Visit Repeat Key,Form Repeat Key,Item Group Repeat Key,Scheduled Date,Completed Date 1,1,,2018-08-01T07:00:00.000Z,2018-08-02T18:11:17.000Z 1,1,,2018-08-02T07:00:00.000Z,2018-08-02T23:14:02.000Z 1,1,,2018-08-01T07:00:00.000Z,2018-08-02T17:11:16.000Z 1,1,,2018-08-01T07:00:00.000Z,2018-08-02T17:00:21.000Z 1,1,,2018-08-21T07:00:00.000Z, 1,1,,2018-08-01T07:00:00.000Z,2018-08-02T19:59:46.000Z 1,1,,2018-08-02T07:00:00.000Z,2018-08-02T16:58:20.000Z 1,1,,2018-08-01T07:00:00.000Z,2018-08-02T17:12:31.000Z 1,1,,2018-08-01T07:00:00.000Z,2018-08-02T17:53:10.000Z
... View more