* Syntax to format cross sectional data into format required for ESRC archive
http://www.data-archive.ac.uk/create-manage/document/data-level
http://www.data-archive.ac.uk/create-manage/document/data-level?index=1  .



* RATIO ############################################# .
GET  FILE='D:\Documents\Academic\ICCAMS\data\FINAL_DATASETS\1XSection\rat right wrong phase 1 cross sectional.sav'.
DATASET NAME rat WINDOW=FRONT.

* qns 3a 3b 3c are duplicated in 3ac .
DELETE VARIABLES rat03aa_r rat03bb_r rat03cc_r  .


DO REPEAT V=rat01a1_r to fra24@@_r  .
recode V (sysmis=-9) .
MISSING VALUES V (-9) .
END REPEAT .
EXECUTE .

VALUE LABELS rat01a1_r to fra24@@_r  0 'Wrong' 1 'Right' .

variable labels rat01a1_r 'Soup for 8 needs 2pts water; how much water for 4?' .
variable labels rat01a2_r 'Soup for 8 needs 4 stock cubes; how many for 4?' .
variable labels rat01b1_r 'Soup for 8 needs 2pts water; how much water for 6?' .
variable labels rat01b2_r 'Soup for 8 needs 4 stock cubes; how many for 6?' .
variable labels rat01b3_r 'Soup for 8 needs 1/2 pt cream; how much for 6?' .
variable labels rat02a1_r '5cm eel eats 2 sprats; how many for 10cm eel?' .
variable labels rat02a2_r '5cm eel eats 2 sprats; how many for 15cm eel?' .
variable labels rat02a3_r '10cm eel eats 12 sprats; how many for 15cm eel?' .
variable labels rat02a4_r '15cm eel eats 9 sprats; how many for 10cm eel?' .
variable labels rat02b1_r '10cm eel gets 2cm fishfinger; how long for 25cm eel?' .
variable labels rat02b2_r '15cm eel gets 9cm fishfinger; how long for 25cm eel?' .
variable labels rat02b3_r '25cm eel gets 10cm fishfinger; how long for 10cm eel?' .
variable labels rat02b4_r '25cm eel gets 10cm fishfinger; how long for 15cm eel?' .
variable labels rat03aa_r 'Split 240p in proportion: Dr A=2, Dr B=4, Dr C=6. DrA=?' .
variable labels rat03bb_r 'Split 240p in proportion: Dr A=2, Dr B=4, Dr C=6. DrB=?' .
variable labels rat03cc_r 'Split 240p in proportion: Dr A=2, Dr B=4, Dr C=6. DrC=?' .
variable labels rat03ac_r 'Split 240p in proportion: Dr A=2, Dr B=4, Dr C=6. How much should each pay?' .
variable labels rat04ad_r 'Draw line to enlarge a diagram:  length of line' .
variable labels rat04av_r 'Draw line to enlarge a diagram:  vertical gap' .
variable labels rat04ah_r 'Draw line to enlarge a diagram:  horizontal gap' .
variable labels rat04bb_r 'Length of line on enlarged diagram' .
variable labels rat05@@_r 'Mr Short = 5 paperclips = 4 matchsticks; Mr Tall = 6 matchsticks = ?? Paperclips' .
variable labels rat06ab_r 'M:C = 1:5, T:C = 3:10, Z:C = 8:15. M:T = ??' .
variable labels rat06cd_r 'M:C = 1:5, T:C = 3:10, Z:C = 8:15. Z:T = ??' .
variable labels rat07aa_r 'Enlargement 8 -> 12, so 9 -> ?' .
variable labels rat07bb_r 'Enlargement 8 -> 12, so ? -> 18' .
variable labels rat08aa_r '4 out of 100 forgot their lunch. What percentage is this?' .
variable labels rat08bb_r '6% of 250 have free dinners. How many is this?' .
variable labels rat08cc_r '24 out of 800 cars have faulty engine. What percentage is this?' .
variable labels rat08dd_r 'A £20 coat is reduced by 5%. How much does it cost now?' .
variable labels fra02@@_r 'Shade 2/3 of shape with 3 blocks' .
variable labels fra09aa_r '1/3 = 2/?' .
variable labels fra09bb_r '6/8 = 3/?' .
variable labels fra09cc_r '5/10 = ?/30' .
variable labels fra09dd_r '2/3 = ?/15' .
variable labels fra09ee_r '4/12 = 1/?' .
variable labels fra15@@_r '3x4 rectangle covered with 3 half tiles and 3 full tiles. What fraction is tiled?' .
variable labels fra16aa_r '3/5 of wages paid in tax. What fraction is left?' .
variable labels fra16bb_r '3/5 of wages paid in tax & 1/10 on rent. What fraction is left?' .
variable labels fra18@@_r 'How many fractions lie between 1/4 and 1/2?' .
variable labels fra19@@_r 'How many stages of 1/8km in 3/4km?' .
variable labels fra21@@_r 'Length = 4cm, Area = 10sq cm. Width = ?' .
variable labels fra22@@_r 'Width = 3/5cm, Area = 1/3 sq cm. Length = ?' .
variable labels fra24@@_r '1mx1m square with inset 5/8m x 2/9m shaded. What fraction is shaded?' .


variable labels rat_total 'Total score on Ratio items' .
variable labels frac_total 'Total score on Fractions items' .
variable labels test_R_total 'Total score on all Test R items' .




* GENERAL VARIABLES ############################################## .
*change ICCAMS_ID to PUPIL_ID .
RENAME VARIABLES ( ICCAMS_ID = PUPIL_ID ) .
*remove n_qns (these are part questions on original paper, may not correspond with coded qns) .
DELETE VARIABLES n_qns .
DELETE VARIABLES N_levels .

* convert dob to month & year .
compute dob = DATE.MOYR(XDATE.MONTH(dob) , XDATE.YEAR(dob) ) .
formats dob (MOYR8) .
execute .


variable labels test_ID 'Unique test response identifier' .
variable labels test_type 'Type of test' .
variable labels test_year 'Year in which test taken' .
variable labels test_date 'Date test taken (imputed from set/batch if missing)' .
variable labels sch 'School code' .
variable labels phase 'Phase in ICCAMS project' .
variable labels year 'School year group (grade) when test taken' .
variable labels PUPIL_ID 'ICCAMS unique pupil identifier' .
variable labels sex 'Sex (1=m, 2=f)' .
variable labels dob 'Date of birth (date format)' .
variable labels MidYIS_score 'Overall MidYIS score' .
variable labels weight 'Weight applied to give nationally representative sample' .

variable labels L1 'CSMS Level 1 achieved' .
variable labels L2 'CSMS Level 2 achieved' .
variable labels L3 'CSMS Level 3 achieved' .
variable labels L4 'CSMS Level 4 achieved' .
variable labels HiLev 'CSMS level' .


RECODE year (sysmis = -9) .
RECODE sex (sysmis = -9) .
RECODE L1 (sysmis = -9) .
RECODE L2 (sysmis = -9) .
RECODE L3 (sysmis = -9) .
RECODE L4 (sysmis = -9) .
RECODE HiLev (sysmis = -9) .


MISSING VALUES year (-9) .
MISSING VALUES sex (-9) .
MISSING VALUES L1 (-9) .
MISSING VALUES L2 (-9) .
MISSING VALUES L3 (-9) .
MISSING VALUES L4 (-9) .
MISSING VALUES HiLev (-9) .



SAVE OUTFILE='D:\Documents\Academic\ICCAMS\data\FINAL_DATASETS\ESRC archive\ratio.sav'
  /COMPRESSED.

DATASET CLOSE rat .