I have a dataset with weird date value

In sas:
DDYYMM should be the interger friction.
HHMMSS should be the decimal fraction.

My data:
http://ppt.cc/%2CBz0@.jpg
Why the value of the Daytime is an integer?

On Thursday, March 22, 2012 11:05:56 PM UTC-4, lito...@gmail.com wrote:
> I have a dataset with weird date value
> 
> In sas:
> DDYYMM should be the interger friction.
> HHMMSS should be the decimal fraction.
> 
> My data:
> http://ppt.cc/%2CBz0@.jpg
> Why the value of the Daytime is an integer?

To protect us from malware and phishing and viruses, please provide examples of the weird date value as text here in the forums. I will not click on your link.

--
Paige Miller

litonchen@gmail.com wrote:
> I have a dataset with weird date value
>
> In sas:
> DDYYMM should be the interger friction.
> HHMMSS should be the decimal fraction.
>
> My data:
> http://ppt.cc/%2CBz0@.jpg
> Why the value of the Daytime is an integer?

Native SAS date, time, and datetime values are always integers. Why 
do you think they shouldn't be?

 From the SAS docs:

SAS date value
is a value that represents the number of days between January 1, 
1960, and a specified date. SAS can perform calculations on dates 
ranging from A.D. 1582 to A.D. 19,900. Dates before January 1, 1960, 
are negative numbers; dates after January 1, 1960, are positive numbers.

- SAS date values account for all leap year days, including the leap 
year day in the year 2000.
- SAS date values can reliably tell you what day of the week a 
particular day fell on as far back as September 1752, when the 
calendar was adjusted by dropping several days. SAS day-of-the-week 
and length-of-time calculations are accurate in the future to A.D. 
19,900.
- Various SAS language elements handle SAS date values: functions, 
formats, and informats.

SAS time value
is a value representing the number of seconds since midnight of the 
current day. SAS time values are between 0 and 86400.

SAS datetime value
is a value representing the number of seconds between January 1, 
1960, and an hour/minute/second within a specified date.

On Thu, 22 Mar 2012 20:05:56 -0700 (PDT), "litonchen@gmail.com"
<litonchen@gmail.com> wrote:

>I have a dataset with weird date value
>
>In sas:
>DDYYMM should be the interger friction.
>HHMMSS should be the decimal fraction.

This is not how SAS stores dates, times, or datetimes.  It does
however look very much like how Excel does.

Did you data come from Excel?  If so, how?

-- 
Remove del for email