SAS Intro

STAT 408

March 30

Andy Hoegh

SAS Language Basics

  • SAS Programs
  • SAS Statements
  • SAS Data Sets
  • DATA and PROC Steps

SAS Programs

A SAS program is made up of SAS statements that compose DATA steps and PROC Steps. SAS programs are arranged in a more formal manner than R programs.

The general workflow for SAS programs follows as:

Work Flow

In [90]:
data class;
    set sashelp.class;
    if Sex = 'F';
run;
Out[90]:

1054  ods listing close;ods html5 file=stdout options(bitmap_mode='inline') device=png; ods graphics on / outputfmt=png;
NOTE: Writing HTML5 Body file: STDOUT
1055  
1056  data class;
1057      set sashelp.class;
1058      if Sex = 'F';
1059  run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: The data set WORK.CLASS has 9 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
1060  ods html5 close;ods listing;

1061
In [91]:
Proc print data=class;
run;
Out[91]:
SAS Output

Bridger Bowl Ski Facts

Obs Name Sex Age Height Weight
1 Alice F 13 56.5 84.0
2 Barbara F 13 65.3 98.0
3 Carol F 14 62.8 102.5
4 Jane F 12 59.8 84.5
5 Janet F 15 62.5 112.5
6 Joyce F 11 51.3 50.5
7 Judy F 14 64.3 90.0
8 Louise F 12 56.3 77.0
9 Mary F 15 66.5 112.0

SAS Statements

SAS statements are commands to execute SAS programs.

  • The number one rule is that each statement ends with a semicolon.
  • SAS statements can be upper or lowercase.
  • SAS statements can continue to next line (provided that words are not split across two lines)
  • SAS statements can be on the same line as other statements.
  • There are two ways to comment SAS code:
    • Start a line with * and end with a semicolon
    • Start a comment with /* and end with */

SAS Data Sets

  • As with R data sets each row is an observation, and the columns represent variables associated with that observation.
  • There are only two data types in SAS:
    • Numeric
    • Character
  • Missing data is represented with a period (.)
  • General rules for variable names in SAS:
    • Names must be 32 characters of fewer in length
    • Names must start with a letter of underscore
    • Names can contain letters (upper or lowercase), numerals, or underscores.

DATA and PROC Steps

SAS programs are construced using statements in the two building blocks: DATA steps and PROC steps.

DATA Steps

  • DATA Steps read and modify data.
  • DATA Steps start with the DATA statement followed by the name for the created SAS data set.
  • DATA Steps can:
    • read external data files
    • include DO loops, IF-THEN/ELSE logic, and other built in functions
    • combine or merge data sets.
In [92]:
* This creates a new data set with only females;
data class;
    set sashelp.class;
    if Sex = 'F';
run;

/* 
Do not print this time 
Proc print data=class;
run;
*/
Out[92]:

1070  ods listing close;ods html5 file=stdout options(bitmap_mode='inline') device=png; ods graphics on / outputfmt=png;
NOTE: Writing HTML5 Body file: STDOUT
1071  
1072  * This creates a new data set with only females;
1073  data class;
1074      set sashelp.class;
1075      if Sex = 'F';
1076  run;
NOTE: There were 19 observations read from the data set SASHELP.CLASS.
NOTE: The data set WORK.CLASS has 9 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
1077  
1078  /*
1079  Do not print this time
1080  Proc print data=class;
1081  run;
1082  */
1083  
1084  ods html5 close;ods listing;

1085
In [93]:
data fish;
    set sashelp.fish;
run;
Out[93]:

1087  ods listing close;ods html5 file=stdout options(bitmap_mode='inline') device=png; ods graphics on / outputfmt=png;
NOTE: Writing HTML5 Body file: STDOUT
1088  
1089  data fish;
1090      set sashelp.fish;
1091  run;
NOTE: There were 159 observations read from the data set SASHELP.FISH.
NOTE: The data set WORK.FISH has 159 observations and 7 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
1092  ods html5 close;ods listing;

1093

PROC Steps

  • Procedures start with a PROC statement
  • The keyword "PROC" is followed by the procedure name (PRINT)
  • Most procedure have a handful of options - similar to arguments in R functions.
  • A PROC step ends with a run statement (run;)
  • SAS procedures produce results or output.
In [94]:
proc print data=fish;
run;
Out[94]:
SAS Output

Bridger Bowl Ski Facts

Obs Species Weight Length1 Length2 Length3 Height Width
1 Bream 242.0 23.2 25.4 30.0 11.5200 4.0200
2 Bream 290.0 24.0 26.3 31.2 12.4800 4.3056
3 Bream 340.0 23.9 26.5 31.1 12.3778 4.6961
4 Bream 363.0 26.3 29.0 33.5 12.7300 4.4555
5 Bream 430.0 26.5 29.0 34.0 12.4440 5.1340
6 Bream 450.0 26.8 29.7 34.7 13.6024 4.9274
7 Bream 500.0 26.8 29.7 34.5 14.1795 5.2785
8 Bream 390.0 27.6 30.0 35.0 12.6700 4.6900
9 Bream 450.0 27.6 30.0 35.1 14.0049 4.8438
10 Bream 500.0 28.5 30.7 36.2 14.2266 4.9594
11 Bream 475.0 28.4 31.0 36.2 14.2628 5.1042
12 Bream 500.0 28.7 31.0 36.2 14.3714 4.8146
13 Bream 500.0 29.1 31.5 36.4 13.7592 4.3680
14 Bream . 29.5 32.0 37.3 13.9129 5.0728
15 Bream 600.0 29.4 32.0 37.2 14.9544 5.1708
16 Bream 600.0 29.4 32.0 37.2 15.4380 5.5800
17 Bream 700.0 30.4 33.0 38.3 14.8604 5.2854
18 Bream 700.0 30.4 33.0 38.5 14.9380 5.1975
19 Bream 610.0 30.9 33.5 38.6 15.6330 5.1338
20 Bream 650.0 31.0 33.5 38.7 14.4738 5.7276
21 Bream 575.0 31.3 34.0 39.5 15.1285 5.5695
22 Bream 685.0 31.4 34.0 39.2 15.9936 5.3704
23 Bream 620.0 31.5 34.5 39.7 15.5227 5.2801
24 Bream 680.0 31.8 35.0 40.6 15.4686 6.1306
25 Bream 700.0 31.9 35.0 40.5 16.2405 5.5890
26 Bream 725.0 31.8 35.0 40.9 16.3600 6.0532
27 Bream 720.0 32.0 35.0 40.6 16.3618 6.0900
28 Bream 714.0 32.7 36.0 41.5 16.5170 5.8515
29 Bream 850.0 32.8 36.0 41.6 16.8896 6.1984
30 Bream 1000.0 33.5 37.0 42.6 18.9570 6.6030
31 Bream 920.0 35.0 38.5 44.1 18.0369 6.3063
32 Bream 955.0 35.0 38.5 44.0 18.0840 6.2920
33 Bream 925.0 36.2 39.5 45.3 18.7542 6.7497
34 Bream 975.0 37.4 41.0 45.9 18.6354 6.7473
35 Bream 950.0 38.0 41.0 46.5 17.6235 6.3705
36 Roach 40.0 12.9 14.1 16.2 4.1472 2.2680
37 Roach 69.0 16.5 18.2 20.3 5.2983 2.8217
38 Roach 78.0 17.5 18.8 21.2 5.5756 2.9044
39 Roach 87.0 18.2 19.8 22.2 5.6166 3.1746
40 Roach 120.0 18.6 20.0 22.2 6.2160 3.5742
41 Roach 0.0 19.0 20.5 22.8 6.4752 3.3516
42 Roach 110.0 19.1 20.8 23.1 6.1677 3.3957
43 Roach 120.0 19.4 21.0 23.7 6.1146 3.2943
44 Roach 150.0 20.4 22.0 24.7 5.8045 3.7544
45 Roach 145.0 20.5 22.0 24.3 6.6339 3.5478
46 Roach 160.0 20.5 22.5 25.3 7.0334 3.8203
47 Roach 140.0 21.0 22.5 25.0 6.5500 3.3250
48 Roach 160.0 21.1 22.5 25.0 6.4000 3.8000
49 Roach 169.0 22.0 24.0 27.2 7.5344 3.8352
50 Roach 161.0 22.0 23.4 26.7 6.9153 3.6312
51 Roach 200.0 22.1 23.5 26.8 7.3968 4.1272
52 Roach 180.0 23.6 25.2 27.9 7.0866 3.9060
53 Roach 290.0 24.0 26.0 29.2 8.8768 4.4968
54 Roach 272.0 25.0 27.0 30.6 8.5680 4.7736
55 Roach 390.0 29.5 31.7 35.0 9.4850 5.3550
56 Whitefish 270.0 23.6 26.0 28.7 8.3804 4.2476
57 Whitefish 270.0 24.1 26.5 29.3 8.1454 4.2485
58 Whitefish 306.0 25.6 28.0 30.8 8.7780 4.6816
59 Whitefish 540.0 28.5 31.0 34.0 10.7440 6.5620
60 Whitefish 800.0 33.7 36.4 39.6 11.7612 6.5736
61 Whitefish 1000.0 37.3 40.0 43.5 12.3540 6.5250
62 Parkki 55.0 13.5 14.7 16.5 6.8475 2.3265
63 Parkki 60.0 14.3 15.5 17.4 6.5772 2.3142
64 Parkki 90.0 16.3 17.7 19.8 7.4052 2.6730
65 Parkki 120.0 17.5 19.0 21.3 8.3922 2.9181
66 Parkki 150.0 18.4 20.0 22.4 8.8928 3.2928
67 Parkki 140.0 19.0 20.7 23.2 8.5376 3.2944
68 Parkki 170.0 19.0 20.7 23.2 9.3960 3.4104
69 Parkki 145.0 19.8 21.5 24.1 9.7364 3.1571
70 Parkki 200.0 21.2 23.0 25.8 10.3458 3.6636
71 Parkki 273.0 23.0 25.0 28.0 11.0880 4.1440
72 Parkki 300.0 24.0 26.0 29.0 11.3680 4.2340
73 Perch 5.9 7.5 8.4 8.8 2.1120 1.4080
74 Perch 32.0 12.5 13.7 14.7 3.5280 1.9992
75 Perch 40.0 13.8 15.0 16.0 3.8240 2.4320
76 Perch 51.5 15.0 16.2 17.2 4.5924 2.6316
77 Perch 70.0 15.7 17.4 18.5 4.5880 2.9415
78 Perch 100.0 16.2 18.0 19.2 5.2224 3.3216
79 Perch 78.0 16.8 18.7 19.4 5.1992 3.1234
80 Perch 80.0 17.2 19.0 20.2 5.6358 3.0502
81 Perch 85.0 17.8 19.6 20.8 5.1376 3.0368
82 Perch 85.0 18.2 20.0 21.0 5.0820 2.7720
83 Perch 110.0 19.0 21.0 22.5 5.6925 3.5550
84 Perch 115.0 19.0 21.0 22.5 5.9175 3.3075
85 Perch 125.0 19.0 21.0 22.5 5.6925 3.6675
86 Perch 130.0 19.3 21.3 22.8 6.3840 3.5340
87 Perch 120.0 20.0 22.0 23.5 6.1100 3.4075
88 Perch 120.0 20.0 22.0 23.5 5.6400 3.5250
89 Perch 130.0 20.0 22.0 23.5 6.1100 3.5250
90 Perch 135.0 20.0 22.0 23.5 5.8750 3.5250
91 Perch 110.0 20.0 22.0 23.5 5.5225 3.9950
92 Perch 130.0 20.5 22.5 24.0 5.8560 3.6240
93 Perch 150.0 20.5 22.5 24.0 6.7920 3.6240
94 Perch 145.0 20.7 22.7 24.2 5.9532 3.6300
95 Perch 150.0 21.0 23.0 24.5 5.2185 3.6260
96 Perch 170.0 21.5 23.5 25.0 6.2750 3.7250
97 Perch 225.0 22.0 24.0 25.5 7.2930 3.7230
98 Perch 145.0 22.0 24.0 25.5 6.3750 3.8250
99 Perch 188.0 22.6 24.6 26.2 6.7334 4.1658
100 Perch 180.0 23.0 25.0 26.5 6.4395 3.6835
101 Perch 197.0 23.5 25.6 27.0 6.5610 4.2390
102 Perch 218.0 25.0 26.5 28.0 7.1680 4.1440
103 Perch 300.0 25.2 27.3 28.7 8.3230 5.1373
104 Perch 260.0 25.4 27.5 28.9 7.1672 4.3350
105 Perch 265.0 25.4 27.5 28.9 7.0516 4.3350
106 Perch 250.0 25.4 27.5 28.9 7.2828 4.5662
107 Perch 250.0 25.9 28.0 29.4 7.8204 4.2042
108 Perch 300.0 26.9 28.7 30.1 7.5852 4.6354
109 Perch 320.0 27.8 30.0 31.6 7.6156 4.7716
110 Perch 514.0 30.5 32.8 34.0 10.0300 6.0180
111 Perch 556.0 32.0 34.5 36.5 10.2565 6.3875
112 Perch 840.0 32.5 35.0 37.3 11.4884 7.7957
113 Perch 685.0 34.0 36.5 39.0 10.8810 6.8640
114 Perch 700.0 34.0 36.0 38.3 10.6091 6.7408
115 Perch 700.0 34.5 37.0 39.4 10.8350 6.2646
116 Perch 690.0 34.6 37.0 39.3 10.5717 6.3666
117 Perch 900.0 36.5 39.0 41.4 11.1366 7.4934
118 Perch 650.0 36.5 39.0 41.4 11.1366 6.0030
119 Perch 820.0 36.6 39.0 41.3 12.4313 7.3514
120 Perch 850.0 36.9 40.0 42.3 11.9286 7.1064
121 Perch 900.0 37.0 40.0 42.5 11.7300 7.2250
122 Perch 1015.0 37.0 40.0 42.4 12.3808 7.4624
123 Perch 820.0 37.1 40.0 42.5 11.1350 6.6300
124 Perch 1100.0 39.0 42.0 44.6 12.8002 6.8684
125 Perch 1000.0 39.8 43.0 45.2 11.9328 7.2772
126 Perch 1100.0 40.1 43.0 45.5 12.5125 7.4165
127 Perch 1000.0 40.2 43.5 46.0 12.6040 8.1420
128 Perch 1000.0 41.1 44.0 46.6 12.4888 7.5958
129 Pike 200.0 30.0 32.3 34.8 5.5680 3.3756
130 Pike 300.0 31.7 34.0 37.8 5.7078 4.1580
131 Pike 300.0 32.7 35.0 38.8 5.9364 4.3844
132 Pike 300.0 34.8 37.3 39.8 6.2884 4.0198
133 Pike 430.0 35.5 38.0 40.5 7.2900 4.5765
134 Pike 345.0 36.0 38.5 41.0 6.3960 3.9770
135 Pike 456.0 40.0 42.5 45.5 7.2800 4.3225
136 Pike 510.0 40.0 42.5 45.5 6.8250 4.4590
137 Pike 540.0 40.1 43.0 45.8 7.7860 5.1296
138 Pike 500.0 42.0 45.0 48.0 6.9600 4.8960
139 Pike 567.0 43.2 46.0 48.7 7.7920 4.8700
140 Pike 770.0 44.8 48.0 51.2 7.6800 5.3760
141 Pike 950.0 48.3 51.7 55.1 8.9262 6.1712
142 Pike 1250.0 52.0 56.0 59.7 10.6863 6.9849
143 Pike 1600.0 56.0 60.0 64.0 9.6000 6.1440
144 Pike 1550.0 56.0 60.0 64.0 9.6000 6.1440
145 Pike 1650.0 59.0 63.4 68.0 10.8120 7.4800
146 Smelt 6.7 9.3 9.8 10.8 1.7388 1.0476
147 Smelt 7.5 10.0 10.5 11.6 1.9720 1.1600
148 Smelt 7.0 10.1 10.6 11.6 1.7284 1.1484
149 Smelt 9.7 10.4 11.0 12.0 2.1960 1.3800
150 Smelt 9.8 10.7 11.2 12.4 2.0832 1.2772
151 Smelt 8.7 10.8 11.3 12.6 1.9782 1.2852
152 Smelt 10.0 11.3 11.8 13.1 2.2139 1.2838
153 Smelt 9.9 11.3 11.8 13.1 2.2139 1.1659
154 Smelt 9.8 11.4 12.0 13.2 2.2044 1.1484
155 Smelt 12.2 11.5 12.2 13.4 2.0904 1.3936
156 Smelt 13.4 11.7 12.4 13.5 2.4300 1.2690
157 Smelt 12.2 12.1 13.0 13.8 2.2770 1.2558
158 Smelt 19.7 13.2 14.3 15.2 2.8728 2.0672
159 Smelt 19.9 13.8 15.0 16.2 2.9322 1.8792

Getting Data into SAS

There are four common ways to import data into SAS:

  1. Enter data directly into a SAS data file
  2. Create a SAS data file from another raw data file
  3. Convert other software's files into SAS data sets
  4. Reading other software's files directly

For now, we will focus on entering data directly and reading .CSV files using PROC IMPORT.

Creating SAS Data Files from raw data

Similar to constructing an R data frame, SAS data files can be created from raw data.

In [95]:
* Read raw data into SAS data file called skicounts;
DATA skicounts;
    INPUT NewSnow $ Day $ NumSkiers $;
    DATALINES;
28 SAT 5,200
13 SUN 6,300
4 MON 3,400
0 TUE 2,150
;
RUN;
Out[95]:

1102  ods listing close;ods html5 file=stdout options(bitmap_mode='inline') device=png; ods graphics on / outputfmt=png;
NOTE: Writing HTML5 Body file: STDOUT
1103  
1104  * Read raw data into SAS data file called skicounts;
1105  DATA skicounts;
1106      INPUT NewSnow $ Day $ NumSkiers $;
1107      DATALINES;
NOTE: The data set WORK.SKICOUNTS has 4 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
1112  ;
1113  RUN;
1114  ods html5 close;ods listing;

1115
In [96]:
PROC PRINT DATA=skicounts;
    TITLE 'Number of Skiers';
RUN;
Out[96]:
SAS Output

Number of Skiers

Obs NewSnow Day NumSkiers
1 28 SAT 5,200
2 13 SUN 6,300
3 4 MON 3,400
4 0 TUE 2,150
In [97]:
* Read in titanic;
PROC IMPORT DATAFILE = 'titanic.csv' OUT = titanic
    REPLACE;
RUN;
Out[97]:

1125  ods listing close;ods html5 file=stdout options(bitmap_mode='inline') device=png; ods graphics on / outputfmt=png;
NOTE: Writing HTML5 Body file: STDOUT
1126  
1127  * Read in titanic;
1128  PROC IMPORT DATAFILE = 'titanic.csv' OUT = titanic
1129      REPLACE;
1130  RUN;
1131   /**********************************************************************
1132   *   PRODUCT:   SAS
1133   *   VERSION:   9.4
1134   *   CREATOR:   External File Interface
1135   *   DATE:      29MAR17
1136   *   DESC:      Generated SAS Datastep Code
1137   *   TEMPLATE SOURCE:  (None Specified.)
1138   ***********************************************************************/
1139      data WORK.TITANIC    ;
1140      %let _EFIERR_ = 0; /* set the ERROR detection macro variable */
1141      infile 'titanic.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
1142         informat PassengerId best32. ;
1143         informat Survived best32. ;
1144         informat Pclass best32. ;
1145         informat Name $57. ;
1146         informat Sex $6. ;
1147         informat Age best32. ;
1148         informat SibSp best32. ;
1149         informat Parch best32. ;
1150         informat Ticket $16. ;
1151         informat Fare best32. ;
1152         informat Cabin $4. ;
1153         informat Embarked $1. ;
1154         format PassengerId best12. ;
1155         format Survived best12. ;
1156         format Pclass best12. ;
1157         format Name $57. ;
1158         format Sex $6. ;
1159         format Age best12. ;
1160         format SibSp best12. ;
1161         format Parch best12. ;
1162         format Ticket $16. ;
1163         format Fare best12. ;
1164         format Cabin $4. ;
1165         format Embarked $1. ;
1166      input
1167                  PassengerId
1168                  Survived
1169                  Pclass
1170                  Name $
1171                  Sex $
1172                  Age
1173                  SibSp
1174                  Parch
1175                  Ticket $
1176                  Fare
1177                  Cabin $
1178                  Embarked $
1179      ;
1180      if _ERROR_ then call symputx('_EFIERR_',1);  /* set ERROR detection macro variable */
1181      run;
NOTE: The infile 'titanic.csv' is:
      Filename=/mnt/hgfs/myfolders/titanic.csv,
      Owner Name=root,Group Name=vboxsf,
      Access Permission=-rwxrwx---,
      Last Modified=20Mar2017:17:08:51,
      File Size (bytes)=61194

NOTE: 891 records were read from the infile 'titanic.csv'.
      The minimum record length was 48.
      The maximum record length was 127.
NOTE: The data set WORK.TITANIC has 891 observations and 12 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
891 rows created in WORK.TITANIC from titanic.csv.
  
  
  
NOTE: WORK.TITANIC data set was successfully created.
NOTE: The data set WORK.TITANIC has 891 observations and 12 variables.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.13 seconds
      cpu time            0.09 seconds
      
1182  ods html5 close;ods listing;

1183
In [98]:
PROC PRINT DATA= Titanic;
    TITLE 'Information about passengers on Titanic';
RUN;
Out[98]:
SAS Output

Information about passengers on Titanic

Obs PassengerId Survived Pclass Name Sex Age SibSp Parch Ticket Fare Cabin Embarked
1 1 0 3 Braund, Mr. Owen Harris male 22 1 0 A/5 21171 7.25   S
2 2 1 1 Cumings, Mrs. John Bradley (Florence Briggs Thayer) female 38 1 0 PC 17599 71.2833 C85 C
3 3 1 3 Heikkinen, Miss. Laina female 26 0 0 STON/O2. 3101282 7.925   S
4 4 1 1 Futrelle, Mrs. Jacques Heath (Lily May Peel) female 35 1 0 113803 53.1 C123 S
5 5 0 3 Allen, Mr. William Henry male 35 0 0 373450 8.05   S
6 6 0 3 Moran, Mr. James male . 0 0 330877 8.4583   Q
7 7 0 1 McCarthy, Mr. Timothy J male 54 0 0 17463 51.8625 E46 S
8 8 0 3 Palsson, Master. Gosta Leonard male 2 3 1 349909 21.075   S
9 9 1 3 Johnson, Mrs. Oscar W (Elisabeth Vilhelmina Berg) female 27 0 2 347742 11.1333   S
10 10 1 2 Nasser, Mrs. Nicholas (Adele Achem) female 14 1 0 237736 30.0708   C
11 11 1 3 Sandstrom, Miss. Marguerite Rut female 4 1 1 PP 9549 16.7 G6 S
12 12 1 1 Bonnell, Miss. Elizabeth female 58 0 0 113783 26.55 C103 S
13 13 0 3 Saundercock, Mr. William Henry male 20 0 0 A/5. 2151 8.05   S
14 14 0 3 Andersson, Mr. Anders Johan male 39 1 5 347082 31.275   S
15 15 0 3 Vestrom, Miss. Hulda Amanda Adolfina female 14 0 0 350406 7.8542   S
16 16 1 2 Hewlett, Mrs. (Mary D Kingcome) female 55 0 0 248706 16   S
17 17 0 3 Rice, Master. Eugene male 2 4 1 382652 29.125   Q
18 18 1 2 Williams, Mr. Charles Eugene male . 0 0 244373 13   S
19 19 0 3 Vander Planke, Mrs. Julius (Emelia Maria Vandemoortele) female 31 1 0 345763 18   S
20 20 1 3 Masselmani, Mrs. Fatima female . 0 0 2649 7.225   C
21 21 0 2 Fynney, Mr. Joseph J male 35 0 0 239865 26   S
22 22 1 2 Beesley, Mr. Lawrence male 34 0 0 248698 13 D56 S
23 23 1 3 McGowan, Miss. Anna "Annie" female 15 0 0 330923 8.0292   Q
24 24 1 1 Sloper, Mr. William Thompson male 28 0 0 113788 35.5 A6 S
25 25 0 3 Palsson, Miss. Torborg Danira female 8 3 1 349909 21.075   S
26 26 1 3 Asplund, Mrs. Carl Oscar (Selma Augusta Emilia Johansson) female 38 1 5 347077 31.3875   S
27 27 0 3 Emir, Mr. Farred Chehab male . 0 0 2631 7.225   C
28 28 0 1 Fortune, Mr. Charles Alexander male 19 3 2 19950 263 C23 S
29 29 1 3 O'Dwyer, Miss. Ellen "Nellie" female . 0 0 330959 7.8792   Q
30 30 0 3 Todoroff, Mr. Lalio male . 0 0 349216 7.8958   S
31 31 0 1 Uruchurtu, Don. Manuel E male 40 0 0 PC 17601 27.7208   C
32 32 1 1 Spencer, Mrs. William Augustus (Marie Eugenie) female . 1 0 PC 17569 146.5208 B78 C
33 33 1 3 Glynn, Miss. Mary Agatha female . 0 0 335677 7.75   Q
34 34 0 2 Wheadon, Mr. Edward H male 66 0 0 C.A. 24579 10.5   S
35 35 0 1 Meyer, Mr. Edgar Joseph male 28 1 0 PC 17604 82.1708   C
36 36 0 1 Holverson, Mr. Alexander Oskar male 42 1 0 113789 52   S
37 37 1 3 Mamee, Mr. Hanna male . 0 0 2677 7.2292   C
38 38 0 3 Cann, Mr. Ernest Charles male 21 0 0 A./5. 2152 8.05   S
39 39 0 3 Vander Planke, Miss. Augusta Maria female 18 2 0 345764 18   S
40 40 1 3 Nicola-Yarred, Miss. Jamila female 14 1 0 2651 11.2417   C
41 41 0 3 Ahlin, Mrs. Johan (Johanna Persdotter Larsson) female 40 1 0 7546 9.475   S
42 42 0 2 Turpin, Mrs. William John Robert (Dorothy Ann Wonnacott) female 27 1 0 11668 21   S
43 43 0 3 Kraeff, Mr. Theodor male . 0 0 349253 7.8958   C
44 44 1 2 Laroche, Miss. Simonne Marie Anne Andree female 3 1 2 SC/Paris 2123 41.5792   C
45 45 1 3 Devaney, Miss. Margaret Delia female 19 0 0 330958 7.8792   Q
46 46 0 3 Rogers, Mr. William John male . 0 0 S.C./A.4. 23567 8.05   S
47 47 0 3 Lennon, Mr. Denis male . 1 0 370371 15.5   Q
48 48 1 3 O'Driscoll, Miss. Bridget female . 0 0 14311 7.75   Q
49 49 0 3 Samaan, Mr. Youssef male . 2 0 2662 21.6792   C
50 50 0 3 Arnold-Franchi, Mrs. Josef (Josefine Franchi) female 18 1 0 349237 17.8   S
51 51 0 3 Panula, Master. Juha Niilo male 7 4 1 3101295 39.6875   S
52 52 0 3 Nosworthy, Mr. Richard Cater male 21 0 0 A/4. 39886 7.8   S
53 53 1 1 Harper, Mrs. Henry Sleeper (Myna Haxtun) female 49 1 0 PC 17572 76.7292 D33 C
54 54 1 2 Faunthorpe, Mrs. Lizzie (Elizabeth Anne Wilkinson) female 29 1 0 2926 26   S
55 55 0 1 Ostby, Mr. Engelhart Cornelius male 65 0 1 113509 61.9792 B30 C
56 56 1 1 Woolner, Mr. Hugh male . 0 0 19947 35.5 C52 S
57 57 1 2 Rugg, Miss. Emily female 21 0 0 C.A. 31026 10.5   S
58 58 0 3 Novel, Mr. Mansouer male 28.5 0 0 2697 7.2292   C
59 59 1 2 West, Miss. Constance Mirium female 5 1 2 C.A. 34651 27.75   S
60 60 0 3 Goodwin, Master. William Frederick male 11 5 2 CA 2144 46.9   S
61 61 0 3 Sirayanian, Mr. Orsen male 22 0 0 2669 7.2292   C
62 62 1 1 Icard, Miss. Amelie female 38 0 0 113572 80 B28  
63 63 0 1 Harris, Mr. Henry Birkhardt male 45 1 0 36973 83.475 C83 S
64 64 0 3 Skoog, Master. Harald male 4 3 2 347088 27.9   S
65 65 0 1 Stewart, Mr. Albert A male . 0 0 PC 17605 27.7208   C
66 66 1 3 Moubarek, Master. Gerios male . 1 1 2661 15.2458   C
67 67 1 2 Nye, Mrs. (Elizabeth Ramell) female 29 0 0 C.A. 29395 10.5 F33 S
68 68 0 3 Crease, Mr. Ernest James male 19 0 0 S.P. 3464 8.1583   S
69 69 1 3 Andersson, Miss. Erna Alexandra female 17 4 2 3101281 7.925   S
70 70 0 3 Kink, Mr. Vincenz male 26 2 0 315151 8.6625   S
71 71 0 2 Jenkin, Mr. Stephen Curnow male 32 0 0 C.A. 33111 10.5   S
72 72 0 3 Goodwin, Miss. Lillian Amy female 16 5 2 CA 2144 46.9   S
73 73 0 2 Hood, Mr. Ambrose Jr male 21 0 0 S.O.C. 14879 73.5   S
74 74 0 3 Chronopoulos, Mr. Apostolos male 26 1 0 2680 14.4542   C
75 75 1 3 Bing, Mr. Lee male 32 0 0 1601 56.4958   S
76 76 0 3 Moen, Mr. Sigurd Hansen male 25 0 0 348123 7.65 F G7 S
77 77 0 3 Staneff, Mr. Ivan male . 0 0 349208 7.8958   S
78 78 0 3 Moutal, Mr. Rahamin Haim male . 0 0 374746 8.05   S
79 79 1 2 Caldwell, Master. Alden Gates male 0.83 0 2 248738 29   S
80 80 1 3 Dowdell, Miss. Elizabeth female 30 0 0 364516 12.475   S
81 81 0 3 Waelens, Mr. Achille male 22 0 0 345767 9   S
82 82 1 3 Sheerlinck, Mr. Jan Baptist male 29 0 0 345779 9.5   S
83 83 1 3 McDermott, Miss. Brigdet Delia female . 0 0 330932 7.7875   Q
84 84 0 1 Carrau, Mr. Francisco M male 28 0 0 113059 47.1   S
85 85 1 2 Ilett, Miss. Bertha female 17 0 0 SO/C 14885 10.5   S
86 86 1 3 Backstrom, Mrs. Karl Alfred (Maria Mathilda Gustafsson) female 33 3 0 3101278 15.85   S
87 87 0 3 Ford, Mr. William Neal male 16 1 3 W./C. 6608 34.375   S
88 88 0 3 Slocovski, Mr. Selman Francis male . 0 0 SOTON/OQ 392086 8.05   S
89 89 1 1 Fortune, Miss. Mabel Helen female 23 3 2 19950 263 C23 S
90 90 0 3 Celotti, Mr. Francesco male 24 0 0 343275 8.05   S
91 91 0 3 Christmann, Mr. Emil male 29 0 0 343276 8.05   S
92 92 0 3 Andreasson, Mr. Paul Edvin male 20 0 0 347466 7.8542   S
93 93 0 1 Chaffee, Mr. Herbert Fuller male 46 1 0 W.E.P. 5734 61.175 E31 S
94 94 0 3 Dean, Mr. Bertram Frank male 26 1 2 C.A. 2315 20.575   S
95 95 0 3 Coxon, Mr. Daniel male 59 0 0 364500 7.25   S
96 96 0 3 Shorney, Mr. Charles Joseph male . 0 0 374910 8.05   S
97 97 0 1 Goldschmidt, Mr. George B male 71 0 0 PC 17754 34.6542 A5 C
98 98 1 1 Greenfield, Mr. William Bertram male 23 0 1 PC 17759 63.3583 D10 C
99 99 1 2 Doling, Mrs. John T (Ada Julia Bone) female 34 0 1 231919 23   S
100 100 0 2 Kantor, Mr. Sinai male 34 1 0 244367 26   S
101 101 0 3 Petranec, Miss. Matilda female 28 0 0 349245 7.8958   S
102 102 0 3 Petroff, Mr. Pastcho ("Pentcho") male . 0 0 349215 7.8958   S
103 103 0 1 White, Mr. Richard Frasar male 21 0 1 35281 77.2875 D26 S
104 104 0 3 Johansson, Mr. Gustaf Joel male 33 0 0 7540 8.6542   S
105 105 0 3 Gustafsson, Mr. Anders Vilhelm male 37 2 0 3101276 7.925   S
106 106 0 3 Mionoff, Mr. Stoytcho male 28 0 0 349207 7.8958   S
107 107 1 3 Salkjelsvik, Miss. Anna Kristine female 21 0 0 343120 7.65   S
108 108 1 3 Moss, Mr. Albert Johan male . 0 0 312991 7.775   S
109 109 0 3 Rekic, Mr. Tido male 38 0 0 349249 7.8958   S
110 110 1 3 Moran, Miss. Bertha female . 1 0 371110 24.15   Q
111 111 0 1 Porter, Mr. Walter Chamberlain male 47 0 0 110465 52 C110 S
112 112 0 3 Zabour, Miss. Hileni female 14.5 1 0 2665 14.4542   C
113 113 0 3 Barton, Mr. David John male 22 0 0 324669 8.05   S
114 114 0 3 Jussila, Miss. Katriina female 20 1 0 4136 9.825   S
115 115 0 3 Attalah, Miss. Malake female 17 0 0 2627 14.4583   C
116 116 0 3 Pekoniemi, Mr. Edvard male 21 0 0 STON/O 2. 310129 7.925   S
117 117 0 3 Connors, Mr. Patrick male 70.5 0 0 370369 7.75   Q
118 118 0 2 Turpin, Mr. William John Robert male 29 1 0 11668 21   S
119 119 0 1 Baxter, Mr. Quigg Edmond male 24 0 1 PC 17558 247.5208 B58 C
120 120 0 3 Andersson, Miss. Ellis Anna Maria female 2 4 2 347082 31.275   S
121 121 0 2 Hickman, Mr. Stanley George male 21 2 0 S.O.C. 14879 73.5   S
122 122 0 3 Moore, Mr. Leonard Charles male . 0 0 A4. 54510 8.05   S
123 123 0 2 Nasser, Mr. Nicholas male 32.5 1 0 237736 30.0708   C
124 124 1 2 Webber, Miss. Susan female 32.5 0 0 27267 13 E101 S
125 125 0 1 White, Mr. Percival Wayland male 54 0 1 35281 77.2875 D26 S
126 126 1 3 Nicola-Yarred, Master. Elias male 12 1 0 2651 11.2417   C
127 127 0 3 McMahon, Mr. Martin male . 0 0 370372 7.75   Q
128 128 1 3 Madsen, Mr. Fridtjof Arne male 24 0 0 C 17369 7.1417   S
129 129 1 3 Peter, Miss. Anna female . 1 1 2668 22.3583 F E6 C
130 130 0 3 Ekstrom, Mr. Johan male 45 0 0 347061 6.975   S
131 131 0 3 Drazenoic, Mr. Jozef male 33 0 0 349241 7.8958   C
132 132 0 3 Coelho, Mr. Domingos Fernandeo male 20 0 0 SOTON/O.Q. 31013 7.05   S
133 133 0 3 Robins, Mrs. Alexander A (Grace Charity Laury) female 47 1 0 A/5. 3337 14.5   S
134 134 1 2 Weisz, Mrs. Leopold (Mathilde Francoise Pede) female 29 1 0 228414 26   S
135 135 0 2 Sobey, Mr. Samuel James Hayden male 25 0 0 C.A. 29178 13   S
136 136 0 2 Richard, Mr. Emile male 23 0 0 SC/PARIS 2133 15.0458   C
137 137 1 1 Newsom, Miss. Helen Monypeny female 19 0 2 11752 26.2833 D47 S
138 138 0 1 Futrelle, Mr. Jacques Heath male 37 1 0 113803 53.1 C123 S
139 139 0 3 Osen, Mr. Olaf Elon male 16 0 0 7534 9.2167   S
140 140 0 1 Giglio, Mr. Victor male 24 0 0 PC 17593 79.2 B86 C
141 141 0 3 Boulos, Mrs. Joseph (Sultana) female . 0 2 2678 15.2458   C
142 142 1 3 Nysten, Miss. Anna Sofia female 22 0 0 347081 7.75   S
143 143 1 3 Hakkarainen, Mrs. Pekka Pietari (Elin Matilda Dolck) female 24 1 0 STON/O2. 3101279 15.85   S
144 144 0 3 Burke, Mr. Jeremiah male 19 0 0 365222 6.75   Q
145 145 0 2 Andrew, Mr. Edgardo Samuel male 18 0 0 231945 11.5   S
146 146 0 2 Nicholls, Mr. Joseph Charles male 19 1 1 C.A. 33112 36.75   S
147 147 1 3 Andersson, Mr. August Edvard ("Wennerstrom") male 27 0 0 350043 7.7958   S
148 148 0 3 Ford, Miss. Robina Maggie "Ruby" female 9 2 2 W./C. 6608 34.375   S
149 149 0 2 Navratil, Mr. Michel ("Louis M Hoffman") male 36.5 0 2 230080 26 F2 S
150 150 0 2 Byles, Rev. Thomas Roussel Davids male 42 0 0 244310 13   S
151 151 0 2 Bateman, Rev. Robert James male 51 0 0 S.O.P. 1166 12.525   S
152 152 1 1 Pears, Mrs. Thomas (Edith Wearne) female 22 1 0 113776 66.6 C2 S
153 153 0 3 Meo, Mr. Alfonzo male 55.5 0 0 A.5. 11206 8.05   S
154 154 0 3 van Billiard, Mr. Austin Blyler male 40.5 0 2 A/5. 851 14.5   S
155 155 0 3 Olsen, Mr. Ole Martin male . 0 0 Fa 265302 7.3125   S
156 156 0 1 Williams, Mr. Charles Duane male 51 0 1 PC 17597 61.3792   C
157 157 1 3 Gilnagh, Miss. Katherine "Katie" female 16 0 0 35851 7.7333   Q
158 158 0 3 Corn, Mr. Harry male 30 0 0 SOTON/OQ 392090 8.05   S
159 159 0 3 Smiljanic, Mr. Mile male . 0 0 315037 8.6625   S
160 160 0 3 Sage, Master. Thomas Henry male . 8 2 CA. 2343 69.55   S
161 161 0 3 Cribb, Mr. John Hatfield male 44 0 1 371362 16.1   S
162 162 1 2 Watt, Mrs. James (Elizabeth "Bessie" Inglis Milne) female 40 0 0 C.A. 33595 15.75   S
163 163 0 3 Bengtsson, Mr. John Viktor male 26 0 0 347068 7.775   S
164 164 0 3 Calic, Mr. Jovo male 17 0 0 315093 8.6625   S
165 165 0 3 Panula, Master. Eino Viljami male 1 4 1 3101295 39.6875   S
166 166 1 3 Goldsmith, Master. Frank John William "Frankie" male 9 0 2 363291 20.525   S
167 167 1 1 Chibnall, Mrs. (Edith Martha Bowerman) female . 0 1 113505 55 E33 S
168 168 0 3 Skoog, Mrs. William (Anna Bernhardina Karlsson) female 45 1 4 347088 27.9   S
169 169 0 1 Baumann, Mr. John D male . 0 0 PC 17318 25.925   S
170 170 0 3 Ling, Mr. Lee male 28 0 0 1601 56.4958   S
171 171 0 1 Van der hoef, Mr. Wyckoff male 61 0 0 111240 33.5 B19 S
172 172 0 3 Rice, Master. Arthur male 4 4 1 382652 29.125   Q
173 173 1 3 Johnson, Miss. Eleanor Ileen female 1 1 1 347742 11.1333   S
174 174 0 3 Sivola, Mr. Antti Wilhelm male 21 0 0 STON/O 2. 310128 7.925   S
175 175 0 1 Smith, Mr. James Clinch male 56 0 0 17764 30.6958 A7 C
176 176 0 3 Klasen, Mr. Klas Albin male 18 1 1 350404 7.8542   S
177 177 0 3 Lefebre, Master. Henry Forbes male . 3 1 4133 25.4667   S
178 178 0 1 Isham, Miss. Ann Elizabeth female 50 0 0 PC 17595 28.7125 C49 C
179 179 0 2 Hale, Mr. Reginald male 30 0 0 250653 13   S
180 180 0 3 Leonard, Mr. Lionel male 36 0 0 LINE 0   S
181 181 0 3 Sage, Miss. Constance Gladys female . 8 2 CA. 2343 69.55   S
182 182 0 2 Pernot, Mr. Rene male . 0 0 SC/PARIS 2131 15.05   C
183 183 0 3 Asplund, Master. Clarence Gustaf Hugo male 9 4 2 347077 31.3875   S
184 184 1 2 Becker, Master. Richard F male 1 2 1 230136 39 F4 S
185 185 1 3 Kink-Heilmann, Miss. Luise Gretchen female 4 0 2 315153 22.025   S
186 186 0 1 Rood, Mr. Hugh Roscoe male . 0 0 113767 50 A32 S
187 187 1 3 O'Brien, Mrs. Thomas (Johanna "Hannah" Godfrey) female . 1 0 370365 15.5   Q
188 188 1 1 Romaine, Mr. Charles Hallace ("Mr C Rolmane") male 45 0 0 111428 26.55   S
189 189 0 3 Bourke, Mr. John male 40 1 1 364849 15.5   Q
190 190 0 3 Turcin, Mr. Stjepan male 36 0 0 349247 7.8958   S
191 191 1 2 Pinsky, Mrs. (Rosa) female 32 0 0 234604 13   S
192 192 0 2 Carbines, Mr. William male 19 0 0 28424 13   S
193 193 1 3 Andersen-Jensen, Miss. Carla Christine Nielsine female 19 1 0 350046 7.8542   S
194 194 1 2 Navratil, Master. Michel M male 3 1 1 230080 26 F2 S
195 195 1 1 Brown, Mrs. James Joseph (Margaret Tobin) female 44 0 0 PC 17610 27.7208 B4 C
196 196 1 1 Lurette, Miss. Elise female 58 0 0 PC 17569 146.5208 B80 C
197 197 0 3 Mernagh, Mr. Robert male . 0 0 368703 7.75   Q
198 198 0 3 Olsen, Mr. Karl Siegwart Andreas male 42 0 1 4579 8.4042   S
199 199 1 3 Madigan, Miss. Margaret "Maggie" female . 0 0 370370 7.75   Q
200 200 0 2 Yrois, Miss. Henriette ("Mrs Harbeck") female 24 0 0 248747 13   S
201 201 0 3 Vande Walle, Mr. Nestor Cyriel male 28 0 0 345770 9.5   S
202 202 0 3 Sage, Mr. Frederick male . 8 2 CA. 2343 69.55   S
203 203 0 3 Johanson, Mr. Jakob Alfred male 34 0 0 3101264 6.4958   S
204 204 0 3 Youseff, Mr. Gerious male 45.5 0 0 2628 7.225   C
205 205 1 3 Cohen, Mr. Gurshon "Gus" male 18 0 0 A/5 3540 8.05   S
206 206 0 3 Strom, Miss. Telma Matilda female 2 0 1 347054 10.4625 G6 S
207 207 0 3 Backstrom, Mr. Karl Alfred male 32 1 0 3101278 15.85   S
208 208 1 3 Albimona, Mr. Nassef Cassem male 26 0 0 2699 18.7875   C
209 209 1 3 Carr, Miss. Helen "Ellen" female 16 0 0 367231 7.75   Q
210 210 1 1 Blank, Mr. Henry male 40 0 0 112277 31 A31 C
211 211 0 3 Ali, Mr. Ahmed male 24 0 0 SOTON/O.Q. 31013 7.05   S
212 212 1 2 Cameron, Miss. Clear Annie female 35 0 0 F.C.C. 13528 21   S
213 213 0 3 Perkin, Mr. John Henry male 22 0 0 A/5 21174 7.25   S
214 214 0 2 Givard, Mr. Hans Kristensen male 30 0 0 250646 13   S
215 215 0 3 Kiernan, Mr. Philip male . 1 0 367229 7.75   Q
216 216 1 1 Newell, Miss. Madeleine female 31 1 0 35273 113.275 D36 C
217 217 1 3 Honkanen, Miss. Eliina female 27 0 0 STON/O2. 3101283 7.925   S
218 218 0 2 Jacobsohn, Mr. Sidney Samuel male 42 1 0 243847 27   S
219 219 1 1 Bazzani, Miss. Albina female 32 0 0 11813 76.2917 D15 C
220 220 0 2 Harris, Mr. Walter male 30 0 0 W/C 14208 10.5   S
221 221 1 3 Sunderland, Mr. Victor Francis male 16 0 0 SOTON/OQ 392089 8.05   S
222 222 0 2 Bracken, Mr. James H male 27 0 0 220367 13   S
223 223 0 3 Green, Mr. George Henry male 51 0 0 21440 8.05   S
224 224 0 3 Nenkoff, Mr. Christo male . 0 0 349234 7.8958   S
225 225 1 1 Hoyt, Mr. Frederick Maxfield male 38 1 0 19943 90 C93 S
226 226 0 3 Berglund, Mr. Karl Ivar Sven male 22 0 0 PP 4348 9.35   S
227 227 1 2 Mellors, Mr. William John male 19 0 0 SW/PP 751 10.5   S
228 228 0 3 Lovell, Mr. John Hall ("Henry") male 20.5 0 0 A/5 21173 7.25   S
229 229 0 2 Fahlstrom, Mr. Arne Jonas male 18 0 0 236171 13   S
230 230 0 3 Lefebre, Miss. Mathilde female . 3 1 4133 25.4667   S
231 231 1 1 Harris, Mrs. Henry Birkhardt (Irene Wallach) female 35 1 0 36973 83.475 C83 S
232 232 0 3 Larsson, Mr. Bengt Edvin male 29 0 0 347067 7.775   S
233 233 0 2 Sjostedt, Mr. Ernst Adolf male 59 0 0 237442 13.5   S
234 234 1 3 Asplund, Miss. Lillian Gertrud female 5 4 2 347077 31.3875   S
235 235 0 2 Leyson, Mr. Robert William Norman male 24 0 0 C.A. 29566 10.5   S
236 236 0 3 Harknett, Miss. Alice Phoebe female . 0 0 W./C. 6609 7.55   S
237 237 0 2 Hold, Mr. Stephen male 44 1 0 26707 26   S
238 238 1 2 Collyer, Miss. Marjorie "Lottie" female 8 0 2 C.A. 31921 26.25   S
239 239 0 2 Pengelly, Mr. Frederick William male 19 0 0 28665 10.5   S
240 240 0 2 Hunt, Mr. George Henry male 33 0 0 SCO/W 1585 12.275   S
241 241 0 3 Zabour, Miss. Thamine female . 1 0 2665 14.4542   C
242 242 1 3 Murphy, Miss. Katherine "Kate" female . 1 0 367230 15.5   Q
243 243 0 2 Coleridge, Mr. Reginald Charles male 29 0 0 W./C. 14263 10.5   S
244 244 0 3 Maenpaa, Mr. Matti Alexanteri male 22 0 0 STON/O 2. 310127 7.125   S
245 245 0 3 Attalah, Mr. Sleiman male 30 0 0 2694 7.225   C
246 246 0 1 Minahan, Dr. William Edward male 44 2 0 19928 90 C78 Q
247 247 0 3 Lindahl, Miss. Agda Thorilda Viktoria female 25 0 0 347071 7.775   S
248 248 1 2 Hamalainen, Mrs. William (Anna) female 24 0 2 250649 14.5   S
249 249 1 1 Beckwith, Mr. Richard Leonard male 37 1 1 11751 52.5542 D35 S
250 250 0 2 Carter, Rev. Ernest Courtenay male 54 1 0 244252 26   S
251 251 0 3 Reed, Mr. James George male . 0 0 362316 7.25   S
252 252 0 3 Strom, Mrs. Wilhelm (Elna Matilda Persson) female 29 1 1 347054 10.4625 G6 S
253 253 0 1 Stead, Mr. William Thomas male 62 0 0 113514 26.55 C87 S
254 254 0 3 Lobb, Mr. William Arthur male 30 1 0 A/5. 3336 16.1   S
255 255 0 3 Rosblom, Mrs. Viktor (Helena Wilhelmina) female 41 0 2 370129 20.2125   S
256 256 1 3 Touma, Mrs. Darwis (Hanne Youssef Razi) female 29 0 2 2650 15.2458   C
257 257 1 1 Thorne, Mrs. Gertrude Maybelle female . 0 0 PC 17585 79.2   C
258 258 1 1 Cherry, Miss. Gladys female 30 0 0 110152 86.5 B77 S
259 259 1 1 Ward, Miss. Anna female 35 0 0 PC 17755 512.3292   C
260 260 1 2 Parrish, Mrs. (Lutie Davis) female 50 0 1 230433 26   S
261 261 0 3 Smith, Mr. Thomas male . 0 0 384461 7.75   Q
262 262 1 3 Asplund, Master. Edvin Rojj Felix male 3 4 2 347077 31.3875   S
263 263 0 1 Taussig, Mr. Emil male 52 1 1 110413 79.65 E67 S
264 264 0 1 Harrison, Mr. William male 40 0 0 112059 0 B94 S
265 265 0 3 Henry, Miss. Delia female . 0 0 382649 7.75   Q
266 266 0 2 Reeves, Mr. David male 36 0 0 C.A. 17248 10.5   S
267 267 0 3 Panula, Mr. Ernesti Arvid male 16 4 1 3101295 39.6875   S
268 268 1 3 Persson, Mr. Ernst Ulrik male 25 1 0 347083 7.775   S
269 269 1 1 Graham, Mrs. William Thompson (Edith Junkins) female 58 0 1 PC 17582 153.4625 C125 S
270 270 1 1 Bissette, Miss. Amelia female 35 0 0 PC 17760 135.6333 C99 S
271 271 0 1 Cairns, Mr. Alexander male . 0 0 113798 31   S
272 272 1 3 Tornquist, Mr. William Henry male 25 0 0 LINE 0   S
273 273 1 2 Mellinger, Mrs. (Elizabeth Anne Maidment) female 41 0 1 250644 19.5   S
274 274 0 1 Natsch, Mr. Charles H male 37 0 1 PC 17596 29.7 C118 C
275 275 1 3 Healy, Miss. Hanora "Nora" female . 0 0 370375 7.75   Q
276 276 1 1 Andrews, Miss. Kornelia Theodosia female 63 1 0 13502 77.9583 D7 S
277 277 0 3 Lindblom, Miss. Augusta Charlotta female 45 0 0 347073 7.75   S
278 278 0 2 Parkes, Mr. Francis "Frank" male . 0 0 239853 0   S
279 279 0 3 Rice, Master. Eric male 7 4 1 382652 29.125   Q
280 280 1 3 Abbott, Mrs. Stanton (Rosa Hunt) female 35 1 1 C.A. 2673 20.25   S
281 281 0 3 Duane, Mr. Frank male 65 0 0 336439 7.75   Q
282 282 0 3 Olsson, Mr. Nils Johan Goransson male 28 0 0 347464 7.8542   S
283 283 0 3 de Pelsmaeker, Mr. Alfons male 16 0 0 345778 9.5   S
284 284 1 3 Dorking, Mr. Edward Arthur male 19 0 0 A/5. 10482 8.05   S
285 285 0 1 Smith, Mr. Richard William male . 0 0 113056 26 A19 S
286 286 0 3 Stankovic, Mr. Ivan male 33 0 0 349239 8.6625   C
287 287 1 3 de Mulder, Mr. Theodore male 30 0 0 345774 9.5   S
288 288 0 3 Naidenoff, Mr. Penko male 22 0 0 349206 7.8958   S
289 289 1 2 Hosono, Mr. Masabumi male 42 0 0 237798 13   S
290 290 1 3 Connolly, Miss. Kate female 22 0 0 370373 7.75   Q
291 291 1 1 Barber, Miss. Ellen "Nellie" female 26 0 0 19877 78.85   S
292 292 1 1 Bishop, Mrs. Dickinson H (Helen Walton) female 19 1 0 11967 91.0792 B49 C
293 293 0 2 Levy, Mr. Rene Jacques male 36 0 0 SC/Paris 2163 12.875 D C
294 294 0 3 Haas, Miss. Aloisia female 24 0 0 349236 8.85   S
295 295 0 3 Mineff, Mr. Ivan male 24 0 0 349233 7.8958   S
296 296 0 1 Lewy, Mr. Ervin G male . 0 0 PC 17612 27.7208   C
297 297 0 3 Hanna, Mr. Mansour male 23.5 0 0 2693 7.2292   C
298 298 0 1 Allison, Miss. Helen Loraine female 2 1 2 113781 151.55 C22 S
299 299 1 1 Saalfeld, Mr. Adolphe male . 0 0 19988 30.5 C106 S
300 300 1 1 Baxter, Mrs. James (Helene DeLaudeniere Chaput) female 50 0 1 PC 17558 247.5208 B58 C
301 301 1 3 Kelly, Miss. Anna Katherine "Annie Kate" female . 0 0 9234 7.75   Q
302 302 1 3 McCoy, Mr. Bernard male . 2 0 367226 23.25   Q
303 303 0 3 Johnson, Mr. William Cahoone Jr male 19 0 0 LINE 0   S
304 304 1 2 Keane, Miss. Nora A female . 0 0 226593 12.35 E101 Q
305 305 0 3 Williams, Mr. Howard Hugh "Harry" male . 0 0 A/5 2466 8.05   S
306 306 1 1 Allison, Master. Hudson Trevor male 0.92 1 2 113781 151.55 C22 S
307 307 1 1 Fleming, Miss. Margaret female . 0 0 17421 110.8833   C
308 308 1 1 Penasco y Castellana, Mrs. Victor de Satode (Maria Josefa female 17 1 0 PC 17758 108.9 C65 C
309 309 0 2 Abelson, Mr. Samuel male 30 1 0 P/PP 3381 24   C
310 310 1 1 Francatelli, Miss. Laura Mabel female 30 0 0 PC 17485 56.9292 E36 C
311 311 1 1 Hays, Miss. Margaret Bechstein female 24 0 0 11767 83.1583 C54 C
312 312 1 1 Ryerson, Miss. Emily Borie female 18 2 2 PC 17608 262.375 B57 C
313 313 0 2 Lahtinen, Mrs. William (Anna Sylfven) female 26 1 1 250651 26   S
314 314 0 3 Hendekovic, Mr. Ignjac male 28 0 0 349243 7.8958   S
315 315 0 2 Hart, Mr. Benjamin male 43 1 1 F.C.C. 13529 26.25   S
316 316 1 3 Nilsson, Miss. Helmina Josefina female 26 0 0 347470 7.8542   S
317 317 1 2 Kantor, Mrs. Sinai (Miriam Sternin) female 24 1 0 244367 26   S
318 318 0 2 Moraweck, Dr. Ernest male 54 0 0 29011 14   S
319 319 1 1 Wick, Miss. Mary Natalie female 31 0 2 36928 164.8667 C7 S
320 320 1 1 Spedden, Mrs. Frederic Oakley (Margaretta Corning Stone) female 40 1 1 16966 134.5 E34 C
321 321 0 3 Dennis, Mr. Samuel male 22 0 0 A/5 21172 7.25   S
322 322 0 3 Danoff, Mr. Yoto male 27 0 0 349219 7.8958   S
323 323 1 2 Slayter, Miss. Hilda Mary female 30 0 0 234818 12.35   Q
324 324 1 2 Caldwell, Mrs. Albert Francis (Sylvia Mae Harbaugh) female 22 1 1 248738 29   S
325 325 0 3 Sage, Mr. George John Jr male . 8 2 CA. 2343 69.55   S
326 326 1 1 Young, Miss. Marie Grice female 36 0 0 PC 17760 135.6333 C32 C
327 327 0 3 Nysveen, Mr. Johan Hansen male 61 0 0 345364 6.2375   S
328 328 1 2 Ball, Mrs. (Ada E Hall) female 36 0 0 28551 13 D S
329 329 1 3 Goldsmith, Mrs. Frank John (Emily Alice Brown) female 31 1 1 363291 20.525   S
330 330 1 1 Hippach, Miss. Jean Gertrude female 16 0 1 111361 57.9792 B18 C
331 331 1 3 McCoy, Miss. Agnes female . 2 0 367226 23.25   Q
332 332 0 1 Partner, Mr. Austen male 45.5 0 0 113043 28.5 C124 S
333 333 0 1 Graham, Mr. George Edward male 38 0 1 PC 17582 153.4625 C91 S
334 334 0 3 Vander Planke, Mr. Leo Edmondus male 16 2 0 345764 18   S
335 335 1 1 Frauenthal, Mrs. Henry William (Clara Heinsheimer) female . 1 0 PC 17611 133.65   S
336 336 0 3 Denkoff, Mr. Mitto male . 0 0 349225 7.8958   S
337 337 0 1 Pears, Mr. Thomas Clinton male 29 1 0 113776 66.6 C2 S
338 338 1 1 Burns, Miss. Elizabeth Margaret female 41 0 0 16966 134.5 E40 C
339 339 1 3 Dahl, Mr. Karl Edwart male 45 0 0 7598 8.05   S
340 340 0 1 Blackwell, Mr. Stephen Weart male 45 0 0 113784 35.5 T S
341 341 1 2 Navratil, Master. Edmond Roger male 2 1 1 230080 26 F2 S
342 342 1 1 Fortune, Miss. Alice Elizabeth female 24 3 2 19950 263 C23 S
343 343 0 2 Collander, Mr. Erik Gustaf male 28 0 0 248740 13   S
344 344 0 2 Sedgwick, Mr. Charles Frederick Waddington male 25 0 0 244361 13   S
345 345 0 2 Fox, Mr. Stanley Hubert male 36 0 0 229236 13   S
346 346 1 2 Brown, Miss. Amelia "Mildred" female 24 0 0 248733 13 F33 S
347 347 1 2 Smith, Miss. Marion Elsie female 40 0 0 31418 13   S
348 348 1 3 Davison, Mrs. Thomas Henry (Mary E Finck) female . 1 0 386525 16.1   S
349 349 1 3 Coutts, Master. William Loch "William" male 3 1 1 C.A. 37671 15.9   S
350 350 0 3 Dimic, Mr. Jovan male 42 0 0 315088 8.6625   S
351 351 0 3 Odahl, Mr. Nils Martin male 23 0 0 7267 9.225   S
352 352 0 1 Williams-Lambert, Mr. Fletcher Fellows male . 0 0 113510 35 C128 S
353 353 0 3 Elias, Mr. Tannous male 15 1 1 2695 7.2292   C
354 354 0 3 Arnold-Franchi, Mr. Josef male 25 1 0 349237 17.8   S
355 355 0 3 Yousif, Mr. Wazli male . 0 0 2647 7.225   C
356 356 0 3 Vanden Steen, Mr. Leo Peter male 28 0 0 345783 9.5   S
357 357 1 1 Bowerman, Miss. Elsie Edith female 22 0 1 113505 55 E33 S
358 358 0 2 Funk, Miss. Annie Clemmer female 38 0 0 237671 13   S
359 359 1 3 McGovern, Miss. Mary female . 0 0 330931 7.8792   Q
360 360 1 3 Mockler, Miss. Helen Mary "Ellie" female . 0 0 330980 7.8792   Q
361 361 0 3 Skoog, Mr. Wilhelm male 40 1 4 347088 27.9   S
362 362 0 2 del Carlo, Mr. Sebastiano male 29 1 0 SC/PARIS 2167 27.7208   C
363 363 0 3 Barbara, Mrs. (Catherine David) female 45 0 1 2691 14.4542   C
364 364 0 3 Asim, Mr. Adola male 35 0 0 SOTON/O.Q. 31013 7.05   S
365 365 0 3 O'Brien, Mr. Thomas male . 1 0 370365 15.5   Q
366 366 0 3 Adahl, Mr. Mauritz Nils Martin male 30 0 0 C 7076 7.25   S
367 367 1 1 Warren, Mrs. Frank Manley (Anna Sophia Atkinson) female 60 1 0 110813 75.25 D37 C
368 368 1 3 Moussa, Mrs. (Mantoura Boulos) female . 0 0 2626 7.2292   C
369 369 1 3 Jermyn, Miss. Annie female . 0 0 14313 7.75   Q
370 370 1 1 Aubart, Mme. Leontine Pauline female 24 0 0 PC 17477 69.3 B35 C
371 371 1 1 Harder, Mr. George Achilles male 25 1 0 11765 55.4417 E50 C
372 372 0 3 Wiklund, Mr. Jakob Alfred male 18 1 0 3101267 6.4958   S
373 373 0 3 Beavan, Mr. William Thomas male 19 0 0 323951 8.05   S
374 374 0 1 Ringhini, Mr. Sante male 22 0 0 PC 17760 135.6333   C
375 375 0 3 Palsson, Miss. Stina Viola female 3 3 1 349909 21.075   S
376 376 1 1 Meyer, Mrs. Edgar Joseph (Leila Saks) female . 1 0 PC 17604 82.1708   C
377 377 1 3 Landergren, Miss. Aurora Adelia female 22 0 0 C 7077 7.25   S
378 378 0 1 Widener, Mr. Harry Elkins male 27 0 2 113503 211.5 C82 C
379 379 0 3 Betros, Mr. Tannous male 20 0 0 2648 4.0125   C
380 380 0 3 Gustafsson, Mr. Karl Gideon male 19 0 0 347069 7.775   S
381 381 1 1 Bidois, Miss. Rosalie female 42 0 0 PC 17757 227.525   C
382 382 1 3 Nakid, Miss. Maria ("Mary") female 1 0 2 2653 15.7417   C
383 383 0 3 Tikkanen, Mr. Juho male 32 0 0 STON/O 2. 310129 7.925   S
384 384 1 1 Holverson, Mrs. Alexander Oskar (Mary Aline Towner) female 35 1 0 113789 52   S
385 385 0 3 Plotcharsky, Mr. Vasil male . 0 0 349227 7.8958   S
386 386 0 2 Davies, Mr. Charles Henry male 18 0 0 S.O.C. 14879 73.5   S
387 387 0 3 Goodwin, Master. Sidney Leonard male 1 5 2 CA 2144 46.9   S
388 388 1 2 Buss, Miss. Kate female 36 0 0 27849 13   S
389 389 0 3 Sadlier, Mr. Matthew male . 0 0 367655 7.7292   Q
390 390 1 2 Lehmann, Miss. Bertha female 17 0 0 SC 1748 12   C
391 391 1 1 Carter, Mr. William Ernest male 36 1 2 113760 120 B96 S
392 392 1 3 Jansson, Mr. Carl Olof male 21 0 0 350034 7.7958   S
393 393 0 3 Gustafsson, Mr. Johan Birger male 28 2 0 3101277 7.925   S
394 394 1 1 Newell, Miss. Marjorie female 23 1 0 35273 113.275 D36 C
395 395 1 3 Sandstrom, Mrs. Hjalmar (Agnes Charlotta Bengtsson) female 24 0 2 PP 9549 16.7 G6 S
396 396 0 3 Johansson, Mr. Erik male 22 0 0 350052 7.7958   S
397 397 0 3 Olsson, Miss. Elina female 31 0 0 350407 7.8542   S
398 398 0 2 McKane, Mr. Peter David male 46 0 0 28403 26   S
399 399 0 2 Pain, Dr. Alfred male 23 0 0 244278 10.5   S
400 400 1 2 Trout, Mrs. William H (Jessie L) female 28 0 0 240929 12.65   S
401 401 1 3 Niskanen, Mr. Juha male 39 0 0 STON/O 2. 310128 7.925   S
402 402 0 3 Adams, Mr. John male 26 0 0 341826 8.05   S
403 403 0 3 Jussila, Miss. Mari Aina female 21 1 0 4137 9.825   S
404 404 0 3 Hakkarainen, Mr. Pekka Pietari male 28 1 0 STON/O2. 3101279 15.85   S
405 405 0 3 Oreskovic, Miss. Marija female 20 0 0 315096 8.6625   S
406 406 0 2 Gale, Mr. Shadrach male 34 1 0 28664 21   S
407 407 0 3 Widegren, Mr. Carl/Charles Peter male 51 0 0 347064 7.75   S
408 408 1 2 Richards, Master. William Rowe male 3 1 1 29106 18.75   S
409 409 0 3 Birkeland, Mr. Hans Martin Monsen male 21 0 0 312992 7.775   S
410 410 0 3 Lefebre, Miss. Ida female . 3 1 4133 25.4667   S
411 411 0 3 Sdycoff, Mr. Todor male . 0 0 349222 7.8958   S
412 412 0 3 Hart, Mr. Henry male . 0 0 394140 6.8583   Q
413 413 1 1 Minahan, Miss. Daisy E female 33 1 0 19928 90 C78 Q
414 414 0 2 Cunningham, Mr. Alfred Fleming male . 0 0 239853 0   S
415 415 1 3 Sundman, Mr. Johan Julian male 44 0 0 STON/O 2. 310126 7.925   S
416 416 0 3 Meek, Mrs. Thomas (Annie Louise Rowley) female . 0 0 343095 8.05   S
417 417 1 2 Drew, Mrs. James Vivian (Lulu Thorne Christian) female 34 1 1 28220 32.5   S
418 418 1 2 Silven, Miss. Lyyli Karoliina female 18 0 2 250652 13   S
419 419 0 2 Matthews, Mr. William John male 30 0 0 28228 13   S
420 420 0 3 Van Impe, Miss. Catharina female 10 0 2 345773 24.15   S
421 421 0 3 Gheorgheff, Mr. Stanio male . 0 0 349254 7.8958   C
422 422 0 3 Charters, Mr. David male 21 0 0 A/5. 13032 7.7333   Q
423 423 0 3 Zimmerman, Mr. Leo male 29 0 0 315082 7.875   S
424 424 0 3 Danbom, Mrs. Ernst Gilbert (Anna Sigrid Maria Brogren) female 28 1 1 347080 14.4   S
425 425 0 3 Rosblom, Mr. Viktor Richard male 18 1 1 370129 20.2125   S
426 426 0 3 Wiseman, Mr. Phillippe male . 0 0 A/4. 34244 7.25   S
427 427 1 2 Clarke, Mrs. Charles V (Ada Maria Winfield) female 28 1 0 2003 26   S
428 428 1 2 Phillips, Miss. Kate Florence ("Mrs Kate Louise Phillips female 19 0 0 250655 26   S
429 429 0 3 Flynn, Mr. James male . 0 0 364851 7.75   Q
430 430 1 3 Pickard, Mr. Berk (Berk Trembisky) male 32 0 0 SOTON/O.Q. 39207 8.05 E10 S
431 431 1 1 Bjornstrom-Steffansson, Mr. Mauritz Hakan male 28 0 0 110564 26.55 C52 S
432 432 1 3 Thorneycroft, Mrs. Percival (Florence Kate White) female . 1 0 376564 16.1   S
433 433 1 2 Louch, Mrs. Charles Alexander (Alice Adelaide Slow) female 42 1 0 SC/AH 3085 26   S
434 434 0 3 Kallio, Mr. Nikolai Erland male 17 0 0 STON/O 2. 310127 7.125   S
435 435 0 1 Silvey, Mr. William Baird male 50 1 0 13507 55.9 E44 S
436 436 1 1 Carter, Miss. Lucile Polk female 14 1 2 113760 120 B96 S
437 437 0 3 Ford, Miss. Doolina Margaret "Daisy" female 21 2 2 W./C. 6608 34.375   S
438 438 1 2 Richards, Mrs. Sidney (Emily Hocking) female 24 2 3 29106 18.75   S
439 439 0 1 Fortune, Mr. Mark male 64 1 4 19950 263 C23 S
440 440 0 2 Kvillner, Mr. Johan Henrik Johannesson male 31 0 0 C.A. 18723 10.5   S
441 441 1 2 Hart, Mrs. Benjamin (Esther Ada Bloomfield) female 45 1 1 F.C.C. 13529 26.25   S
442 442 0 3 Hampe, Mr. Leon male 20 0 0 345769 9.5   S
443 443 0 3 Petterson, Mr. Johan Emil male 25 1 0 347076 7.775   S
444 444 1 2 Reynaldo, Ms. Encarnacion female 28 0 0 230434 13   S
445 445 1 3 Johannesen-Bratthammer, Mr. Bernt male . 0 0 65306 8.1125   S
446 446 1 1 Dodge, Master. Washington male 4 0 2 33638 81.8583 A34 S
447 447 1 2 Mellinger, Miss. Madeleine Violet female 13 0 1 250644 19.5   S
448 448 1 1 Seward, Mr. Frederic Kimber male 34 0 0 113794 26.55   S
449 449 1 3 Baclini, Miss. Marie Catherine female 5 2 1 2666 19.2583   C
450 450 1 1 Peuchen, Major. Arthur Godfrey male 52 0 0 113786 30.5 C104 S
451 451 0 2 West, Mr. Edwy Arthur male 36 1 2 C.A. 34651 27.75   S
452 452 0 3 Hagland, Mr. Ingvald Olai Olsen male . 1 0 65303 19.9667   S
453 453 0 1 Foreman, Mr. Benjamin Laventall male 30 0 0 113051 27.75 C111 C
454 454 1 1 Goldenberg, Mr. Samuel L male 49 1 0 17453 89.1042 C92 C
455 455 0 3 Peduzzi, Mr. Joseph male . 0 0 A/5 2817 8.05   S
456 456 1 3 Jalsevac, Mr. Ivan male 29 0 0 349240 7.8958   C
457 457 0 1 Millet, Mr. Francis Davis male 65 0 0 13509 26.55 E38 S
458 458 1 1 Kenyon, Mrs. Frederick R (Marion) female . 1 0 17464 51.8625 D21 S
459 459 1 2 Toomey, Miss. Ellen female 50 0 0 F.C.C. 13531 10.5   S
460 460 0 3 O'Connor, Mr. Maurice male . 0 0 371060 7.75   Q
461 461 1 1 Anderson, Mr. Harry male 48 0 0 19952 26.55 E12 S
462 462 0 3 Morley, Mr. William male 34 0 0 364506 8.05   S
463 463 0 1 Gee, Mr. Arthur H male 47 0 0 111320 38.5 E63 S
464 464 0 2 Milling, Mr. Jacob Christian male 48 0 0 234360 13   S
465 465 0 3 Maisner, Mr. Simon male . 0 0 A/S 2816 8.05   S
466 466 0 3 Goncalves, Mr. Manuel Estanslas male 38 0 0 SOTON/O.Q. 31013 7.05   S
467 467 0 2 Campbell, Mr. William male . 0 0 239853 0   S
468 468 0 1 Smart, Mr. John Montgomery male 56 0 0 113792 26.55   S
469 469 0 3 Scanlan, Mr. James male . 0 0 36209 7.725   Q
470 470 1 3 Baclini, Miss. Helene Barbara female 0.75 2 1 2666 19.2583   C
471 471 0 3 Keefe, Mr. Arthur male . 0 0 323592 7.25   S
472 472 0 3 Cacic, Mr. Luka male 38 0 0 315089 8.6625   S
473 473 1 2 West, Mrs. Edwy Arthur (Ada Mary Worth) female 33 1 2 C.A. 34651 27.75   S
474 474 1 2 Jerwan, Mrs. Amin S (Marie Marthe Thuillard) female 23 0 0 SC/AH Basle 541 13.7917 D C
475 475 0 3 Strandberg, Miss. Ida Sofia female 22 0 0 7553 9.8375   S
476 476 0 1 Clifford, Mr. George Quincy male . 0 0 110465 52 A14 S
477 477 0 2 Renouf, Mr. Peter Henry male 34 1 0 31027 21   S
478 478 0 3 Braund, Mr. Lewis Richard male 29 1 0 3460 7.0458   S
479 479 0 3 Karlsson, Mr. Nils August male 22 0 0 350060 7.5208   S
480 480 1 3 Hirvonen, Miss. Hildur E female 2 0 1 3101298 12.2875   S
481 481 0 3 Goodwin, Master. Harold Victor male 9 5 2 CA 2144 46.9   S
482 482 0 2 Frost, Mr. Anthony Wood "Archie" male . 0 0 239854 0   S
483 483 0 3 Rouse, Mr. Richard Henry male 50 0 0 A/5 3594 8.05   S
484 484 1 3 Turkula, Mrs. (Hedwig) female 63 0 0 4134 9.5875   S
485 485 1 1 Bishop, Mr. Dickinson H male 25 1 0 11967 91.0792 B49 C
486 486 0 3 Lefebre, Miss. Jeannie female . 3 1 4133 25.4667   S
487 487 1 1 Hoyt, Mrs. Frederick Maxfield (Jane Anne Forby) female 35 1 0 19943 90 C93 S
488 488 0 1 Kent, Mr. Edward Austin male 58 0 0 11771 29.7 B37 C
489 489 0 3 Somerton, Mr. Francis William male 30 0 0 A.5. 18509 8.05   S
490 490 1 3 Coutts, Master. Eden Leslie "Neville" male 9 1 1 C.A. 37671 15.9   S
491 491 0 3 Hagland, Mr. Konrad Mathias Reiersen male . 1 0 65304 19.9667   S
492 492 0 3 Windelov, Mr. Einar male 21 0 0 SOTON/OQ 3101317 7.25   S
493 493 0 1 Molson, Mr. Harry Markland male 55 0 0 113787 30.5 C30 S
494 494 0 1 Artagaveytia, Mr. Ramon male 71 0 0 PC 17609 49.5042   C
495 495 0 3 Stanley, Mr. Edward Roland male 21 0 0 A/4 45380 8.05   S
496 496 0 3 Yousseff, Mr. Gerious male . 0 0 2627 14.4583   C
497 497 1 1 Eustis, Miss. Elizabeth Mussey female 54 1 0 36947 78.2667 D20 C
498 498 0 3 Shellard, Mr. Frederick William male . 0 0 C.A. 6212 15.1   S
499 499 0 1 Allison, Mrs. Hudson J C (Bessie Waldo Daniels) female 25 1 2 113781 151.55 C22 S
500 500 0 3 Svensson, Mr. Olof male 24 0 0 350035 7.7958   S
501 501 0 3 Calic, Mr. Petar male 17 0 0 315086 8.6625   S
502 502 0 3 Canavan, Miss. Mary female 21 0 0 364846 7.75   Q
503 503 0 3 O'Sullivan, Miss. Bridget Mary female . 0 0 330909 7.6292   Q
504 504 0 3 Laitinen, Miss. Kristina Sofia female 37 0 0 4135 9.5875   S
505 505 1 1 Maioni, Miss. Roberta female 16 0 0 110152 86.5 B79 S
506 506 0 1 Penasco y Castellana, Mr. Victor de Satode male 18 1 0 PC 17758 108.9 C65 C
507 507 1 2 Quick, Mrs. Frederick Charles (Jane Richards) female 33 0 2 26360 26   S
508 508 1 1 Bradley, Mr. George ("George Arthur Brayton") male . 0 0 111427 26.55   S
509 509 0 3 Olsen, Mr. Henry Margido male 28 0 0 C 4001 22.525   S
510 510 1 3 Lang, Mr. Fang male 26 0 0 1601 56.4958   S
511 511 1 3 Daly, Mr. Eugene Patrick male 29 0 0 382651 7.75   Q
512 512 0 3 Webber, Mr. James male . 0 0 SOTON/OQ 3101316 8.05   S
513 513 1 1 McGough, Mr. James Robert male 36 0 0 PC 17473 26.2875 E25 S
514 514 1 1 Rothschild, Mrs. Martin (Elizabeth L. Barrett) female 54 1 0 PC 17603 59.4   C
515 515 0 3 Coleff, Mr. Satio male 24 0 0 349209 7.4958   S
516 516 0 1 Walker, Mr. William Anderson male 47 0 0 36967 34.0208 D46 S
517 517 1 2 Lemore, Mrs. (Amelia Milley) female 34 0 0 C.A. 34260 10.5 F33 S
518 518 0 3 Ryan, Mr. Patrick male . 0 0 371110 24.15   Q
519 519 1 2 Angle, Mrs. William A (Florence "Mary" Agnes Hughes) female 36 1 0 226875 26   S
520 520 0 3 Pavlovic, Mr. Stefo male 32 0 0 349242 7.8958   S
521 521 1 1 Perreault, Miss. Anne female 30 0 0 12749 93.5 B73 S
522 522 0 3 Vovk, Mr. Janko male 22 0 0 349252 7.8958   S
523 523 0 3 Lahoud, Mr. Sarkis male . 0 0 2624 7.225   C
524 524 1 1 Hippach, Mrs. Louis Albert (Ida Sophia Fischer) female 44 0 1 111361 57.9792 B18 C
525 525 0 3 Kassem, Mr. Fared male . 0 0 2700 7.2292   C
526 526 0 3 Farrell, Mr. James male 40.5 0 0 367232 7.75   Q
527 527 1 2 Ridsdale, Miss. Lucy female 50 0 0 W./C. 14258 10.5   S
528 528 0 1 Farthing, Mr. John male . 0 0 PC 17483 221.7792 C95 S
529 529 0 3 Salonen, Mr. Johan Werner male 39 0 0 3101296 7.925   S
530 530 0 2 Hocking, Mr. Richard George male 23 2 1 29104 11.5   S
531 531 1 2 Quick, Miss. Phyllis May female 2 1 1 26360 26   S
532 532 0 3 Toufik, Mr. Nakli male . 0 0 2641 7.2292   C
533 533 0 3 Elias, Mr. Joseph Jr male 17 1 1 2690 7.2292   C
534 534 1 3 Peter, Mrs. Catherine (Catherine Rizk) female . 0 2 2668 22.3583   C
535 535 0 3 Cacic, Miss. Marija female 30 0 0 315084 8.6625   S
536 536 1 2 Hart, Miss. Eva Miriam female 7 0 2 F.C.C. 13529 26.25   S
537 537 0 1 Butt, Major. Archibald Willingham male 45 0 0 113050 26.55 B38 S
538 538 1 1 LeRoy, Miss. Bertha female 30 0 0 PC 17761 106.425   C
539 539 0 3 Risien, Mr. Samuel Beard male . 0 0 364498 14.5   S
540 540 1 1 Frolicher, Miss. Hedwig Margaritha female 22 0 2 13568 49.5 B39 C
541 541 1 1 Crosby, Miss. Harriet R female 36 0 2 WE/P 5735 71 B22 S
542 542 0 3 Andersson, Miss. Ingeborg Constanzia female 9 4 2 347082 31.275   S
543 543 0 3 Andersson, Miss. Sigrid Elisabeth female 11 4 2 347082 31.275   S
544 544 1 2 Beane, Mr. Edward male 32 1 0 2908 26   S
545 545 0 1 Douglas, Mr. Walter Donald male 50 1 0 PC 17761 106.425 C86 C
546 546 0 1 Nicholson, Mr. Arthur Ernest male 64 0 0 693 26   S
547 547 1 2 Beane, Mrs. Edward (Ethel Clarke) female 19 1 0 2908 26   S
548 548 1 2 Padro y Manent, Mr. Julian male . 0 0 SC/PARIS 2146 13.8625   C
549 549 0 3 Goldsmith, Mr. Frank John male 33 1 1 363291 20.525   S
550 550 1 2 Davies, Master. John Morgan Jr male 8 1 1 C.A. 33112 36.75   S
551 551 1 1 Thayer, Mr. John Borland Jr male 17 0 2 17421 110.8833 C70 C
552 552 0 2 Sharp, Mr. Percival James R male 27 0 0 244358 26   S
553 553 0 3 O'Brien, Mr. Timothy male . 0 0 330979 7.8292   Q
554 554 1 3 Leeni, Mr. Fahim ("Philip Zenni") male 22 0 0 2620 7.225   C
555 555 1 3 Ohman, Miss. Velin female 22 0 0 347085 7.775   S
556 556 0 1 Wright, Mr. George male 62 0 0 113807 26.55   S
557 557 1 1 Duff Gordon, Lady. (Lucille Christiana Sutherland) ("Mrs female 48 1 0 11755 39.6 A16 C
558 558 0 1 Robbins, Mr. Victor male . 0 0 PC 17757 227.525   C
559 559 1 1 Taussig, Mrs. Emil (Tillie Mandelbaum) female 39 1 1 110413 79.65 E67 S
560 560 1 3 de Messemaeker, Mrs. Guillaume Joseph (Emma) female 36 1 0 345572 17.4   S
561 561 0 3 Morrow, Mr. Thomas Rowan male . 0 0 372622 7.75   Q
562 562 0 3 Sivic, Mr. Husein male 40 0 0 349251 7.8958   S
563 563 0 2 Norman, Mr. Robert Douglas male 28 0 0 218629 13.5   S
564 564 0 3 Simmons, Mr. John male . 0 0 SOTON/OQ 392082 8.05   S
565 565 0 3 Meanwell, Miss. (Marion Ogden) female . 0 0 SOTON/O.Q. 39208 8.05   S
566 566 0 3 Davies, Mr. Alfred J male 24 2 0 A/4 48871 24.15   S
567 567 0 3 Stoytcheff, Mr. Ilia male 19 0 0 349205 7.8958   S
568 568 0 3 Palsson, Mrs. Nils (Alma Cornelia Berglund) female 29 0 4 349909 21.075   S
569 569 0 3 Doharr, Mr. Tannous male . 0 0 2686 7.2292   C
570 570 1 3 Jonsson, Mr. Carl male 32 0 0 350417 7.8542   S
571 571 1 2 Harris, Mr. George male 62 0 0 S.W./PP 752 10.5   S
572 572 1 1 Appleton, Mrs. Edward Dale (Charlotte Lamson) female 53 2 0 11769 51.4792 C101 S
573 573 1 1 Flynn, Mr. John Irwin ("Irving") male 36 0 0 PC 17474 26.3875 E25 S
574 574 1 3 Kelly, Miss. Mary female . 0 0 14312 7.75   Q
575 575 0 3 Rush, Mr. Alfred George John male 16 0 0 A/4. 20589 8.05   S
576 576 0 3 Patchett, Mr. George male 19 0 0 358585 14.5   S
577 577 1 2 Garside, Miss. Ethel female 34 0 0 243880 13   S
578 578 1 1 Silvey, Mrs. William Baird (Alice Munger) female 39 1 0 13507 55.9 E44 S
579 579 0 3 Caram, Mrs. Joseph (Maria Elias) female . 1 0 2689 14.4583   C
580 580 1 3 Jussila, Mr. Eiriik male 32 0 0 STON/O 2. 310128 7.925   S
581 581 1 2 Christy, Miss. Julie Rachel female 25 1 1 237789 30   S
582 582 1 1 Thayer, Mrs. John Borland (Marian Longstreth Morris) female 39 1 1 17421 110.8833 C68 C
583 583 0 2 Downton, Mr. William James male 54 0 0 28403 26   S
584 584 0 1 Ross, Mr. John Hugo male 36 0 0 13049 40.125 A10 C
585 585 0 3 Paulner, Mr. Uscher male . 0 0 3411 8.7125   C
586 586 1 1 Taussig, Miss. Ruth female 18 0 2 110413 79.65 E68 S
587 587 0 2 Jarvis, Mr. John Denzil male 47 0 0 237565 15   S
588 588 1 1 Frolicher-Stehli, Mr. Maxmillian male 60 1 1 13567 79.2 B41 C
589 589 0 3 Gilinski, Mr. Eliezer male 22 0 0 14973 8.05   S
590 590 0 3 Murdlin, Mr. Joseph male . 0 0 A./5. 3235 8.05   S
591 591 0 3 Rintamaki, Mr. Matti male 35 0 0 STON/O 2. 310127 7.125   S
592 592 1 1 Stephenson, Mrs. Walter Bertram (Martha Eustis) female 52 1 0 36947 78.2667 D20 C
593 593 0 3 Elsbury, Mr. William James male 47 0 0 A/5 3902 7.25   S
594 594 0 3 Bourke, Miss. Mary female . 0 2 364848 7.75   Q
595 595 0 2 Chapman, Mr. John Henry male 37 1 0 SC/AH 29037 26   S
596 596 0 3 Van Impe, Mr. Jean Baptiste male 36 1 1 345773 24.15   S
597 597 1 2 Leitch, Miss. Jessie Wills female . 0 0 248727 33   S
598 598 0 3 Johnson, Mr. Alfred male 49 0 0 LINE 0   S
599 599 0 3 Boulos, Mr. Hanna male . 0 0 2664 7.225   C
600 600 1 1 Duff Gordon, Sir. Cosmo Edmund ("Mr Morgan") male 49 1 0 PC 17485 56.9292 A20 C
601 601 1 2 Jacobsohn, Mrs. Sidney Samuel (Amy Frances Christy) female 24 2 1 243847 27   S
602 602 0 3 Slabenoff, Mr. Petco male . 0 0 349214 7.8958   S
603 603 0 1 Harrington, Mr. Charles H male . 0 0 113796 42.4   S
604 604 0 3 Torber, Mr. Ernst William male 44 0 0 364511 8.05   S
605 605 1 1 Homer, Mr. Harry ("Mr E Haven") male 35 0 0 111426 26.55   C
606 606 0 3 Lindell, Mr. Edvard Bengtsson male 36 1 0 349910 15.55   S
607 607 0 3 Karaic, Mr. Milan male 30 0 0 349246 7.8958   S
608 608 1 1 Daniel, Mr. Robert Williams male 27 0 0 113804 30.5   S
609 609 1 2 Laroche, Mrs. Joseph (Juliette Marie Louise Lafargue) female 22 1 2 SC/Paris 2123 41.5792   C
610 610 1 1 Shutes, Miss. Elizabeth W female 40 0 0 PC 17582 153.4625 C125 S
611 611 0 3 Andersson, Mrs. Anders Johan (Alfrida Konstantia Brogren) female 39 1 5 347082 31.275   S
612 612 0 3 Jardin, Mr. Jose Neto male . 0 0 SOTON/O.Q. 31013 7.05   S
613 613 1 3 Murphy, Miss. Margaret Jane female . 1 0 367230 15.5   Q
614 614 0 3 Horgan, Mr. John male . 0 0 370377 7.75   Q
615 615 0 3 Brocklebank, Mr. William Alfred male 35 0 0 364512 8.05   S
616 616 1 2 Herman, Miss. Alice female 24 1 2 220845 65   S
617 617 0 3 Danbom, Mr. Ernst Gilbert male 34 1 1 347080 14.4   S
618 618 0 3 Lobb, Mrs. William Arthur (Cordelia K Stanlick) female 26 1 0 A/5. 3336 16.1   S
619 619 1 2 Becker, Miss. Marion Louise female 4 2 1 230136 39 F4 S
620 620 0 2 Gavey, Mr. Lawrence male 26 0 0 31028 10.5   S
621 621 0 3 Yasbeck, Mr. Antoni male 27 1 0 2659 14.4542   C
622 622 1 1 Kimball, Mr. Edwin Nelson Jr male 42 1 0 11753 52.5542 D19 S
623 623 1 3 Nakid, Mr. Sahid male 20 1 1 2653 15.7417   C
624 624 0 3 Hansen, Mr. Henry Damsgaard male 21 0 0 350029 7.8542   S
625 625 0 3 Bowen, Mr. David John "Dai" male 21 0 0 54636 16.1   S
626 626 0 1 Sutton, Mr. Frederick male 61 0 0 36963 32.3208 D50 S
627 627 0 2 Kirkland, Rev. Charles Leonard male 57 0 0 219533 12.35   Q
628 628 1 1 Longley, Miss. Gretchen Fiske female 21 0 0 13502 77.9583 D9 S
629 629 0 3 Bostandyeff, Mr. Guentcho male 26 0 0 349224 7.8958   S
630 630 0 3 O'Connell, Mr. Patrick D male . 0 0 334912 7.7333   Q
631 631 1 1 Barkworth, Mr. Algernon Henry Wilson male 80 0 0 27042 30 A23 S
632 632 0 3 Lundahl, Mr. Johan Svensson male 51 0 0 347743 7.0542   S
633 633 1 1 Stahelin-Maeglin, Dr. Max male 32 0 0 13214 30.5 B50 C
634 634 0 1 Parr, Mr. William Henry Marsh male . 0 0 112052 0   S
635 635 0 3 Skoog, Miss. Mabel female 9 3 2 347088 27.9   S
636 636 1 2 Davis, Miss. Mary female 28 0 0 237668 13   S
637 637 0 3 Leinonen, Mr. Antti Gustaf male 32 0 0 STON/O 2. 310129 7.925   S
638 638 0 2 Collyer, Mr. Harvey male 31 1 1 C.A. 31921 26.25   S
639 639 0 3 Panula, Mrs. Juha (Maria Emilia Ojala) female 41 0 5 3101295 39.6875   S
640 640 0 3 Thorneycroft, Mr. Percival male . 1 0 376564 16.1   S
641 641 0 3 Jensen, Mr. Hans Peder male 20 0 0 350050 7.8542   S
642 642 1 1 Sagesser, Mlle. Emma female 24 0 0 PC 17477 69.3 B35 C
643 643 0 3 Skoog, Miss. Margit Elizabeth female 2 3 2 347088 27.9   S
644 644 1 3 Foo, Mr. Choong male . 0 0 1601 56.4958   S
645 645 1 3 Baclini, Miss. Eugenie female 0.75 2 1 2666 19.2583   C
646 646 1 1 Harper, Mr. Henry Sleeper male 48 1 0 PC 17572 76.7292 D33 C
647 647 0 3 Cor, Mr. Liudevit male 19 0 0 349231 7.8958   S
648 648 1 1 Simonius-Blumer, Col. Oberst Alfons male 56 0 0 13213 35.5 A26 C
649 649 0 3 Willey, Mr. Edward male . 0 0 S.O./P.P. 751 7.55   S
650 650 1 3 Stanley, Miss. Amy Zillah Elsie female 23 0 0 CA. 2314 7.55   S
651 651 0 3 Mitkoff, Mr. Mito male . 0 0 349221 7.8958   S
652 652 1 2 Doling, Miss. Elsie female 18 0 1 231919 23   S
653 653 0 3 Kalvik, Mr. Johannes Halvorsen male 21 0 0 8475 8.4333   S
654 654 1 3 O'Leary, Miss. Hanora "Norah" female . 0 0 330919 7.8292   Q
655 655 0 3 Hegarty, Miss. Hanora "Nora" female 18 0 0 365226 6.75   Q
656 656 0 2 Hickman, Mr. Leonard Mark male 24 2 0 S.O.C. 14879 73.5   S
657 657 0 3 Radeff, Mr. Alexander male . 0 0 349223 7.8958   S
658 658 0 3 Bourke, Mrs. John (Catherine) female 32 1 1 364849 15.5   Q
659 659 0 2 Eitemiller, Mr. George Floyd male 23 0 0 29751 13   S
660 660 0 1 Newell, Mr. Arthur Webster male 58 0 2 35273 113.275 D48 C
661 661 1 1 Frauenthal, Dr. Henry William male 50 2 0 PC 17611 133.65   S
662 662 0 3 Badt, Mr. Mohamed male 40 0 0 2623 7.225   C
663 663 0 1 Colley, Mr. Edward Pomeroy male 47 0 0 5727 25.5875 E58 S
664 664 0 3 Coleff, Mr. Peju male 36 0 0 349210 7.4958   S
665 665 1 3 Lindqvist, Mr. Eino William male 20 1 0 STON/O 2. 310128 7.925   S
666 666 0 2 Hickman, Mr. Lewis male 32 2 0 S.O.C. 14879 73.5   S
667 667 0 2 Butler, Mr. Reginald Fenton male 25 0 0 234686 13   S
668 668 0 3 Rommetvedt, Mr. Knud Paust male . 0 0 312993 7.775   S
669 669 0 3 Cook, Mr. Jacob male 43 0 0 A/5 3536 8.05   S
670 670 1 1 Taylor, Mrs. Elmer Zebley (Juliet Cummins Wright) female . 1 0 19996 52 C126 S
671 671 1 2 Brown, Mrs. Thomas William Solomon (Elizabeth Catherine F female 40 1 1 29750 39   S
672 672 0 1 Davidson, Mr. Thornton male 31 1 0 F.C. 12750 52 B71 S
673 673 0 2 Mitchell, Mr. Henry Michael male 70 0 0 C.A. 24580 10.5   S
674 674 1 2 Wilhelms, Mr. Charles male 31 0 0 244270 13   S
675 675 0 2 Watson, Mr. Ennis Hastings male . 0 0 239856 0   S
676 676 0 3 Edvardsson, Mr. Gustaf Hjalmar male 18 0 0 349912 7.775   S
677 677 0 3 Sawyer, Mr. Frederick Charles male 24.5 0 0 342826 8.05   S
678 678 1 3 Turja, Miss. Anna Sofia female 18 0 0 4138 9.8417   S
679 679 0 3 Goodwin, Mrs. Frederick (Augusta Tyler) female 43 1 6 CA 2144 46.9   S
680 680 1 1 Cardeza, Mr. Thomas Drake Martinez male 36 0 1 PC 17755 512.3292 B51 C
681 681 0 3 Peters, Miss. Katie female . 0 0 330935 8.1375   Q
682 682 1 1 Hassab, Mr. Hammad male 27 0 0 PC 17572 76.7292 D49 C
683 683 0 3 Olsvigen, Mr. Thor Anderson male 20 0 0 6563 9.225   S
684 684 0 3 Goodwin, Mr. Charles Edward male 14 5 2 CA 2144 46.9   S
685 685 0 2 Brown, Mr. Thomas William Solomon male 60 1 1 29750 39   S
686 686 0 2 Laroche, Mr. Joseph Philippe Lemercier male 25 1 2 SC/Paris 2123 41.5792   C
687 687 0 3 Panula, Mr. Jaako Arnold male 14 4 1 3101295 39.6875   S
688 688 0 3 Dakic, Mr. Branko male 19 0 0 349228 10.1708   S
689 689 0 3 Fischer, Mr. Eberhard Thelander male 18 0 0 350036 7.7958   S
690 690 1 1 Madill, Miss. Georgette Alexandra female 15 0 1 24160 211.3375 B5 S
691 691 1 1 Dick, Mr. Albert Adrian male 31 1 0 17474 57 B20 S
692 692 1 3 Karun, Miss. Manca female 4 0 1 349256 13.4167   C
693 693 1 3 Lam, Mr. Ali male . 0 0 1601 56.4958   S
694 694 0 3 Saad, Mr. Khalil male 25 0 0 2672 7.225   C
695 695 0 1 Weir, Col. John male 60 0 0 113800 26.55   S
696 696 0 2 Chapman, Mr. Charles Henry male 52 0 0 248731 13.5   S
697 697 0 3 Kelly, Mr. James male 44 0 0 363592 8.05   S
698 698 1 3 Mullens, Miss. Katherine "Katie" female . 0 0 35852 7.7333   Q
699 699 0 1 Thayer, Mr. John Borland male 49 1 1 17421 110.8833 C68 C
700 700 0 3 Humblen, Mr. Adolf Mathias Nicolai Olsen male 42 0 0 348121 7.65 F G6 S
701 701 1 1 Astor, Mrs. John Jacob (Madeleine Talmadge Force) female 18 1 0 PC 17757 227.525 C62 C
702 702 1 1 Silverthorne, Mr. Spencer Victor male 35 0 0 PC 17475 26.2875 E24 S
703 703 0 3 Barbara, Miss. Saiide female 18 0 1 2691 14.4542   C
704 704 0 3 Gallagher, Mr. Martin male 25 0 0 36864 7.7417   Q
705 705 0 3 Hansen, Mr. Henrik Juul male 26 1 0 350025 7.8542   S
706 706 0 2 Morley, Mr. Henry Samuel ("Mr Henry Marshall") male 39 0 0 250655 26   S
707 707 1 2 Kelly, Mrs. Florence "Fannie" female 45 0 0 223596 13.5   S
708 708 1 1 Calderhead, Mr. Edward Pennington male 42 0 0 PC 17476 26.2875 E24 S
709 709 1 1 Cleaver, Miss. Alice female 22 0 0 113781 151.55   S
710 710 1 3 Moubarek, Master. Halim Gonios ("William George") male . 1 1 2661 15.2458   C
711 711 1 1 Mayne, Mlle. Berthe Antonine ("Mrs de Villiers") female 24 0 0 PC 17482 49.5042 C90 C
712 712 0 1 Klaber, Mr. Herman male . 0 0 113028 26.55 C124 S
713 713 1 1 Taylor, Mr. Elmer Zebley male 48 1 0 19996 52 C126 S
714 714 0 3 Larsson, Mr. August Viktor male 29 0 0 7545 9.4833   S
715 715 0 2 Greenberg, Mr. Samuel male 52 0 0 250647 13   S
716 716 0 3 Soholt, Mr. Peter Andreas Lauritz Andersen male 19 0 0 348124 7.65 F G7 S
717 717 1 1 Endres, Miss. Caroline Louise female 38 0 0 PC 17757 227.525 C45 C
718 718 1 2 Troutt, Miss. Edwina Celia "Winnie" female 27 0 0 34218 10.5 E101 S
719 719 0 3 McEvoy, Mr. Michael male . 0 0 36568 15.5   Q
720 720 0 3 Johnson, Mr. Malkolm Joackim male 33 0 0 347062 7.775   S
721 721 1 2 Harper, Miss. Annie Jessie "Nina" female 6 0 1 248727 33   S
722 722 0 3 Jensen, Mr. Svend Lauritz male 17 1 0 350048 7.0542   S
723 723 0 2 Gillespie, Mr. William Henry male 34 0 0 12233 13   S
724 724 0 2 Hodges, Mr. Henry Price male 50 0 0 250643 13   S
725 725 1 1 Chambers, Mr. Norman Campbell male 27 1 0 113806 53.1 E8 S
726 726 0 3 Oreskovic, Mr. Luka male 20 0 0 315094 8.6625   S
727 727 1 2 Renouf, Mrs. Peter Henry (Lillian Jefferys) female 30 3 0 31027 21   S
728 728 1 3 Mannion, Miss. Margareth female . 0 0 36866 7.7375   Q
729 729 0 2 Bryhl, Mr. Kurt Arnold Gottfrid male 25 1 0 236853 26   S
730 730 0 3 Ilmakangas, Miss. Pieta Sofia female 25 1 0 STON/O2. 3101271 7.925   S
731 731 1 1 Allen, Miss. Elisabeth Walton female 29 0 0 24160 211.3375 B5 S
732 732 0 3 Hassan, Mr. Houssein G N male 11 0 0 2699 18.7875   C
733 733 0 2 Knight, Mr. Robert J male . 0 0 239855 0   S
734 734 0 2 Berriman, Mr. William John male 23 0 0 28425 13   S
735 735 0 2 Troupiansky, Mr. Moses Aaron male 23 0 0 233639 13   S
736 736 0 3 Williams, Mr. Leslie male 28.5 0 0 54636 16.1   S
737 737 0 3 Ford, Mrs. Edward (Margaret Ann Watson) female 48 1 3 W./C. 6608 34.375   S
738 738 1 1 Lesurer, Mr. Gustave J male 35 0 0 PC 17755 512.3292 B101 C
739 739 0 3 Ivanoff, Mr. Kanio male . 0 0 349201 7.8958   S
740 740 0 3 Nankoff, Mr. Minko male . 0 0 349218 7.8958   S
741 741 1 1 Hawksford, Mr. Walter James male . 0 0 16988 30 D45 S
742 742 0 1 Cavendish, Mr. Tyrell William male 36 1 0 19877 78.85 C46 S
743 743 1 1 Ryerson, Miss. Susan Parker "Suzette" female 21 2 2 PC 17608 262.375 B57 C
744 744 0 3 McNamee, Mr. Neal male 24 1 0 376566 16.1   S
745 745 1 3 Stranden, Mr. Juho male 31 0 0 STON/O 2. 310128 7.925   S
746 746 0 1 Crosby, Capt. Edward Gifford male 70 1 1 WE/P 5735 71 B22 S
747 747 0 3 Abbott, Mr. Rossmore Edward male 16 1 1 C.A. 2673 20.25   S
748 748 1 2 Sinkkonen, Miss. Anna female 30 0 0 250648 13   S
749 749 0 1 Marvin, Mr. Daniel Warner male 19 1 0 113773 53.1 D30 S
750 750 0 3 Connaghton, Mr. Michael male 31 0 0 335097 7.75   Q
751 751 1 2 Wells, Miss. Joan female 4 1 1 29103 23   S
752 752 1 3 Moor, Master. Meier male 6 0 1 392096 12.475 E121 S
753 753 0 3 Vande Velde, Mr. Johannes Joseph male 33 0 0 345780 9.5   S
754 754 0 3 Jonkoff, Mr. Lalio male 23 0 0 349204 7.8958   S
755 755 1 2 Herman, Mrs. Samuel (Jane Laver) female 48 1 2 220845 65   S
756 756 1 2 Hamalainen, Master. Viljo male 0.67 1 1 250649 14.5   S
757 757 0 3 Carlsson, Mr. August Sigfrid male 28 0 0 350042 7.7958   S
758 758 0 2 Bailey, Mr. Percy Andrew male 18 0 0 29108 11.5   S
759 759 0 3 Theobald, Mr. Thomas Leonard male 34 0 0 363294 8.05   S
760 760 1 1 Rothes, the Countess. of (Lucy Noel Martha Dyer-Edwards) female 33 0 0 110152 86.5 B77 S
761 761 0 3 Garfirth, Mr. John male . 0 0 358585 14.5   S
762 762 0 3 Nirva, Mr. Iisakki Antino Aijo male 41 0 0 SOTON/O2 3101272 7.125   S
763 763 1 3 Barah, Mr. Hanna Assi male 20 0 0 2663 7.2292   C
764 764 1 1 Carter, Mrs. William Ernest (Lucile Polk) female 36 1 2 113760 120 B96 S
765 765 0 3 Eklund, Mr. Hans Linus male 16 0 0 347074 7.775   S
766 766 1 1 Hogeboom, Mrs. John C (Anna Andrews) female 51 1 0 13502 77.9583 D11 S
767 767 0 1 Brewe, Dr. Arthur Jackson male . 0 0 112379 39.6   C
768 768 0 3 Mangan, Miss. Mary female 30.5 0 0 364850 7.75   Q
769 769 0 3 Moran, Mr. Daniel J male . 1 0 371110 24.15   Q
770 770 0 3 Gronnestad, Mr. Daniel Danielsen male 32 0 0 8471 8.3625   S
771 771 0 3 Lievens, Mr. Rene Aime male 24 0 0 345781 9.5   S
772 772 0 3 Jensen, Mr. Niels Peder male 48 0 0 350047 7.8542   S
773 773 0 2 Mack, Mrs. (Mary) female 57 0 0 S.O./P.P. 3 10.5 E77 S
774 774 0 3 Elias, Mr. Dibo male . 0 0 2674 7.225   C
775 775 1 2 Hocking, Mrs. Elizabeth (Eliza Needs) female 54 1 3 29105 23   S
776 776 0 3 Myhrman, Mr. Pehr Fabian Oliver Malkolm male 18 0 0 347078 7.75   S
777 777 0 3 Tobin, Mr. Roger male . 0 0 383121 7.75 F38 Q
778 778 1 3 Emanuel, Miss. Virginia Ethel female 5 0 0 364516 12.475   S
779 779 0 3 Kilgannon, Mr. Thomas J male . 0 0 36865 7.7375   Q
780 780 1 1 Robert, Mrs. Edward Scott (Elisabeth Walton McMillan) female 43 0 1 24160 211.3375 B3 S
781 781 1 3 Ayoub, Miss. Banoura female 13 0 0 2687 7.2292   C
782 782 1 1 Dick, Mrs. Albert Adrian (Vera Gillespie) female 17 1 0 17474 57 B20 S
783 783 0 1 Long, Mr. Milton Clyde male 29 0 0 113501 30 D6 S
784 784 0 3 Johnston, Mr. Andrew G male . 1 2 W./C. 6607 23.45   S
785 785 0 3 Ali, Mr. William male 25 0 0 SOTON/O.Q. 31013 7.05   S
786 786 0 3 Harmer, Mr. Abraham (David Lishin) male 25 0 0 374887 7.25   S
787 787 1 3 Sjoblom, Miss. Anna Sofia female 18 0 0 3101265 7.4958   S
788 788 0 3 Rice, Master. George Hugh male 8 4 1 382652 29.125   Q
789 789 1 3 Dean, Master. Bertram Vere male 1 1 2 C.A. 2315 20.575   S
790 790 0 1 Guggenheim, Mr. Benjamin male 46 0 0 PC 17593 79.2 B82 C
791 791 0 3 Keane, Mr. Andrew "Andy" male . 0 0 12460 7.75   Q
792 792 0 2 Gaskell, Mr. Alfred male 16 0 0 239865 26   S
793 793 0 3 Sage, Miss. Stella Anna female . 8 2 CA. 2343 69.55   S
794 794 0 1 Hoyt, Mr. William Fisher male . 0 0 PC 17600 30.6958   C
795 795 0 3 Dantcheff, Mr. Ristiu male 25 0 0 349203 7.8958   S
796 796 0 2 Otter, Mr. Richard male 39 0 0 28213 13   S
797 797 1 1 Leader, Dr. Alice (Farnham) female 49 0 0 17465 25.9292 D17 S
798 798 1 3 Osman, Mrs. Mara female 31 0 0 349244 8.6833   S
799 799 0 3 Ibrahim Shawah, Mr. Yousseff male 30 0 0 2685 7.2292   C
800 800 0 3 Van Impe, Mrs. Jean Baptiste (Rosalie Paula Govaert) female 30 1 1 345773 24.15   S
801 801 0 2 Ponesell, Mr. Martin male 34 0 0 250647 13   S
802 802 1 2 Collyer, Mrs. Harvey (Charlotte Annie Tate) female 31 1 1 C.A. 31921 26.25   S
803 803 1 1 Carter, Master. William Thornton II male 11 1 2 113760 120 B96 S
804 804 1 3 Thomas, Master. Assad Alexander male 0.42 0 1 2625 8.5167   C
805 805 1 3 Hedman, Mr. Oskar Arvid male 27 0 0 347089 6.975   S
806 806 0 3 Johansson, Mr. Karl Johan male 31 0 0 347063 7.775   S
807 807 0 1 Andrews, Mr. Thomas Jr male 39 0 0 112050 0 A36 S
808 808 0 3 Pettersson, Miss. Ellen Natalia female 18 0 0 347087 7.775   S
809 809 0 2 Meyer, Mr. August male 39 0 0 248723 13   S
810 810 1 1 Chambers, Mrs. Norman Campbell (Bertha Griggs) female 33 1 0 113806 53.1 E8 S
811 811 0 3 Alexander, Mr. William male 26 0 0 3474 7.8875   S
812 812 0 3 Lester, Mr. James male 39 0 0 A/4 48871 24.15   S
813 813 0 2 Slemen, Mr. Richard James male 35 0 0 28206 10.5   S
814 814 0 3 Andersson, Miss. Ebba Iris Alfrida female 6 4 2 347082 31.275   S
815 815 0 3 Tomlin, Mr. Ernest Portage male 30.5 0 0 364499 8.05   S
816 816 0 1 Fry, Mr. Richard male . 0 0 112058 0 B102 S
817 817 0 3 Heininen, Miss. Wendla Maria female 23 0 0 STON/O2. 3101290 7.925   S
818 818 0 2 Mallet, Mr. Albert male 31 1 1 S.C./PARIS 2079 37.0042   C
819 819 0 3 Holm, Mr. John Fredrik Alexander male 43 0 0 C 7075 6.45   S
820 820 0 3 Skoog, Master. Karl Thorsten male 10 3 2 347088 27.9   S
821 821 1 1 Hays, Mrs. Charles Melville (Clara Jennings Gregg) female 52 1 1 12749 93.5 B69 S
822 822 1 3 Lulic, Mr. Nikola male 27 0 0 315098 8.6625   S
823 823 0 1 Reuchlin, Jonkheer. John George male 38 0 0 19972 0   S
824 824 1 3 Moor, Mrs. (Beila) female 27 0 1 392096 12.475 E121 S
825 825 0 3 Panula, Master. Urho Abraham male 2 4 1 3101295 39.6875   S
826 826 0 3 Flynn, Mr. John male . 0 0 368323 6.95   Q
827 827 0 3 Lam, Mr. Len male . 0 0 1601 56.4958   S
828 828 1 2 Mallet, Master. Andre male 1 0 2 S.C./PARIS 2079 37.0042   C
829 829 1 3 McCormack, Mr. Thomas Joseph male . 0 0 367228 7.75   Q
830 830 1 1 Stone, Mrs. George Nelson (Martha Evelyn) female 62 0 0 113572 80 B28  
831 831 1 3 Yasbeck, Mrs. Antoni (Selini Alexander) female 15 1 0 2659 14.4542   C
832 832 1 2 Richards, Master. George Sibley male 0.83 1 1 29106 18.75   S
833 833 0 3 Saad, Mr. Amin male . 0 0 2671 7.2292   C
834 834 0 3 Augustsson, Mr. Albert male 23 0 0 347468 7.8542   S
835 835 0 3 Allum, Mr. Owen George male 18 0 0 2223 8.3   S
836 836 1 1 Compton, Miss. Sara Rebecca female 39 1 1 PC 17756 83.1583 E49 C
837 837 0 3 Pasic, Mr. Jakob male 21 0 0 315097 8.6625   S
838 838 0 3 Sirota, Mr. Maurice male . 0 0 392092 8.05   S
839 839 1 3 Chip, Mr. Chang male 32 0 0 1601 56.4958   S
840 840 1 1 Marechal, Mr. Pierre male . 0 0 11774 29.7 C47 C
841 841 0 3 Alhomaki, Mr. Ilmari Rudolf male 20 0 0 SOTON/O2 3101287 7.925   S
842 842 0 2 Mudd, Mr. Thomas Charles male 16 0 0 S.O./P.P. 3 10.5   S
843 843 1 1 Serepeca, Miss. Augusta female 30 0 0 113798 31   C
844 844 0 3 Lemberopolous, Mr. Peter L male 34.5 0 0 2683 6.4375   C
845 845 0 3 Culumovic, Mr. Jeso male 17 0 0 315090 8.6625   S
846 846 0 3 Abbing, Mr. Anthony male 42 0 0 C.A. 5547 7.55   S
847 847 0 3 Sage, Mr. Douglas Bullen male . 8 2 CA. 2343 69.55   S
848 848 0 3 Markoff, Mr. Marin male 35 0 0 349213 7.8958   C
849 849 0 2 Harper, Rev. John male 28 0 1 248727 33   S
850 850 1 1 Goldenberg, Mrs. Samuel L (Edwiga Grabowska) female . 1 0 17453 89.1042 C92 C
851 851 0 3 Andersson, Master. Sigvard Harald Elias male 4 4 2 347082 31.275   S
852 852 0 3 Svensson, Mr. Johan male 74 0 0 347060 7.775   S
853 853 0 3 Boulos, Miss. Nourelain female 9 1 1 2678 15.2458   C
854 854 1 1 Lines, Miss. Mary Conover female 16 0 1 PC 17592 39.4 D28 S
855 855 0 2 Carter, Mrs. Ernest Courtenay (Lilian Hughes) female 44 1 0 244252 26   S
856 856 1 3 Aks, Mrs. Sam (Leah Rosen) female 18 0 1 392091 9.35   S
857 857 1 1 Wick, Mrs. George Dennick (Mary Hitchcock) female 45 1 1 36928 164.8667   S
858 858 1 1 Daly, Mr. Peter Denis male 51 0 0 113055 26.55 E17 S
859 859 1 3 Baclini, Mrs. Solomon (Latifa Qurban) female 24 0 3 2666 19.2583   C
860 860 0 3 Razi, Mr. Raihed male . 0 0 2629 7.2292   C
861 861 0 3 Hansen, Mr. Claus Peter male 41 2 0 350026 14.1083   S
862 862 0 2 Giles, Mr. Frederick Edward male 21 1 0 28134 11.5   S
863 863 1 1 Swift, Mrs. Frederick Joel (Margaret Welles Barron) female 48 0 0 17466 25.9292 D17 S
864 864 0 3 Sage, Miss. Dorothy Edith "Dolly" female . 8 2 CA. 2343 69.55   S
865 865 0 2 Gill, Mr. John William male 24 0 0 233866 13   S
866 866 1 2 Bystrom, Mrs. (Karolina) female 42 0 0 236852 13   S
867 867 1 2 Duran y More, Miss. Asuncion female 27 1 0 SC/PARIS 2149 13.8583   C
868 868 0 1 Roebling, Mr. Washington Augustus II male 31 0 0 PC 17590 50.4958 A24 S
869 869 0 3 van Melkebeke, Mr. Philemon male . 0 0 345777 9.5   S
870 870 1 3 Johnson, Master. Harold Theodor male 4 1 1 347742 11.1333   S
871 871 0 3 Balkic, Mr. Cerin male 26 0 0 349248 7.8958   S
872 872 1 1 Beckwith, Mrs. Richard Leonard (Sallie Monypeny) female 47 1 1 11751 52.5542 D35 S
873 873 0 1 Carlsson, Mr. Frans Olof male 33 0 0 695 5 B51 S
874 874 0 3 Vander Cruyssen, Mr. Victor male 47 0 0 345765 9   S
875 875 1 2 Abelson, Mrs. Samuel (Hannah Wizosky) female 28 1 0 P/PP 3381 24   C
876 876 1 3 Najib, Miss. Adele Kiamie "Jane" female 15 0 0 2667 7.225   C
877 877 0 3 Gustafsson, Mr. Alfred Ossian male 20 0 0 7534 9.8458   S
878 878 0 3 Petroff, Mr. Nedelio male 19 0 0 349212 7.8958   S
879 879 0 3 Laleff, Mr. Kristo male . 0 0 349217 7.8958   S
880 880 1 1 Potter, Mrs. Thomas Jr (Lily Alexenia Wilson) female 56 0 1 11767 83.1583 C50 C
881 881 1 2 Shelley, Mrs. William (Imanita Parrish Hall) female 25 0 1 230433 26   S
882 882 0 3 Markun, Mr. Johann male 33 0 0 349257 7.8958   S
883 883 0 3 Dahlberg, Miss. Gerda Ulrika female 22 0 0 7552 10.5167   S
884 884 0 2 Banfield, Mr. Frederick James male 28 0 0 C.A./SOTON 34068 10.5   S
885 885 0 3 Sutehall, Mr. Henry Jr male 25 0 0 SOTON/OQ 392076 7.05   S
886 886 0 3 Rice, Mrs. William (Margaret Norton) female 39 0 5 382652 29.125   Q
887 887 0 2 Montvila, Rev. Juozas male 27 0 0 211536 13   S
888 888 1 1 Graham, Miss. Margaret Edith female 19 0 0 112053 30 B42 S
889 889 0 3 Johnston, Miss. Catherine Helen "Carrie" female . 1 2 W./C. 6607 23.45   S
890 890 1 1 Behr, Mr. Karl Howell male 26 0 0 111369 30 C148 C
891 891 0 3 Dooley, Mr. Patrick male 32 0 0 370376 7.75   Q

SAS Informats and Formats

Informats

  • Informats are instructions for how the data is to be read by a computer
  • This allows users to read data in different types (for example data with comma's can be read as a numeric value rather than a character string)
  • Informats can be supplied by SAS or created by the user. We will focus exclusively on SAS defined informats.
  • Character informats have the following format \$informat name w. , where \$ designates a character variable and w specifies the width. Examples include:
    • \$16. (Character field of width 16, trims leading blanks
    • \$CHAR7. (Character field with width of seven, does not trim leading blanks)
    • \$UPCASE9. (Converts characters to uppercase)
  • Numeric and Datetime informats do not start with \$. Examples include:
    • best32. (generic numeric value of width 32)
    • COMMA9. (numeric values with commas with width of 9)
    • DATEw. (reads dates in form: ddmmmyy or ddmmmyyyy)
    • DDMMYYw. (reades dates in form: DDMMYY)
  • Dates are the number of days since January 1, 1960.

Formats

  • Formats are similar to informats, but rather than focusing on reading the data formats control how the data is displayed.
  • Formats are instructions to SAS on writing the data.
  • It may be computationally efficient to store binary data as '1' or '0', but when printing the data we'd prefer to see 'Passenger Survived' or 'Passenger did not Survive'. So in this example the format would be the character strings.
    • PROC IMPORT automatically specifies informat and formats.
In [99]:
DATA skicounts2;
    INPUT NewSnow $ Day $ NumSkiers $;
    DATALINES;
28 SAT 5,200
13 SUN 6,300
4 MON 3,400
0 TUE 2,150
;
RUN;
Out[99]:

1193  ods listing close;ods html5 file=stdout options(bitmap_mode='inline') device=png; ods graphics on / outputfmt=png;
NOTE: Writing HTML5 Body file: STDOUT
1194  
1195  DATA skicounts2;
1196      INPUT NewSnow $ Day $ NumSkiers $;
1197      DATALINES;
NOTE: The data set WORK.SKICOUNTS2 has 4 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
1202  ;
1203  RUN;
1204  
1205  
1206  ods html5 close;ods listing;

1207
In [100]:
* Note that the previous title remains;
Proc Print Data=skicounts2;
run;
Out[100]:
SAS Output

Information about passengers on Titanic

Obs NewSnow Day NumSkiers
1 28 SAT 5,200
2 13 SUN 6,300
3 4 MON 3,400
4 0 TUE 2,150
In [101]:
PROC PRINT DATA = skicounts2;
TITLE;
RUN;
Out[101]:
SAS Output
Obs NewSnow Day NumSkiers
1 28 SAT 5,200
2 13 SUN 6,300
3 4 MON 3,400
4 0 TUE 2,150
In [102]:
Proc Contents data = skicounts2;
run;
Out[102]:
SAS Output

The CONTENTS Procedure

Data Set Name WORK.SKICOUNTS2 Observations 4
Member Type DATA Variables 3
Engine V9 Indexes 0
Created 03/29/2017 23:01:58 Observation Length 24
Last Modified 03/29/2017 23:01:58 Deleted Observations 0
Protection   Compressed NO
Data Set Type   Sorted NO
Label      
Data Representation SOLARIS_X86_64, LINUX_X86_64, ALPHA_TRU64, LINUX_IA64    
Encoding utf-8 Unicode (UTF-8)    
Engine/Host Dependent Information
Data Set Page Size 65536
Number of Data Set Pages 1
First Data Page 1
Max Obs per Page 2714
Obs in First Data Page 4
Number of Data Set Repairs 0
Filename /tmp/SAS_workA13F00000A0A_cs-verde-xpmini.coe.montana.edu/skicounts2.sas7bdat
Release Created 9.0401M4
Host Created Linux
Inode Number 147867
Access Permission rw-r--r--
Owner Name sasdemo
File Size 128KB
File Size (bytes) 131072
Alphabetic List of Variables and Attributes
# Variable Type Len
2 Day Char 8
1 NewSnow Char 8
3 NumSkiers Char 8
In [103]:
DATA skicounts2;
    INPUT NewSnow  Day $ NumSkiers comma5.;
    DATALINES;
28 SAT 5,200
13 SUN 6,300
4 MON 3,400
0 TUE 2,150
;
RUN;
Out[103]:

1232  ods listing close;ods html5 file=stdout options(bitmap_mode='inline') device=png; ods graphics on / outputfmt=png;
NOTE: Writing HTML5 Body file: STDOUT
1233  
1234  DATA skicounts2;
1235      INPUT NewSnow  Day $ NumSkiers comma5.;
1236      DATALINES;
NOTE: The data set WORK.SKICOUNTS2 has 4 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
1241  ;
1242  RUN;
1243  ods html5 close;ods listing;

1244
In [104]:
proc print data=skicounts2;
run;
Out[104]:
SAS Output
Obs NewSnow Day NumSkiers
1 28 SAT 5200
2 13 SUN 6300
3 4 MON 3400
4 0 TUE 2150
In [105]:
Proc Contents data = skicounts2;
run;
Out[105]:
SAS Output

The CONTENTS Procedure

Data Set Name WORK.SKICOUNTS2 Observations 4
Member Type DATA Variables 3
Engine V9 Indexes 0
Created 03/29/2017 23:01:58 Observation Length 24
Last Modified 03/29/2017 23:01:58 Deleted Observations 0
Protection   Compressed NO
Data Set Type   Sorted NO
Label      
Data Representation SOLARIS_X86_64, LINUX_X86_64, ALPHA_TRU64, LINUX_IA64    
Encoding utf-8 Unicode (UTF-8)    
Engine/Host Dependent Information
Data Set Page Size 65536
Number of Data Set Pages 1
First Data Page 1
Max Obs per Page 2714
Obs in First Data Page 4
Number of Data Set Repairs 0
Filename /tmp/SAS_workA13F00000A0A_cs-verde-xpmini.coe.montana.edu/skicounts2.sas7bdat
Release Created 9.0401M4
Host Created Linux
Inode Number 147865
Access Permission rw-r--r--
Owner Name sasdemo
File Size 128KB
File Size (bytes) 131072
Alphabetic List of Variables and Attributes
# Variable Type Len
2 Day Char 8
1 NewSnow Num 8
3 NumSkiers Num 8

Libname Statements and Temporary vs. Permanent Data

  • In R, when you create a data frame the data frame is not saved in your working directory. However, R data frames can be saved, using save() and loaded directly into R.
  • SAS is similar, in that the default is for data sets not to be directly saved.
  • However, as in R, data sets can be saved, but this requires specifying a Libname.

Libname statements are specifed by the following recipe: LIBNAME libref 'location of SAS data library'

In [106]:
* This is slightly different using SAS University due to the requirement of virtual box;
libname mydata '/folders/myfolders/';

* Note this will create a permanent SAS file in the above directory;
* SAS data files have the following extension .sas7bdat ;
DATA mydata.titanic;
    SET titanic;
RUN;
Out[106]:

1260  ods listing close;ods html5 file=stdout options(bitmap_mode='inline') device=png; ods graphics on / outputfmt=png;
NOTE: Writing HTML5 Body file: STDOUT
1261  
1262  * This is slightly different using SAS University due to the requirement of virtual box;
1263  libname mydata '/folders/myfolders/';
NOTE: Libref MYDATA was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: /folders/myfolders
1264  
1265  * Note this will create a permanent SAS file in the above directory;
1266  * SAS data files have the following extension .sas7bdat ;
1267  DATA mydata.titanic;
1268      SET titanic;
1269  RUN;
NOTE: There were 891 observations read from the data set WORK.TITANIC.
NOTE: The data set MYDATA.TITANIC has 891 observations and 12 variables.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.01 seconds
      
1270  ods html5 close;ods listing;

1271

Working with Your Data

Variables can be created or redefined in the SAS DATA STEP.

In [107]:
DATA ski;
    set skicounts2;
    Mountain = 'Bridger Bowl';
    peracre = NumSkiers / 2000;
Run;
Out[107]:

1273  ods listing close;ods html5 file=stdout options(bitmap_mode='inline') device=png; ods graphics on / outputfmt=png;
NOTE: Writing HTML5 Body file: STDOUT
1274  
1275  DATA ski;
1276      set skicounts2;
1277      Mountain = 'Bridger Bowl';
1278      peracre = NumSkiers / 2000;
1279  Run;
NOTE: There were 4 observations read from the data set WORK.SKICOUNTS2.
NOTE: The data set WORK.SKI has 4 observations and 5 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
1280  ods html5 close;ods listing;

1281
In [108]:
PROC PRINT DATA=ski;
    TITLE 'Bridger Bowl Ski Facts';
RUN;
Out[108]:
SAS Output

Bridger Bowl Ski Facts

Obs NewSnow Day NumSkiers Mountain peracre
1 28 SAT 5200 Bridger Bowl 2.600
2 13 SUN 6300 Bridger Bowl 3.150
3 4 MON 3400 Bridger Bowl 1.700
4 0 TUE 2150 Bridger Bowl 1.075

Using SAS Functions

  • SAS has many built in functions for character, date-time, and numeric data.
  • A few character functions include:
    • LEFT() left aligns SAS character expression
    • LENGTH() returns the length of argument not including trailing blanks
    • SUBSTR(arg,position,n) Extracts a substring from an argument starating at position for n characters.
  • A few numeric functions include:
    • MAX()
    • MIN()
    • ROUND(arg, round-off-unit)
    • SUM()
  • A few data functions include:
    • DAY(date) - returns day of month
    • WEEKDAY(date) - returns day of week (1 = Sunday)
    • MDY(month,day,year) - returns a SAS date value from month, day, and year value.
In [109]:
DATA ski;
    set ski;
    DayAbbr = substr(DAY,1,2);
Run;
Out[109]:

1291  ods listing close;ods html5 file=stdout options(bitmap_mode='inline') device=png; ods graphics on / outputfmt=png;
NOTE: Writing HTML5 Body file: STDOUT
1292  
1293  DATA ski;
1294      set ski;
1295      DayAbbr = substr(DAY,1,2);
1296  Run;
NOTE: There were 4 observations read from the data set WORK.SKI.
NOTE: The data set WORK.SKI has 4 observations and 6 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
1297  ods html5 close;ods listing;

1298
In [110]:
PROC PRINT DATA=ski;
run;
Out[110]:
SAS Output

Bridger Bowl Ski Facts

Obs NewSnow Day NumSkiers Mountain peracre DayAbbr
1 28 SAT 5200 Bridger Bowl 2.600 SA
2 13 SUN 6300 Bridger Bowl 3.150 SU
3 4 MON 3400 Bridger Bowl 1.700 MO
4 0 TUE 2150 Bridger Bowl 1.075 TU

Using IF-THEN Statements

If you want to assign some value to certain observations, but not others this is called conditional logic. We have done this in R with if and ifelse() functions.

In SAS the following syntax is used:

IF condition THEN action;

Conditional statements use the following operators:

Symbolic Mnemonic Meaning
= EQ equals
^= or ~= NE not equal
> GT greater than
< LT less than
>= GE greater than or equal
<= LE less than or equal
& AND all comparisons must be true
! OR only one comparison must be true

Similar to %in% R, we can also use in to test if a value is in a vector.

In [111]:
Data ski;
    SET Ski;
    If NewSnow > 0 THEN DayType ='Powder';
RUN;
Proc Print data= ski;
RUN;
Out[111]:
SAS Output

Bridger Bowl Ski Facts

Obs NewSnow Day NumSkiers Mountain peracre DayAbbr DayType
1 28 SAT 5200 Bridger Bowl 2.600 SA Powder
2 13 SUN 6300 Bridger Bowl 3.150 SU Powder
3 4 MON 3400 Bridger Bowl 1.700 MO Powder
4 0 TUE 2150 Bridger Bowl 1.075 TU  

Multiple statements require a DO STATEMENT which has a corresponding END.

In [112]:
Data ski;
    SET Ski;
    If NewSnow > 0 THEN DO;
    DayType ='Powder';
    Crowds = 'Busy';
    END;
RUN;
Proc Print data= ski;
RUN;
Out[112]:
SAS Output

Bridger Bowl Ski Facts

Obs NewSnow Day NumSkiers Mountain peracre DayAbbr DayType Crowds
1 28 SAT 5200 Bridger Bowl 2.600 SA Powder Busy
2 13 SUN 6300 Bridger Bowl 3.150 SU Powder Busy
3 4 MON 3400 Bridger Bowl 1.700 MO Powder Busy
4 0 TUE 2150 Bridger Bowl 1.075 TU    

IF -THEN/ELSE Statements

Similar to R, SAS also has the capability to handle if/else type of statments.

The format is:

IF condition THEN action;
    ELSE IF condition THEN action;
    ELSE action;
In [113]:
DATA ski;
    SET Ski;
    If DAY in ('SAT', 'SUN') THEN Weekend ='YES';
        ELSE Weekend = 'NO';
RUN;
Proc Print data= ski;
RUN;
Out[113]:
SAS Output

Bridger Bowl Ski Facts

Obs NewSnow Day NumSkiers Mountain peracre DayAbbr DayType Crowds Weekend
1 28 SAT 5200 Bridger Bowl 2.600 SA Powder Busy YES
2 13 SUN 6300 Bridger Bowl 3.150 SU Powder Busy YES
3 4 MON 3400 Bridger Bowl 1.700 MO Powder Busy NO
4 0 TUE 2150 Bridger Bowl 1.075 TU     NO

Subsetting Your Data

If statements can also be used to subset your data. Either by: IF expression which only keeps observations satisfying this criteria or IF expression THEN DELETE which deletes observations that satisfy that expression. ```

In [114]:
DATA ski_wkend;
    SET Ski;
    If Weekend ='YES';
RUN;
Proc Print data= ski_wkend;
RUN;
Out[114]:
SAS Output

Bridger Bowl Ski Facts

Obs NewSnow Day NumSkiers Mountain peracre DayAbbr DayType Crowds Weekend
1 28 SAT 5200 Bridger Bowl 2.60 SA Powder Busy YES
2 13 SUN 6300 Bridger Bowl 3.15 SU Powder Busy YES

Sorting, Printing, Summarizing Data Sets

SAS also permits WHERE statements for inside a PROC STATEMENT.

In [115]:
PROC PRINT data= ski;
    WHERE Crowds ='Busy';
RUN;
Out[115]:
SAS Output

Bridger Bowl Ski Facts

Obs NewSnow Day NumSkiers Mountain peracre DayAbbr DayType Crowds Weekend
1 28 SAT 5200 Bridger Bowl 2.60 SA Powder Busy YES
2 13 SUN 6300 Bridger Bowl 3.15 SU Powder Busy YES
3 4 MON 3400 Bridger Bowl 1.70 MO Powder Busy NO

PROC SORT

The syntax for PROC SORT is as follows:

PROC SORT DATA = DATA_IN OUT=DATA_OUT;
    BY VARIABLE1 (DESCENDING?) VARIABLE 2; * default is to sort in ascending order;
RUN;
In [116]:
PROC SORT DATA=SKI OUT=SKI_SORT;
    BY NewSnow peracre;
RUN;

PROC PRINT DATA=SKI_SORT;
RUN;
Out[116]:
SAS Output

Bridger Bowl Ski Facts

Obs NewSnow Day NumSkiers Mountain peracre DayAbbr DayType Crowds Weekend
1 0 TUE 2150 Bridger Bowl 1.075 TU     NO
2 4 MON 3400 Bridger Bowl 1.700 MO Powder Busy NO
3 13 SUN 6300 Bridger Bowl 3.150 SU Powder Busy YES
4 28 SAT 5200 Bridger Bowl 2.600 SA Powder Busy YES

More on PROC PRINT

We have seen several instances of PROC PRINT, to see complete options for this procedure visit the SAS help here. Note there is a link in the first slides for searching SAS PROCEDURES.

Some options include:

  • BY VARIABLE-LIST starts a new section in the output for each level of the variable. The data must be pre-sorted by that variable.
  • VAR VARIABLE-LIST specifies which variables to print and the order.
In [117]:
PROC SORT DATA= SKI OUT=SKI_SORT;
    BY Weekend;
RUN;

PROC PRINT DATA=SKI_SORT;
    BY Weekend;
    VAR NewSnow NumSkiers Weekend;
RUN;
Out[117]:
SAS Output

Bridger Bowl Ski Facts

Weekend=NO

Obs NewSnow NumSkiers Weekend
1 4 3400 NO
2 0 2150 NO

Weekend=YES

Obs NewSnow NumSkiers Weekend
3 28 5200 YES
4 13 6300 YES

Formats can also be specified in a PROC PRINT statement.

In [118]:
PROC PRINT DATA=SKI_SORT;
    BY Weekend;
    VAR NewSnow NumSkiers Weekend;
    FORMAT NumSkiers COMMA5.;
RUN;
Out[118]:
SAS Output

Bridger Bowl Ski Facts

Weekend=NO

Obs NewSnow NumSkiers Weekend
1 4 3,400 NO
2 0 2,150 NO

Weekend=YES

Obs NewSnow NumSkiers Weekend
3 28 5,200 YES
4 13 6,300 YES

Summarizing DATA with PROC MEANS

The PROC MEANS procedure has several options, many of which we will touch on next week.

The procedure prints specified data summaries.

In [119]:
PROC MEANS DATA=SKI_SORT;
    BY Weekend;
    VAR NewSnow NumSkiers;
RUN;
Out[119]:
SAS Output

Bridger Bowl Ski Facts

The MEANS Procedure

Weekend=NO

Variable N Mean Std Dev Minimum Maximum
NewSnow
NumSkiers
2
2
2.0000000
2775.00
2.8284271
883.8834765
0
2150.00
4.0000000
3400.00

Weekend=YES

Variable N Mean Std Dev Minimum Maximum
NewSnow
NumSkiers
2
2
20.5000000
5750.00
10.6066017
777.8174593
13.0000000
5200.00
28.0000000
6300.00