*
* Read the data from the 1st submission
*

DATA LIST FIXED
	FILE = 'I:\SUPPORT_COMMON\Statistics Unit\PLANNING\POLICY\STATS\2013\CIT
\AVETMISS\tafedata\nat00080.txt'
	/clientID 1-10 (A)
	ID 4-10
	EncryptID 11-70 (A)
	HiSchoolLevel 71-72 (A)
	YrHiSchool 73-76 (A)
	Sex 77-77 (A)
	DOB 78-85 (A)
	ResPostcode 86-89 (A)
	ATSI 90-90 (A)
	Language 91-94 (A)
	Labour 95-96 (A)
	Country 97-100 (A)
	Disability 101-101 (A)
	PriorEdAchievement 102-102 (A)
	AtSchool 103-103 (A)
	ProfEnglish 104-104 (A)
	Suburb 105-154 (A).

Reading 1 record from `I:\SUPPORT_COMMON\Statistics Unit\PLANNING\POLICY\STATS
\2013\CIT\AVETMISS\tafedata\nat00080.txt'.
+------------------+------+-------+------+
|     Variable     |Record|Columns|Format|
#==================#======#=======#======#
|clientID          |     1|  1- 10|A10   |
|ID                |     1|  4- 10|F7.0  |
|EncryptID         |     1| 11- 70|A60   |
|HiSchoolLevel     |     1| 71- 72|A2    |
|YrHiSchool        |     1| 73- 76|A4    |
|Sex               |     1| 77- 77|A1    |
|DOB               |     1| 78- 85|A8    |
|ResPostcode       |     1| 86- 89|A4    |
|ATSI              |     1| 90- 90|A1    |
|Language          |     1| 91- 94|A4    |
|Labour            |     1| 95- 96|A2    |
|Country           |     1| 97-100|A4    |
|Disability        |     1|101-101|A1    |
|PriorEdAchievement|     1|102-102|A1    |
|AtSchool          |     1|103-103|A1    |
|ProfEnglish       |     1|104-104|A1    |
|Suburb            |     1|105-154|A50   |
+------------------+------+-------+------+

sort cases by id.

save outfile = 'C:\PSPP_update\nat00080_M.sav'.

select if any(id,      21,     45,     56,     63,     78).

list /variables = ID Sex DOB ATSI Labour.

Data List
     ID Sex      DOB ATSI Labour
--------------------------------
     21   M 26041973    4     @@
     45   F 07041954    4     02

     ID Sex      DOB ATSI Labour
--------------------------------
     56   F 09061955    4     @@
     63   F 19071955    4     01
     78   F 12101956    4     02

*
* Transaction file
*	

DATA LIST FIXED
	FILE = 'C:\PSPP_update\12nat080_UP.txt'
	/clientID 1-10 (A)
	ID 4-10
	Sex 77-77 (A)
	DOB 78-85 (A)
	ATSI 90-90 (A)
	Labour 95-96 (A).

Reading 1 record from `C:\PSPP_update\12nat080_UP.txt'.
+--------+------+-------+------+
|Variable|Record|Columns|Format|
#========#======#=======#======#
|clientID|     1|  1- 10|A10   |
|ID      |     1|  4- 10|F7.0  |
|Sex     |     1| 77- 77|A1    |
|DOB     |     1| 78- 85|A8    |
|ATSI    |     1| 90- 90|A1    |
|Labour  |     1| 95- 96|A2    |
+--------+------+-------+------+

sort cases by id.

save outfile = 'C:\PSPP_update\NAT80_UP.sav'.

select if any(id,      21,     45,     56,     63,     78).

list /variables = ID Sex DOB ATSI Labour.

Data List
     ID Sex      DOB ATSI Labour
--------------------------------
     21   M 26041973    4     @@
     45   F 07041954    4     02
     56   F 09061955    4     @@
     63   F 19071955    4     01
     78   F 12101956    4     02