Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Suspicious date: 1960-01-01 #38

Open
onyxfish opened this issue Oct 31, 2016 · 2 comments
Open

Suspicious date: 1960-01-01 #38

onyxfish opened this issue Oct 31, 2016 · 2 comments

Comments

@onyxfish
Copy link
Contributor

Via Chris Wright: "I wanted to add that the date 1960-01-01 can also be a suspicious date as this is the 0 date for a data manipulation program called SAS. It looks like your guide is aimed at journalists and amateur data investigators, so probably less common for people in those situations."

@MonkmanMH
Copy link

@onyxfish - While I agree that SAS won't be used by everyone, it seems to me that the Quartz Bad Data Guide is being read by a wide range of data investigators, including those who may be using SAS or importing SAS data files. If my perceptions are correct, then the more of these suspicious dates (and other idiosyncratic behaviours) that are documented, the better.
I, for one, did not know this about SAS...so thanks for the knowledge!

@bwiernik
Copy link

Similarly, the dates 1900-12-30 and 1904-01-01 should also be seen as suspicious, as they are the origins for Excel for Windows/Mac.
https://www.r-bloggers.com/date-formats-in-r/

More generally, lots of databases also replace missing date parts with “01”, so it is a good idea to regard dates for the first of the month (and for Jan 01, both the month and day) as suggesting more precision than is warranted unless checked.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants