Thanks, very interesting paper. I tried to apply it but still can’t manage ti keep a leading blank. Let me show you what i did: proc format; picture formatpic (default=4) low-high='999' (prefix=' '); run; PROC SQL; CREATE TABLE newtable AS SELECT input_variable format=formatpic. FROM input_table; QUIT; Where my input variable contained numeric values like: “003” The idea was to add the prefix “ “, but it won’t add it. The way i test it is by exporting it to a .txt and seeing if the leading blank is there. In the paper, it says 0 print blanks. So, I also tried: proc format; picture formatpic (default=4) low-high='0999'; run; PROC SQL; CREATE TABLE newtable AS SELECT input_variable format=formatpic. FROM input_table; QUIT; Where my input variable contained numeric values like: “0003”. But when exporting again I don’t get my leading blank.
... View more