Data management

• 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 Blog post: Smart quotes, em dashes, and en dashes
• 2020/01/07 Blog post: Identifying and manipulating non-breaking spaces
• 2019/04/18 Recommendation: Separating Unique and Duplicated Observations Using PROC SORT in SAS 9.3 and Newer Versions
• 2019/04/03 Recommendation: When life gives you coloured cells, make categories
• 2018/12/29 Recommendation: 9 Reasons Excel Users Should Consider Learning Programming
• 2018/07/23 Recommendation: Use of Electronic Health Record Data in Clinical Investigations
• 2018/04/19 Recommendation: A crummy drop-down menu appeared to kill dozens of mothers in Texas.
• 2018/04/09 Recommendation: ISO 8601
• 2018/04/03 Recommendation: EuSpRIG horror stories.
• 2018/04/03 Recommendation: The Reinhart-Rogoff error – or how not to Excel at economics
• 2018/02/24 Recommendation: Data dictionaries
• 2017/09/28 Recommendation: OpenRefine: A free, open source, powerful tool for working with messy data
• 2017/09/05 Recommendation: Good enough practices in scientific computing
• 2016/09/01 Recommendation: Organizing data in spreadsheets
• 2016/06/15 Recommendation: Handling date-times in R
• 2014/05/31 PMean: What should go into a data codebook
• 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/06/27 Dumping data from R to a text file
• 2005/05/24 Importing value labels from Access into SPSS
• 2005/05/16 A disaster averted
• 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