Actually there may be an easier way since you are starting with reading a CSV file.
The default behavior for reading delimited data treats multiple delimiters as a single delimiter.
If you look at the code generated by the Proc Import you will likely see the option DSD on the infile statement. This changes the read to force each comma to delineate a variable, which I will say most of the time is the desired behavior.
But with what your are doing if you 1) copy the data step from the log to the editor and 2) remove the DSD you will likely get the appearance you want.
Here's a brief example with a small data set example:
data junk;
infile datalines dlm=',' truncover ;
informat var1-var5 $10.;
input var1 - var5;
datalines;
ab,,cd,e,f
a,b,c,d,e,
,,c,d,e
run;
data junk2;
infile datalines dlm=',' truncover dsd;
informat var1-var5 $10.;
input var1 - var5;
datalines;
ab,,cd,e,f
a,b,c,d,e,
,,c,d,e
run;
Junk2 is likely similar to your data and Junk is what you want.
This may be very helpful if you are going to be doing this with multiple files.
... View more