Data management

2022/11/03 Blogdown equations
2022/10/30 Confusion caused by multiple date formats
2022/10/30 Internal storage format for dates
2022/10/27 Missing value functions
2022/10/23 Missing value hell
2020/10/08 Excel: Why using Microsoft’s tool caused Covid-19 results to be lost
2020/04/30 Reading text files
2020/03/02 Smart quotes, em dashes, and en dashes
2020/01/07 Identifying and manipulating non-breaking spaces
2019/04/18 Separating Unique and Duplicated Observations Using PROC SORT in SAS 9.3 and Newer Versions
2019/04/03 When life gives you coloured cells, make categories
2018/12/29 9 Reasons Excel Users Should Consider Learning Programming
2018/07/23 Use of Electronic Health Record Data in Clinical Investigations
2018/04/19 A crummy drop-down menu appeared to kill dozens of mothers in Texas.
2018/04/09 ISO 8601
2018/04/03 EuSpRIG horror stories.
2018/04/03 The Reinhart-Rogoff error – or how not to Excel at economics
2018/02/24 Data dictionaries
2017/09/28 OpenRefine: A free, open source, powerful tool for working with messy data
2017/09/05 Good enough practices in scientific computing
2016/09/06 Merging in dplyr is a lot faster
2016/09/01 Organizing data in spreadsheets
2016/06/15 Handling date-times in R
2014/05/31 What should go into a data codebook
2011/05/21 Using a binary coding trick illustrated by a Car Talk puzzler
2008/10/20 Computing a difference between first and last variables
2008/08/28 Checks for data quality using metadata
2007/02/14 Watch out for ambiguous data
2006/06/20 Auditing for data entry errors
2006/05/23 Another regular expression tip
2006/05/23 Lost files
2006/05/18 Using regular expressions to insert line breaks
2006/01/31 More lessons learned the hard way
2005/11/25 Hard learned lessons
2005/11/02 Non-destructive data editing
2005/08/16 Another disaster averted
2005/07/28 Moving R objects
2005/07/21 More on regular expressions
2005/05/24 Importing value labels from Access into SPSS
2005/05/10 String manipulations in R
2005/03/15 Digitizing a graph
2003/02/03 Coding race/ethnicity
2001/01/24 Loading ODBC drivers from the Microsoft Data Access Pack
2000/01/28 Exporting SPSS graphs and tables.
2000/01/28 Spreadsheet or Database?
1999/09/20 Importing spreadsheet data into SPSS
1999/09/18 Documenting your SPSS data sets
1999/09/18 Inputting a two-by-two table into SPSS
1999/09/18 Modifying SPSS data
1999/09/03 General guide to data entry
1999/08/18 Date calculations in SPSS
1999/08/18 Importing database files into SPSS
1999/08/18 Raynald’s SPSS Tools
1999/01/15 Merging files in SPSS