Hello.. I need an ASCII delimited output file from my program, with every variable enclosed in "" double quotes regardless of the contents. Depending on the scenario, some variables can be null and should output as "". I've searched around the forum but most people want to remove the quotes, my customer needs them in permanently: e.g. "999999","","10","01NOV2020","BILI" "999999","","20","05NOV2020","BILI" "999999","","30","10NOV2020","BILI" My datasets are built dynamically inside a macro based on some other input handled externally and because of this %ds2csv wouldn't execute (something to do with SCL). Anyway, I finally came up with this, which is working from my macro but is just about 95% of what I need: %Let outfile = '\\MyServerPath/export.dat' DLM = ',' DSD; DATA _NULL_; SET WORK.OUT2_LAB; FILE &outfile; put (_ALL_) (~); RUN; With this code, null variables contain a space e.g. " " instead of "". Is there anything I can do to adjust the above code just trim empty spaces but keep everything else the same? So it generates this: "999999","","10","01NOV2020","BILI" And not this: "999999"," ","10","01NOV2020","BILI"
... View more