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.
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.
.......Phil
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Registration is open
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss. Register now and lock in 2025 pricing—just $495!