-
Notifications
You must be signed in to change notification settings - Fork 0
/
crossmatching_eos.sps
60 lines (38 loc) · 1.02 KB
/
crossmatching_eos.sps
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
* Encoding: UTF-8.
GET
FILE='H:\GitHub\movies\allthemovies.sav'.
DATASET NAME allmovies WINDOW=FRONT.
EXECUTE.
SAVE OUTFILE='H:\GitHub\movies\crossmatch.sav'
/COMPRESSED
/KEEP key title opening_year metatitle metayear imdbtitle imdbyear.
DATASET CLOSE allmovies.
GET
FILE='h:\GitHub\movies\crossmatch.sav'.
DATASET NAME cross WINDOW=FRONT.
EXECUTE.
RENAME VARIABLES opening_year=year.
DATASET ACTIVATE cross.
DATASET COPY imdbonly.
DATASET ACTIVATE imdbonly.
FILTER OFF.
USE ALL.
SELECT IF (title = '' & metatitle = '' & imdbtitle ~= '').
EXECUTE.
DELETE VARIABLES title year metatitle metayear.
EXECUTE.
SAVE OUTFILE='h:\GitHub\movies\imdbonly.sav'
/COMPRESSED.
DATASET ACTIVATE cross.
DATASET CLOSE imdbonly.
SELECT IF (title ~= '' | metatitle ~= '').
EXECUTE.
SORT CASES BY key.
SAVE OUTFILE='h:\GitHub\movies\crossmatch.sav'
/COMPRESSED.
SAVE TRANSLATE OUTFILE='/Users/jordan/Documents/movies/data_2017_5_9/crossmatch.xlsx'
/TYPE=XLS
/VERSION=12
/MAP
/FIELDNAMES VALUE=NAMES
/CELLS=VALUES.