Well, I would never show you have to get a date with a two-digit year.  I hope this is close enough:   data want; length mydate $ 11; set have; mydate = put(input(mydate, mmddyy10.), date11.); run;   That's assuming that 03/03/2017 is actually in MMDDYY form, rather than DDMMYY form. ... View more

Hi,   If you post some test data in the form of a datastep we could provide working code.  I am unsure as to why you need to convert a value before you check if it is 0 or not? data want; length want_text $20; input myval; want_text=ifc(myval=0,"",put(myval,percent7.1)); datalines; 0 0.345 ; run; ... View more

So you use the 5.2 format in the put function, and then expect ytd2 to be just '0'? Think again. 16 data _null_; 17 ytd1 = 0; 18 YTD2=put(round(YTD1,.01),5.2); 19 put ytd2=; 20 run; YTD2=0.00   ... View more

One approach that may work is to use a custom format so that values of 0 display as ' '. However depending on how many columns and ranges of values you are dealing with this could become cumbersome. ... View more