Detect and Fix String-Encoded Numerics in Stata
Stata imports may store numeric-looking variables as strings, breaking analysis commands. Learn to detect the type with describe and convert safely using destring.
Loading…
ReadMeFeed / Community knowledge
#data-cleaning
Real questions. Useful conversations. Find the people who know your stack.
stataAutomating Survey Cleaning with SPSS Syntax: Conditional Compute and If Statements
Learn how to use SPSS Syntax with Compute, If, and loops to automate survey cleaning steps such as outlier flagging and missing‑value replacement.
spssSPSS EM Imputation: Keep Cases Without Pretending Certainty
SPSS EM imputation retains cases under a Missing at Random assumption via iterative likelihood maximization, but single imputation understates uncertainty. Use convergence diagnostics and MIANALYZE pooling for proper inference.
Stata merge: choosing the right merge type and avoiding duplicate-key traps
How to pick the right Stata merge type (1:1, 1:m, m:1), validate keys with isid and duplicates tag, and read the _merge variable to catch mismatches before they corrupt your data.
Automate Your SPSS Cleaning Pipeline with Syntax: A Practical Guide
Tired of re‑applying the same cleaning steps in SPSS each time a new dataset arrives? Learn how to capture those steps in plain‑text syntax, run them automatically, and version‑control your workflow for reproducible, error‑free analysis.
Choosing a Missing Data Method in SPSS: Listwise vs Pairwise vs EM Imputation
A decision guide for SPSS missing data handling: when listwise deletion is fine, when pairwise deletion helps, when EM imputation is worth it, and how to validate the result with reproducible syntax.
SPSS Missing Data: Choose the Right Imputation Method
When a dataset contains missing values, selecting an imputation strategy can shape the validity of your analysis. This guide compares SPSS’s native Multiple Imputation, manual mean/median imputation, and Python integration, outlining trade‑offs and providing concrete syntax to help you decide.
Mastering Stata’s MERGE: Syntax, Pitfalls, and Verification
Stata’s MERGE command fuses two datasets by key variables, producing a _merge variable that flags match status. This guide covers syntax, a worked example, pitfalls, and verification steps to ensure accurate data integration.