tod8. and picture formats: How Can I Find a Time Format that Does Not Remove the Leading Zero e.g. Time5
How Can I Find a Time Format that Does Not Remove the Leading Zero e.g. Time5 (output printed as 09:36 instead of 9:36)? I have found an intersting solution to this problem in http://www.sas.com/ ; direct link (Suggested by Stephen Hoar, Lloyds TSB) There is currently no time format that puts leading zeros automatically in time values. But there are a number of ways of achieving this, below are some examples. Example 1: Create your own custom format using the following syntax. Then format your data values using the user defined format. proc format ; picture military other = '%0H:%0M:%0S' ( datatype =time) ; run ; data test; x= ' 9:36't ; format x military8. ; put x=; run ; x=09:36:00 Example 2: You can also use the TODw.d format which does write leading zeros, but the original value must be a SAS datetime value. To convert your time values to datetime values use the DHMS function. In the DHMS function insert the value: 0 date, 0 hours, 0 minutes, and then...