GET DATA /TYPE=XLS
   /FILE='D:\JOP\Joplink.net\prev\200607\200607_Working\06_data(shifts).xls'
   /SHEET=name 'Sheet1'
   /CELLRANGE=range 'A1:I277'
   /READNAMES=on
   /ASSUMEDSTRWIDTH=32767.

variable labels
  Clip       'Presence of clip'
 /Patient_ID 'Patient identifier'
 /Site       'Primary cancer site'
 /Vrtcm      'Vertical shift (cm)'
 /Lngcm      'Longitudinal shift (cm)'
 /Latcm      'Lateral shift (cm)'
 /Rtncm      'Rotational shift (cm)'
 /Vector     'Total vector shift (cm)'
 .
recode clip("Yes"=1)("No "=0) into Iclip.
variable label Iclip 'Clip landmark (Numerical)'.
value label    Iclip 0 'Bone' 1 'Bone+Clip' .
cro clip by Iclip.

Crosstabs

Notes
Output Created 10-JUL-2006 11:18:47
Comments
Input Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 276
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax cro clip by Iclip.
Resources Elapsed Time 0:00:00,00
Dimensions Requested 2
Cells Available 116508

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
Clip Presence of clip * Iclip Clip landmark (Numerical) 276 100,0% 0 ,0% 276 100,0%


Clip Presence of clip * Iclip Clip landmark (Numerical) Crosstabulation
Count


Iclip Clip landmark (Numerical) Total
,00 Bone 1,00 Bone+Clip
Clip Presence of clip No 176 0 176
Yes 0 100 100
Total 176 100 276 

fre site.

Frequencies

Notes
Output Created 10-JUL-2006 11:18:47
Comments
Input Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 276
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics are based on all cases with valid data.
Syntax fre site.
Resources Elapsed Time 0:00:00,00
Total Values Allowed 149796

Statistics
Site Primary cancer site
N Valid 276
Missing 0

Site Primary cancer site


Frequency Percent Valid Percent Cumulative Percent
Valid biliary 73 26,4 26,4 26,4
gallbladder 48 17,4 17,4 43,8
gastric 37 13,4 13,4 57,2
pancreas 92 33,3 33,3 90,6
renal liposarc 26 9,4 9,4 100,0
Total 276 100,0 100,0 

recode site("pancreas      "=1)
           ("biliary       "=2)
           ("gastric       "=3)
           ("gallbladder   "=4)
           ("renal liposarc"=5)
       into Isite.
variable label Isite 'Primary cancer site (Numerical)'.
value labels   Isite 1 "Pancreas      " 2 "Biliary       "
                         3 "Gastric       " 4 "Gallbladder   "
                         5 "Renal liposarcoma"
    .
cro site by Isite.

Crosstabs

Notes
Output Created 10-JUL-2006 11:18:47
Comments
Input Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 276
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax cro site by Isite.
Resources Elapsed Time 0:00:00,01
Dimensions Requested 2
Cells Available 87380

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
Site Primary cancer site * Isite Primary cancer site (Numerical) 276 100,0% 0 ,0% 276 100,0%


Site Primary cancer site * Isite Primary cancer site (Numerical) Crosstabulation
Count


Isite Primary cancer site (Numerical) Total
1,00 Pancreas 2,00 Biliary 3,00 Gastric 4,00 Gallbladder 5,00 Renal liposarcoma
Site Primary cancer site biliary 0 73 0 0 0 73
gallbladder 0 0 0 48 0 48
gastric 0 0 37 0 0 37
pancreas 92 0 0 0 0 92
renal liposarc 0 0 0 0 26 26
Total 92 73 37 48 26 276 

recode Isite(1=1)(else=0) into Ipanc.
variable label Ipanc 'Pancreatic cancer (Dichotomous)'.
value labels Ipanc 0 'No' 1 'Yes'.
recode Isite(2=1)(else=0) into Ibili.
variable label Ibili 'Biliary cancer (Dichotomous)'.
value labels Ibili 0 'No' 1 'Yes'.
recode Isite(3=1)(else=0) into Igast.
variable label Igast 'Gastric cancer (Dichotomous)'.
value labels Igast 0 'No' 1 'Yes'.
recode Isite(4=1)(else=0) into Igall.
variable label Igall 'Gallbladder cancer (Dichotomous)'.
value labels Igall 0 'No' 1 'Yes'.
recode Isite(5=1)(else=0) into Irena.
variable label Irena 'Renal liposarcoma (Dichotomous)'.
value labels Irena 0 'No' 1 'Yes'.

cro site by Ipanc Ibili Igast Igall Irena.

Crosstabs

Notes
Output Created 10-JUL-2006 11:18:47
Comments
Input Filter <none>
Weight <none>
Split File <none>
N of Rows in Working Data File 276
Missing Value Handling Definition of Missing User-defined missing values are treated as missing.
Cases Used Statistics for each table are based on all the cases with valid data in the specified range(s) for all variables in each table.
Syntax cro site by Ipanc Ibili Igast Igall Irena.
Resources Elapsed Time 0:00:00,01
Dimensions Requested 2
Cells Available 104856

Case Processing Summary

Cases
Valid Missing Total
N Percent N Percent N Percent
Site Primary cancer site * Ipanc Pancreatic cancer (Dichotomous) 276 100,0% 0 ,0% 276 100,0%
Site Primary cancer site * Ibili Biliary cancer (Dichotomous) 276 100,0% 0 ,0% 276 100,0%
Site Primary cancer site * Igast Gastric cancer (Dichotomous) 276 100,0% 0 ,0% 276 100,0%
Site Primary cancer site * Igall Gallbladder cancer (Dichotomous) 276 100,0% 0 ,0% 276 100,0%
Site Primary cancer site * Irena Renal liposarcoma (Dichotomous) 276 100,0% 0 ,0% 276 100,0%


Site Primary cancer site * Ipanc Pancreatic cancer (Dichotomous) Crosstabulation
Count


Ipanc Pancreatic cancer (Dichotomous) Total
,00 No 1,00 Yes
Site Primary cancer site biliary 73 0 73
gallbladder 48 0 48
gastric 37 0 37
pancreas 0 92 92
renal liposarc 26 0 26
Total 184 92 276


Site Primary cancer site * Ibili Biliary cancer (Dichotomous) Crosstabulation
Count


Ibili Biliary cancer (Dichotomous) Total
,00 No 1,00 Yes
Site Primary cancer site biliary 0 73 73
gallbladder 48 0 48
gastric 37 0 37
pancreas 92 0 92
renal liposarc 26 0 26
Total 203 73 276


Site Primary cancer site * Igast Gastric cancer (Dichotomous) Crosstabulation
Count


Igast Gastric cancer (Dichotomous) Total
,00 No 1,00 Yes
Site Primary cancer site biliary 73 0 73
gallbladder 48 0 48
gastric 0 37 37
pancreas 92 0 92
renal liposarc 26 0 26
Total 239 37 276


Site Primary cancer site * Igall Gallbladder cancer (Dichotomous) Crosstabulation
Count


Igall Gallbladder cancer (Dichotomous) Total
,00 No 1,00 Yes
Site Primary cancer site biliary 73 0 73
gallbladder 0 48 48
gastric 37 0 37
pancreas 92 0 92
renal liposarc 26 0 26
Total 228 48 276


Site Primary cancer site * Irena Renal liposarcoma (Dichotomous) Crosstabulation
Count


Irena Renal liposarcoma (Dichotomous) Total
,00 No 1,00 Yes
Site Primary cancer site biliary 73 0 73
gallbladder 48 0 48
gastric 37 0 37
pancreas 92 0 92
renal liposarc 0 26 26
Total 250 26 276 

SAVE OUTFILE='D:\JOP\Joplink.net\prev\200607\200607_Working\shifts.sav'
 /COMPRESSED.