* Encoding: UTF-8.
* ==============================================================================
* T E M P L A T E  for  D A T A   C H E C K S  recommended by   A U S S D A   
*
* Study Title: 	
* Date: 		
* Name: 
*
* self-deposit data_checks-template version: 1.0
* This template contains the basic framework for datachecks.
*
* This do-file is licensed under a Creative Commons Attribution 4.0 International License
* (CC BY 4.0, https://creativecommons.org/licenses/by/4.0/)
* Suggested citation: 
* Bischof, Christian (2025). Template for Data Checks. SPSS syntax. Vienna: The Austrian Social Science Data Archive.
*
* ==============================================================================

* Run SPSS in Unicode Mode (default since SPSS 21).
* Setting SPSS: Edit->Options->Language->Character Encoding: Unicode.
* With syntax: SET UNICODE=Yes.
* Change the UNICODE setting only when there are no open data sources. 

*******  input necessary **********************************************************.
*** change version & doi.
* version.
define !version () '1.0 (YYYY-MM-DD )'  !enddefine. 
* doi.
define !doi () 'doi:10.11587/XXXXX' !enddefine. 
*** change working directory & filenames (without file extension).
define !dir() 'C:\data_folder\' !enddefine. 
* data file to open.
define !data_open() 'filename' !enddefine. 
* data file to store, standard filename pattern.
define !data_store() '######_da_en_v1_0' !enddefine. 
****************************************************************************************.

*** open data file.
GET
 FILE = !dir + !data_open + '.sav'.
DATASET NAME work_file WINDOW=FRONT.

*** compare data & documentation.



*** check plausibility 



*** anonymization checks.



*** add variables doi & version.
STRING version (A16), doi (A19).
VARIABLE LABELS version 'AUSSDA archive version' doi 'digital object identifier'.
COMPUTE version=!version.
COMPUTE doi=!doi.
VARIABLE LEVEL version doi (NOMINAL).
* sort new variables.
ADD FILES file * 
    /keep version doi all.
EXECUTE.

*** save datafile.
* as SPSS  sav.
SAVE OUTFILE = !dir + !data_store + '.sav'
  /COMPRESSED.
* as SPSS  zsav.
SAVE OUTFILE = !dir + !data_store + '.zsav'
  /ZCOMPRESSED.
*as Stata dta.
SAVE TRANSLATE OUTFILE=!dir + !data_store +'.dta'
  /TYPE=STATA
  /VERSION=14
  /EDITION=SE
  /MAP
  /REPLACE.
* as csv for long-time preservation.
SAVE TRANSLATE OUTFILE=!dir + !data_store +'.csv'
  /TYPE=CSV
  /ENCODING='UTF8' BOM=NO
  /MAP
  /REPLACE
  /FIELDNAMES
  /CELLS=VALUES
  /TEXTOPTIONS DELIMITER=','
        QUALIFIER='"'
        DECIMAL=DOT.