metacat/test/stats/querydata.sas @ 9172
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; |