Desktop productivity for business analysts and programmers

Importing Date

Not applicable
Posts: 0

Importing Date

Im importing a text file that have a field of date as (0001-01-01) yyyy-mm-dd. When I import that information in Enterprise Guide appears missing.
The format that Im using in Guide is yymmddd10.
Im importing with FILE->IMPORT DATA option in the Enterprise Guide menu and the text file have 130Mb.

Please Samebody help me!!!
Frequent Contributor
Posts: 81

Re: Importing Date

Posted in reply to deleted_user
SAS can only cope with years after about 1528, due to the change from Julian to Gregorian calendars. 0001 is before the year, so SAS stores it as a missing value.

Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation