Project

General

Profile

1 717 jones
OPTIONS LS=78 NOCENTER;
2
LIBNAME data '.';
3
FILENAME qdata './querydata.csv';
4
5
DATA ONE;
6
  INFILE qdata DLM=',' TRUNCOVER;
7
  INPUT nodes depth index nested hits searched;
8
9 718 jones
DATA two;
10
  LENGTH method $ 8;
11
  SET one;
12
  rename index=qtime;
13
  method='index';
14
DATA three;
15
  LENGTH method $ 8;
16
  SET one;
17
  rename nested=qtime;
18
  method='nested';
19
20
DATA four;
21
  SET two three;
22 719 jones
  DROP index nested;
23 718 jones
24
PROC PRINT;
25
26 717 jones
PROC SORT;
27 718 jones
  BY method nodes depth hits searched;
28 717 jones
29
PROC GLM;
30 718 jones
  CLASSES method;
31
  MODEL qtime = method nodes depth searched;
32 717 jones
QUIT;
33
34
PROC PLOT;
35 718 jones
  PLOT qtime*depth;
36 717 jones
PROC PLOT;
37 718 jones
  PLOT qtime*nodes;
38 717 jones
PROC PLOT;
39 718 jones
  PLOT qtime*searched;
40
41 717 jones
RUN;