COMPGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Weired Date Value

• Email
• Follow

```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?
```
 0
Reply litonchen (27) 3/23/2012 3:05:56 AM

See related articles to this posting

```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
```
 0
Reply paige.miller (581) 3/23/2012 2:49:18 PM

```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.

```
 0
Reply cwkaufmann1 (26) 3/23/2012 3:53:56 PM

```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
```
 0
Reply schwarzb3978 (1428) 3/23/2012 5:23:26 PM

3 Replies
46 Views

Similar Articles

12/5/2013 10:40:26 AM
page loaded in 49201 ms. (0)

 Reply:

Similar Artilces: