If you're new to DIS and haven't used another metadata driven ETL tool before then you will need some time to get your head around to grasp the difference between metadata and SAS code.
The DIS wizard you're using helps you to create External File Metadata. Even if the Wizard wouldn't treat blank separated column headings as two columns, you certainly wouldn't want to end-up with blank separated column names.
What you can do: Take a copy of your .csv with the headings and a few lines of data, then change the headings to the names you need as SAS variable names (compliant with SAS naming convention and your data model) and then use this file with the wizard.
Alternatively and even easier: You know your data. Define the columns for the External File Metadata manually. The names don't need to be the same than what's in the .csv as header but should be what makes sense as SAS variable names. This being a repetitive ETL process you also don't want the wizard to define the column attributes like the length. You need in any case to amend what the wizard creates here as this is only appropriate for the .csv you currently have. Next day's .csv could contain longer strings.
... View more