My code: data _null_ ; set WORK.Files; file outfile delimiter=','; if _n_ = 1 then do; PUT 'A,B,C,D'; end; PUT A B C D; run ; The output is: A~B~C~D F1,235, , What I want is: A~B~C~D F1,235,,,
... View more
Hello I have a problem - when I try to export a dataset to delimited txt file using data step export, I experience a small but annoying issue that is probably limited to this way of exporting a file because proc export does the job just fine. Unfortunately I need to provide changes to this txt file that proc export can't do so using it is not the solution. So... the thing is - I have in my dataset columns that are always filled with some data and some that are not and in the txt file these empty cells look like this: , , What I want is ,,. How can I remove this blank space betweem delimiter?
... View more
Hi I have a dataset that looks like this: a b c d e 1 3 5 7 9 2 4 6 8 10 How to change it to: Character Number a 1 a 2 b 3 b 4 c 5 c 6 d 7 d 8 e 9 e 10 Thank you in advance!
... View more