100 likes | 230 Views
Explaining the WageIndicator dataset WageIndicator conference 22 june 2006. Kea Tijdens - AIAS. Amsterdam Institute for Advanced Labour Studies Universiteit van Amsterdam. The national website. The web-survey the data of the web-survey is collected at one secure web-site
E N D
Explaining the WageIndicator datasetWageIndicator conference 22 june 2006 Kea Tijdens - AIAS Amsterdam Institute for Advanced Labour Studies Universiteit van Amsterdam
The national website • The web-survey • the data of the web-survey is collected at one secure web-site • thus jointly from all national websites • The datamanager • collects the data every week • converts the txt-data into an SPSS format • has developped programs for data-cleaning • produces the quarterly data releases
The data format • SPSS • quarterly data is in the SPSS format • SPSS can be converted into Excel or Stata • the number of variables • currently 685 variables • the variable format • almost all variables are numeric • a few string variables, f.e. occtext, sectext, survetext • a few variables in the DATE/TIME format
The variable names • variable names and labels • var names have up to 8 characters, f.e.constres • all var names have labels, f.e. Finds job stressful • var labels refer to the question in the questionnaire • capitals used for joint parallel questions, f.e. • FOR employees, self-employed, apprentices: How much time is needed to become fully effective in your job for someone with your qualifications? (edujobtr) • FOR School pupil, student: How much time is needed to become fully effective in your job? (edujobt1) • -> EDUJOBT • capitals used for data from cascades, f.e. • NACE4NUM, for the question ‘Please select the main business activity of the organisation where you work”
Numerical variables have values • values of edumore Has gained further qualifications 1 Yes 0 No • missing values • 9 User missing • 8 Not applicable • 1 Not (contst>1) • the –1 values indicate the routing • system missing values • in countries where the question is not asked, the variable has a system missing value
The meta data • indentifying national data • locale f.e. en_IN • country f.e. 32 Argentina • indentifying the date of survey • SURVEDATDate of survey (Date format) • SURVEWWWeek of survey (Num) • SURVEYYYear of survey (Num) • survetbTime of survey (begin) (Time format) • surveteTime of survey (end) (Time format) • indentifying cases • IDNR (unique, refering to surveynumber + followup nr) • idkey (unique, automatically assigned)
The syntax shop • research lab at www.wageindicator.org • SPSS syntax files are available for • computing new grouped variables (f.e. age group) • value labels for occupation in the national language • you can send us syntax files and we can post them