Date: Mon, 9 Jul 2007 08:10:06 0400
ReplyTo: "V. Bourcier" <veronique.bourcier@LAPOSTE.NET>
Sender: "SAS(r) Discussion" <SASL@LISTSERV.UGA.EDU>
From: "V. Bourcier" <veronique.bourcier@LAPOSTE.NET>
Subject: Re: A QUESTION ABOUT SAS DATE TIME.
Thanks a lot for this usefull explainationg. I've taken it into account to
get data set three.
data three;
informat y nd8601tm.;
format y time5.;
input y;
datalines;
1130
;
run;
proc print data=three;
run;
Best Regards,
Veronique
>The statement "Informat ... ;" in Data TWO assigns an attribute to the
>column Y. This means if something is read into this column from an
external
>data source like an infile, or a cards statement, then the informat will
>perform the transition from input text to stored value. Since you have
done
>an assignment to Y in the next line, there is no transition from an
external
>source and the value is simply assigned to the numeric column.
>
>In Data ONE, you have a string value in quotes, and use the informat to
read
>the external value, so the informat is used to make the change.
>
>Thus Data ONE will have 11:30 as a time value, underlying which will be a
>value which is the number of seconds 11:30 is past midnight (11 * 3600 +
>1800). And Data TWO will have a value which is 1130 seconds past midnight.
>Since there are 3600 seconds in an hour, it will be around 20 minutes past
>midnight.
>
>Kind regards
>
>David
>
>Original Message
>From: SAS(r) Discussion [mailto:SASL@LISTSERV.UGA.EDU]On Behalf Of V.
>Bourcier
>Sent: Monday, 9 July 2007 7:40 PM
>To: SASL@LISTSERV.UGA.EDU
>Subject: Re: A QUESTION ABOUT SAS DATE TIME.
>
>
>Hi,
>
>I've used the code suggested above and I am trying to figure out why data
>set two does not print the save as data set one.
>
>
>data one;
> y=input('1130',nd8601tm.);
> format y time5.;
>run;
>
>proc print data=one;
>run;
>
>data two;
> informat y nd8601tm.;
> y=1130;
> format y time5.;
>run;
>
>proc print data=two;
>run;
>
>
>Best Regards
>
>Veronique
>
>>>>I have following Character variable:
>>>>
>>>>C_time
>>>>
>>>>1130
>>>>1230
>>>>0945
>>>>
>>>>need the following numeric variable output:
>>>>
>>>>C_Time
>>>>
>>>>11:30
>>>>12:30
>>>>09:45
>>>>
>>>>
>>>>Now I have the following to numeric variables:
>>>>
>>>>Date C_Time
>>>> 
>>>>23DEC2005 11:30
>>>>27DEC2007 12:30
>>>>
>>>>Need a output using DHMS fuction to get a SAS datetime value.
>>>>
>>>>Thanks for your help.
>>>
>>>Try this:
>>>
>>> data have;
>>> input Date : date9. C_time : $4.;
>>> format date date9.;
>>> datalines;
>>> 23DEC2005 1130
>>> 27DEC2007 1230
>>> . 0945
>>> run;
>>>
>>> proc sql;
>>> create table need as
>>> select date
>>> , input ( C_time , ND8601TM. )
>>> as C_Time format=time5.
>>> , dhms ( date , 0, 0 , calculated c_time )
>>> as MyDateTime format=datetime19.
>>> from have;
>>> quit;
>>>
>>>Result:
>>>
>>> Date C_Time MyDateTime
>>>
>>> 23DEC2005 11:30 23DEC2005:11:30:00
>>> 27DEC2007 12:30 27DEC2007:12:30:00
>>> . 9:45 .
>>
>>Also see
>>
>>http://sascommunity.org/wiki/Time_Informats
