12-20-2013 04:15 AM
I would show a time in the format HHMMSS where:
HH, MM, SS have always 2 digit, I means 9:1:1 in should be 090101.
I'ev trie time but its behaviour is different.
Do there is a format that works in that way?
12-21-2013 08:14 AM
there is that "more direct" way
%put %sysfunc( putn( '9:9:9't, B8601TM )) ;
SAS9.2 doc can be found at http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a003169787.htm
Message was edited by: Peter Crawford showing how these formats can easily be found ---> Session ID: 1744 Session Title: VFORMAT Lets SAS® Do the Format Searching my short paper will be presented some time between 24th and 26th March 2014 in SAS Global Forum www.sasglobalforum.org
12-21-2013 06:24 PM
I thought that one of those 8601 formats might work but I could never find it. I remembered your search technique, I think you showed us that on SAS-L in the not too distant past, but I was too lazy to follow through. Glad to see that you will presenting it at SGF. The SGF reviewers did not like my ideas this year or last, but they did say they hope I enjoy the conference. Right.
12-21-2013 08:11 PM
DN: The SGF reviewers obviously don't have a clear concept of what most of us want to see. I haven't seen what may have been selected in the second go round but, from the initial listing, it was just the same old. I've been waiting for years to see you present!
12-23-2013 05:03 AM
The developers that have created SAS they never used SAS I think, because otherwise these developers, in the case they used the software they have been produced, they should choosen a name for the format more easy to find
12-23-2013 04:58 AM
I'm running 9.1 and I think that the format B8601TM is not available
ERROR 48-59: The format B8601TM was not found or could not be loaded.
12-23-2013 10:42 AM
As for the names, there are so many formats and informats, naming would be problematic for anyone. In the case, the formats conform to the ISO 8601 standard, thus would make sense to some.
01-22-2014 12:31 PM
why not upgrade from SAS9.1 It is so out-of-date
SAS don't charge any more when you upgrade your release (but I don't speak for SAS)
you might have work to migrate a metadata server
but the effort is worth it
there are many more improvements than just this little B8601TM format
12-23-2013 04:53 AM
it does not work, I get
but is would get always 2 digit for the hour, 2 for minutes, 2 for hours, I mean in this case I would get 090112
12-30-2013 07:08 AM
Hi, Try this :
format time tod.; /*just to show difference*/
put "time=" time;
put "time6=" time6;