Alex: From your database date settings, RBase is expecting the year to
have 4 digits for the year. If it isn't coming into the table with 4 digits,
then it will put a "00" in front. So a date of 01/01/10 would come in
as 01/01/0010.
If you want to keep your date sequence as a 4-digit year, then you should
SET DATE SEQ MMDDYY right before your import, and then change it back to
MMDDYYYY when you're done.
The "century threshold" tells RBase when to make the switchover from 1900
to 2000 when it gets in 2 digit years. I usually have my century threshold
set around 70 to 80. If my threshold was 70, then any dates that come in
with a year of "70" or more are considered 1900. Otherwise it's 2000. For
example:
1/1/70 would be 1/1/1970
1/1/99 would be 1/1/1999
but then
1/1/00 would be 1/1/2000
1/1/69 would be 1/1/2069
Does that help?
Karen
> I have a CSV file with a date column formatted MM/DD/YY. I am able to
> successfully load the file (as ASCII) into an R:Base 5.5 table with a
> matching structure. After importing the CSV file into the table, the date
> column
> contains MM/DD/00YY instead of MM/DD/20YY. Does anyone know why? Excel
> properly interprets the date when the file is opened.
>
> DATE format mm/dd/yyyy
> DATE sequence MMDDYYYY
> Century threshold YEAR is 0
> Default CENTURY is 19
>
>
>
>
> Not quite sure why our default century is 19....not sure what century
> threshold year is....
>
>
>
> Thank you!
>
>
>
> Alex Sisk
>
>
