LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (November 2003, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Mon, 24 Nov 2003 14:46:01 -0500
Reply-To:     Peter Crawford <peter@CRAWFORDSOFTWARE.DEMON.CO.UK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Peter Crawford <peter@CRAWFORDSOFTWARE.DEMON.CO.UK>
Subject:      Re: Four byte time informat
Comments: To: Rob@ROHRBOUGH-SYSTEMS.COM

On Mon, 24 Nov 2003 12:11:52 -0600, Rob Rohrbough <Rob@ROHRBOUGH- SYSTEMS.COM> wrote:

>In my wildest dreams, I would like to do the following: > >data _null_; > x = '1120'; > y = input(x, hhmm4.); > put x= y=; >run; > >SAS8 does not appear to have a four-character time format to input hours and >minutes, as in "hhmm4.", above. Am I wrong? There seems to be no "HHMM" >format, and neither time4. nor time5. work on a value like "1120". > >Any suggestions other than cracking the silly thing myself? (like >translating it to "11:20") > >TIA, > >Rob > >

Would you consider a macro~function~ like y= %time4(var) ; where that macro %time4 does the tedious work of generating the substringing and inputting..... like

18 %macro time4( var ); 19 input( substr(&var,1,2) ||':'|| substr(&var,3,2), time5. ) 20 %mend time4 ;

21 data demo; 22 str = '1120'; 23 time= %time4( str ); 24 put (_all_)(=) time= time. ; 25 run;

str=1120 time=40800 time=11:20:00


Back to: Top of message | Previous page | Main SAS-L page