ÿþ<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=Content-Type content="text/html; charset=unicode"> <meta name=ProgId content=Word.Document> <meta name=Generator content="Microsoft Word 14"> <meta name=Originator content="Microsoft Word 14"> <link rel=File-List href="index_files/filelist.xml"> <title>HRP 223 Data Management and Statistical Programming</title> <!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Author>Raymond Balise</o:Author> <o:Template>Normal</o:Template> <o:LastAuthor> balise</o:LastAuthor> <o:Revision>184</o:Revision> <o:TotalTime>3626</o:TotalTime> <o:Created>2010-05-18T15:34:00Z</o:Created> <o:LastSaved>2011-12-05T16:30:00Z</o:LastSaved> <o:Pages>5</o:Pages> <o:Words>1832</o:Words> <o:Characters>16731</o:Characters> <o:Lines>139</o:Lines> <o:Paragraphs>37</o:Paragraphs> <o:CharactersWithSpaces>18526</o:CharactersWithSpaces> <o:Version>14.00</o:Version> </o:DocumentProperties> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> <link rel=themeData href="index_files/themedata.thmx"> <link rel=colorSchemeMapping href="index_files/colorschememapping.xml"> <!--[if gte mso 9]><xml> <w:WordDocument> <w:Zoom>125</w:Zoom> <w:SpellingState>Clean</w:SpellingState> <w:GrammarState>Clean</w:GrammarState> <w:TrackMoves/> <w:TrackFormatting/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:DontVertAlignCellWithSp/> <w:DontBreakConstrainedForcedTables/> <w:DontVertAlignInTxbx/> <w:Word11KerningPairs/> <w:CachedColBalance/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="&#45;-"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--> <style> <!-- /* Font Definitions */ @font-face {font-family:Cambria; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-536870145 1073743103 0 0 415 0;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:1627400839 -2147483648 8 0 66047 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast;} h1 {mso-style-priority:9; mso-style-unhide:no; mso-style-qformat:yes; mso-style-link:"Heading 1 Char"; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; mso-outline-level:1; font-size:24.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; font-weight:bold;} h2 {mso-style-priority:9; mso-style-unhide:no; mso-style-qformat:yes; mso-style-link:"Heading 2 Char"; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; mso-outline-level:2; font-size:18.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; font-weight:bold;} h3 {mso-style-priority:9; mso-style-unhide:no; mso-style-qformat:yes; mso-style-link:"Heading 3 Char"; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; mso-outline-level:3; font-size:13.5pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; font-weight:bold;} h4 {mso-style-noshow:yes; mso-style-priority:9; mso-style-qformat:yes; mso-style-link:"Heading 4 Char"; mso-style-next:Normal; margin-top:10.0pt; margin-right:0in; margin-bottom:0in; margin-left:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan lines-together; page-break-after:avoid; mso-outline-level:4; font-size:12.0pt; font-family:"Cambria","serif"; mso-ascii-font-family:Cambria; mso-ascii-theme-font:major-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:major-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:major-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:major-bidi; color:#4F81BD; mso-themecolor:accent1; font-weight:bold; font-style:italic;} a:link, span.MsoHyperlink {mso-style-noshow:yes; mso-style-priority:99; color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {mso-style-noshow:yes; mso-style-priority:99; color:blue; text-decoration:underline; text-underline:single;} p {mso-style-priority:99; mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast;} p.MsoAcetate, li.MsoAcetate, div.MsoAcetate {mso-style-noshow:yes; mso-style-priority:99; mso-style-link:"Balloon Text Char"; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:8.0pt; font-family:"Tahoma","sans-serif"; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast;} p.MsoNoSpacing, li.MsoNoSpacing, div.MsoNoSpacing {mso-style-priority:1; mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast;} p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; margin-top:0in; margin-right:0in; margin-bottom:0in; margin-left:.5in; margin-bottom:.0001pt; mso-add-space:auto; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast;} p.MsoListParagraphCxSpFirst, li.MsoListParagraphCxSpFirst, div.MsoListParagraphCxSpFirst {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; mso-style-type:export-only; margin-top:0in; margin-right:0in; margin-bottom:0in; margin-left:.5in; margin-bottom:.0001pt; mso-add-space:auto; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast;} p.MsoListParagraphCxSpMiddle, li.MsoListParagraphCxSpMiddle, div.MsoListParagraphCxSpMiddle {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; mso-style-type:export-only; margin-top:0in; margin-right:0in; margin-bottom:0in; margin-left:.5in; margin-bottom:.0001pt; mso-add-space:auto; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast;} p.MsoListParagraphCxSpLast, li.MsoListParagraphCxSpLast, div.MsoListParagraphCxSpLast {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; mso-style-type:export-only; margin-top:0in; margin-right:0in; margin-bottom:0in; margin-left:.5in; margin-bottom:.0001pt; mso-add-space:auto; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman","serif"; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast;} span.Heading1Char {mso-style-name:"Heading 1 Char"; mso-style-priority:9; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:"Heading 1"; mso-ansi-font-size:14.0pt; mso-bidi-font-size:14.0pt; font-family:"Cambria","serif"; mso-ascii-font-family:Cambria; mso-ascii-theme-font:major-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:major-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:major-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:major-bidi; color:#365F91; mso-themecolor:accent1; mso-themeshade:191; font-weight:bold;} span.Heading2Char {mso-style-name:"Heading 2 Char"; mso-style-noshow:yes; mso-style-priority:9; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:"Heading 2"; mso-ansi-font-size:13.0pt; mso-bidi-font-size:13.0pt; font-family:"Cambria","serif"; mso-ascii-font-family:Cambria; mso-ascii-theme-font:major-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:major-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:major-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:major-bidi; color:#4F81BD; mso-themecolor:accent1; font-weight:bold;} span.Heading3Char {mso-style-name:"Heading 3 Char"; mso-style-noshow:yes; mso-style-priority:9; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:"Heading 3"; mso-ansi-font-size:12.0pt; mso-bidi-font-size:12.0pt; font-family:"Cambria","serif"; mso-ascii-font-family:Cambria; mso-ascii-theme-font:major-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:major-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:major-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:major-bidi; color:#4F81BD; mso-themecolor:accent1; font-weight:bold;} span.Heading4Char {mso-style-name:"Heading 4 Char"; mso-style-noshow:yes; mso-style-priority:9; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:"Heading 4"; mso-ansi-font-size:12.0pt; mso-bidi-font-size:12.0pt; font-family:"Cambria","serif"; mso-ascii-font-family:Cambria; mso-ascii-theme-font:major-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:major-fareast; mso-hansi-font-family:Cambria; mso-hansi-theme-font:major-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:major-bidi; color:#4F81BD; mso-themecolor:accent1; font-weight:bold; font-style:italic;} span.BalloonTextChar {mso-style-name:"Balloon Text Char"; mso-style-noshow:yes; mso-style-priority:99; mso-style-unhide:no; mso-style-locked:yes; mso-style-link:"Balloon Text"; mso-ansi-font-size:8.0pt; mso-bidi-font-size:8.0pt; font-family:"Tahoma","sans-serif"; mso-ascii-font-family:Tahoma; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Tahoma; mso-bidi-font-family:Tahoma;} span.eudoraheader {mso-style-name:eudoraheader; mso-style-unhide:no;} span.object {mso-style-name:object; mso-style-unhide:no;} span.apple-style-span {mso-style-name:apple-style-span; mso-style-unhide:no;} span.SpellE {mso-style-name:""; mso-spl-e:yes;} span.GramE {mso-style-name:""; mso-gram-e:yes;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; font-size:10.0pt; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} /* List Definitions */ @list l0 {mso-list-id:896209347; mso-list-type:hybrid; mso-list-template-ids:575807816 740849316 -177953730 -2050981316 -520992962 1781924428 1666213634 1215714628 1883435700 -1862490966;} @list l0:level1 {mso-level-tab-stop:.5in; mso-level-number-position:left; text-indent:-.25in;} @list l0:level2 {mso-level-tab-stop:1.0in; mso-level-number-position:left; text-indent:-.25in;} @list l0:level3 {mso-level-tab-stop:1.5in; mso-level-number-position:left; text-indent:-.25in;} @list l0:level4 {mso-level-tab-stop:2.0in; mso-level-number-position:left; text-indent:-.25in;} @list l0:level5 {mso-level-tab-stop:2.5in; mso-level-number-position:left; text-indent:-.25in;} @list l0:level6 {mso-level-tab-stop:3.0in; mso-level-number-position:left; text-indent:-.25in;} @list l0:level7 {mso-level-tab-stop:3.5in; mso-level-number-position:left; text-indent:-.25in;} @list l0:level8 {mso-level-tab-stop:4.0in; mso-level-number-position:left; text-indent:-.25in;} @list l0:level9 {mso-level-tab-stop:4.5in; mso-level-number-position:left; text-indent:-.25in;} @list l1 {mso-list-id:1509053049; mso-list-template-ids:1598216068;} ol {margin-bottom:0in;} ul {margin-bottom:0in;} --> </style> <!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif";} </style> <![endif]--> <meta name=Title content="HRP 223 Data Management and Statistical Programming"> <meta name=Keywords content=""> <!--[if gte mso 9]><xml> <o:shapedefaults v:ext="edit" spidmax="1026"/> </xml><![endif]--><!--[if gte mso 9]><xml> <o:shapelayout v:ext="edit"> <o:idmap v:ext="edit" data="1"/> </o:shapelayout></xml><![endif]--> </head> <body bgcolor=white lang=EN-US link=blue vlink=blue style='tab-interval:.5in'> <div class=WordSection1> <h1><span style='mso-fareast-font-family:"Times New Roman";color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>HRP 223 - Data Management and Statistical Programming - 2011/2012 Edition<o:p></o:p></span></h1> <p class=MsoNormal><span style='color:#4BACC6;mso-themecolor:accent5'><o:p>&nbsp;</o:p></span></p> <p class=MsoNormal>The materials on this course website are only for the use of students enrolled in this course for purposes associated with this course and may not be retained or further disseminated.<span style='mso-spacerun:yes'>  </span>The materials on this course website may be protected by copyright; any further use of this material may be in violation of federal copyright law.</p> <p class=MsoNormal><o:p>&nbsp;</o:p></p> <p class=MsoNormal>The goal of the course is to provide hands on instruction in data management and analysis techniques. <br> Topics discussed include: </p> <ol style='margin-top:0in' start=1 type=1> <li class=MsoNormal style='mso-list:l0 level1 lfo3;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Working with large databases - what makes a good database turn bad<o:p></o:p></span></li> <li class=MsoNormal style='mso-list:l0 level1 lfo3;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Data cleaning techniques<o:p></o:p></span></li> <li class=MsoNormal style='mso-list:l0 level1 lfo3;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Generating numerical and graphical presentations<o:p></o:p></span></li> <li class=MsoNormal style='mso-list:l0 level1 lfo3;tab-stops:list .5in'><span style='mso-fareast-font-family:"Times New Roman"'>Descriptive statistics<o:p></o:p></span></li> </ol> <h2><span style='mso-fareast-font-family:"Times New Roman";color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Contact information<o:p></o:p></span></h2> <table class=MsoNormalTable border=1 cellpadding=0 width="100%" style='width:100.1%;mso-cellspacing:1.5pt;margin-left:-.5pt;mso-yfti-tbllook: 1184;mso-padding-alt:0in 0in 0in 0in'> <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'> <td style='padding:.75pt .75pt .75pt .75pt'> <p class=MsoNormal align=center style='text-align:center'><b><span style='font-size:18.0pt'>Professor</span></b></p> </td> <td style='padding:.75pt .75pt .75pt .75pt'> <p class=MsoNormal align=center style='text-align:center'><b><span style='font-size:18.0pt'>Teaching Assistant</span></b></p> </td> </tr> <tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'> <td style='padding:.75pt .75pt .75pt .75pt'> <p class=MsoNormal>Raymond R. Balise&nbsp; <br> Redwood Bldg. T213D, MC 5092&nbsp; <br> Stanford, California&nbsp; 94305-5405&nbsp; </p> <p>Balise at Stanford&nbsp; <br> Voice (650) 724-2602&nbsp; <br> Fax (650) 725-6951</p> </td> <td style='padding:.75pt .75pt .75pt .75pt'> <p class=MsoNormal>Mike Hurley</p> <p class=MsoNormal><o:p>&nbsp;</o:p></p> <p class=MsoNormal><o:p>&nbsp;</o:p></p> <p class=MsoNormal><span class=SpellE>mphurley</span> at Stanford</p> <p class=MsoNormal><o:p>&nbsp;</o:p></p> <p class=MsoNormal><span lang=SV style='mso-ansi-language:SV'>&nbsp;</span></p> </td> </tr> </table> <h2><span style='mso-fareast-font-family:"Times New Roman";color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Prerequisites<o:p></o:p></span></h2> <p class=MsoNormal><span class=GramE>Admission to Health Research and Policy and a comfortable knowledge of a Windows XP/Vista/7.</span> </p> <h2 style='tab-stops:11.2in'><span style='mso-fareast-font-family:"Times New Roman"; color:#D99694;mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color: #D99694;mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha: 100.0%;mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Lectures</span><span style='mso-fareast-font-family:"Times New Roman";color:#4BACC6;mso-themecolor: accent5'><span style='mso-tab-count:1'>                                                                                                              </span><o:p></o:p></span></h2> <p class=MsoNormal><span class=GramE>Monday and Wednesday 11:30  1:00 in LK209 starting September 26<sup>th</sup>.</span></p> <h2><span style='mso-fareast-font-family:"Times New Roman";color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Office Hours<o:p></o:p></span></h2> <p class=MsoNormal><span class=GramE>By appointment in Redwood Building T213D.</span><span style='mso-spacerun:yes'>  </span>Directions can be found here: <a href="http://www.stanford.edu/~balise/FindBalise.htm">www.stanford.edu/~balise/FindBalise.htm</a> </p> <h2><span style='mso-fareast-font-family:"Times New Roman";color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Newsgroup <o:p></o:p></span></h2> <p class=MsoNormal>The class will use a Google group.</p> <h2><span style='mso-fareast-font-family:"Times New Roman";color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Readings<o:p></o:p></span></h2> <p class=MsoNormal style='margin-left:.5in'><span style='mso-fareast-font-family: "Times New Roman"'><a href="http://proquest.safaribooksonline.com/9781599947266"><span class=GramE>The Little SAS Book for Enterprise Guide 4.2</span></a><span class=GramE>.</span><span style='mso-spacerun:yes'>  </span><o:p></o:p></span></p> <p class=MsoNormal style='margin-left:.5in'><span style='mso-bidi-font-weight: bold'><a href="http://proquest.safaribooksonline.com/9781607642282">C<span style='mso-bidi-font-weight:normal'>ommon Statistical Methods for Clinical Research with SAS Examples</span></a></span> </p> <p class=MsoNormal><o:p>&nbsp;</o:p></p> <p class=MsoNormal>Read about SQL vs. data step code here: </p> <p class=MsoNormal style='text-indent:.5in'><a href="http://www2.sas.com/proceedings/sugi31/250-31.pdf">http://www2.sas.com/proceedings/sugi31/250-31.pdf</a> </p> <p class=MsoNormal style='text-indent:.5in'><o:p>&nbsp;</o:p></p> <p class=MsoNormal><span style='mso-fareast-font-family:"Times New Roman"'>Read about numeric precision here:<o:p></o:p></span></p> <p class=MsoNoSpacing style='text-indent:.5in'><span class=object><a href="http://support.sas.com/techsup/technote/ts654.pdf" target="_blank">http://support.sas.com/techsup/technote/ts654.pdf</a></span>. </p> <p class=MsoNormal><span style='mso-fareast-font-family:"Times New Roman"'><o:p>&nbsp;</o:p></span></p> <h2><span style='mso-fareast-font-family:"Times New Roman";color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Grading<o:p></o:p></span></h2> <p class=MsoNormal>Grades will be based on four homework problem sets.&nbsp;&nbsp; If you take the course for 2 units you must pass at least three of the four homework assignments and you must not violate the virus policy below.&nbsp; If you take the course for 3 units you must pass all four assignments.&nbsp; There will be many quick assignments that will not directly affect grades. </p> <h2><span style='mso-fareast-font-family:"Times New Roman";color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Turning in Homework and Viruses<o:p></o:p></span></h2> <p class=MsoNormal>All assignments and homework will be submitted via email to balise at Stanford and hrp223.hw2011&nbsp;at <span class=SpellE>gmail</span>. <span style='color:red'>Any student that sends me a virus (or any other malicious code) will fail the course</span>.&nbsp; There will be no exceptions made.&nbsp; Therefore, you are strongly advised to download the latest version of the <span style='mso-bidi-font-family:Arial'>Sophos Anti-Virus software</span>. If you need virus protection check here <a href="http://www.stanford.edu/services/ess/">http://www.stanford.edu/services/ess/</a> and you can download the software for free. If you have any questions ask! </p> <h2><span style='mso-fareast-font-family:"Times New Roman";color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Late policy<o:p></o:p></span></h2> <p class=MsoNormal>Each of the assignments will be due at the beginning of class on the day specified. </p> <p>That said<span class=GramE>,</span> there are unforeseen emergencies (illness, bike accidents, disk crashes, network troubles, childbirth, etc.). Instead of having to ask for special allowances on an individual basis, I give each of you the privilege of granting yourself a small extension in case of crisis. You will have two late days which you may use to extend the due dates of any assignments without penalty. To avoid any ambiguity, there are seven days in a week and each day ends at 5:00 PM. <span class=GramE>Thus, if your assignment was due on Wednesday but turned in the following Monday before 5:00, that assignment would be five days late.</span> After the grace period is up each assignment is down weighted 20% per day.&nbsp; In all cases, assignments will not be accepted more than one calendar week after the original assignment due date. </p> <h2><span style='mso-fareast-font-family:"Times New Roman";color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Computer Platforms<o:p></o:p></span></h2> <p class=MsoNormal>The programs that you turn in must run on Windows SAS 9.3 and/or Enterprise Guide 4.305.&nbsp; I can provide good support for Windows or a Mac running parallels (<a href="http://www.parallels.com/">http://www.parallels.com/</a>).</p> <h2><span style='color:#D99694;mso-themecolor:accent2;mso-themetint:153; mso-style-textfill-fill-color:#D99694;mso-style-textfill-fill-themecolor:accent2; mso-style-textfill-fill-alpha:100.0%;mso-style-textfill-fill-colortransforms: "lumm=60000 lumo=40000"'>Setting up and configuring SAS and SAS Enterprise Guide:<o:p></o:p></span></h2> <p class=MsoNormal><span style='mso-fareast-font-family:"Times New Roman"'>Pictures showing my SAS 9.3 TS1M0 and EG 4.305 install can be found <a href="http://www.stanford.edu/class/hrp223/2011/InstallingSAS93_20110926.pptx">here</a>. (Updated 2011-09-26 with advice on patching).<o:p></o:p></span></p> <p class=MsoNormal><span style='mso-fareast-font-family:"Times New Roman"'>Notes on configuring SAS Enterprise Guide 4.305 can be found <a href="http://www.stanford.edu/class/hrp223/2011/Configuring_EG_4_305_20110926.pptx">here</a>. (Updated 2011-09-26 to remove old patch info).<o:p></o:p></span></p> <h1><span style='mso-fareast-font-family:"Times New Roman";color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Core Lecture Material <o:p></o:p></span></h1> <p class=MsoNormal><span style='mso-fareast-font-family:"Times New Roman"'>Note: All dates are approximate except HW 4.<o:p></o:p></span></p> <h3><i style='mso-bidi-font-style:normal'><span style='color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Preliminaries</span></i><span style='color:#D99694;mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color: #D99694;mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha: 100.0%;mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'> of Computing at Stanford and an Introduction to SAS Enterprise Guide (Sept 26<sup>st</sup>)<u1:p></u1:p><o:p></o:p></span></h3> <p class=MsoNoSpacing>Reading: The tutorials A, B, and C in TLSB for EG.</p> <p class=MsoNoSpacing><o:p>&nbsp;</o:p></p> <p class=MsoNormal style='margin-left:.5in'>Software somebody should have told you about a long time ago<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in;text-indent:.5in'><a href="https://itservices.stanford.edu/service/ess">Essential Stanford Software</a> (free stuff)<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNormal style='margin-left:.5in'>Tools of the trade<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in;text-indent:.5in'><a href="http://www.stanford.edu/dept/its/cgi-bin/services/software/portal/detail.php?action=view_product&amp;product_id=552">Excel</a><o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in;text-indent:.5in'><a href="http://redcap.stanford.edu/">REDCap</a><o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in;text-indent:.5in'><a href="https://itservices.stanford.edu/service/softwarelic/sas/">SAS or SAS/Enterprise Guide</a> <o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in;text-indent:.5in'><a href="http://cran.r-project.org/">R and R Commander</a><o:p></o:p></p> <u1:p></u1:p> <p class=MsoNormal style='margin-left:.5in'>Other software I use (not officially endorsed by anybody and ask your IT security person for help)<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in;text-indent:.5in'><a href="http://www.crashplan.com/"><span class=SpellE>CrashPlan</span></a></p> <p class=MsoNoSpacing style='margin-left:.5in;text-indent:.5in'><a href="http://www.ultraedit.com/products/ultraedit.html"><span class=SpellE>UltraEdit</span></a><o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in;text-indent:.5in'><a href="http://www.ultraedit.com/products/ultracompare.html">UltraCompare</a><o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in;text-indent:.5in'><a href="http://www.mythicsoft.com/Page.aspx?type=filelocatorpro&amp;page=home">FileLocator Pro</a><o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in;text-indent:.5in'><a href="http://sites.google.com/">Google sites</a></p> <p class=MsoNormal style='margin-left:.5in'>Using SAS Enterprise Guide as a calculator<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing><u1:p>&nbsp;<o:p></o:p></p> </u1:p> <p class=MsoNormal>The PowerPoint slides are <span style='mso-fareast-font-family: "Times New Roman"'><a href="http://www.stanford.edu/class/hrp223/2011/prelim/prelim_223_20110924.pptx">here</a></span>.</p> <p class=MsoNormal><o:p>&nbsp;</o:p></p> <p class=MsoNormal>A video of Dr <span class=SpellE>Zarin</span> talking about submitting structured data to the ClinicalTrials.gov is <a href="http://prsinfo.clinicaltrials.gov/webinars/module1/index.html">here</a>.</p> <h4><span style='color:windowtext'>Assignment 0 is </span><a href="http://www.stanford.edu/class/hrp223/2011/assignment0.html">here</a><span style='color:windowtext'>.<span style='mso-spacerun:yes'>  </span>It should be done before class on September 28<sup>nd</sup>.<o:p></o:p></span></h4> <h3><span style='color:#D99694;mso-themecolor:accent2;mso-themetint:153; mso-style-textfill-fill-color:#D99694;mso-style-textfill-fill-themecolor:accent2; mso-style-textfill-fill-alpha:100.0%;mso-style-textfill-fill-colortransforms: "lumm=60000 lumo=40000"'>Data and Data <i style='mso-bidi-font-style:normal'>Collection</i> (Sept 28<sup>th</sup>  Oct 3<sup>rd</sup>)<o:p></o:p></span></h3> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in'>Using your UNIX space</p> <p class=MsoNoSpacing style='margin-left:.5in'>How </p> <p class=MsoNoSpacing style='margin-left:.5in'>What is a database?<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in'>Critical registry teaks for Excel<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in'>How to organize data in Excel<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Variable names<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dummy records<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in'>Using Excel<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Making tables<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Validation<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Formulas<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Quick counts<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in'>Collecting data in general<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; How to score and store answers<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The value/danger of redundancy<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Using REDCap<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; What is it?<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:.5in'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span class=GramE>How to set it up.</span><o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing><u1:p>&nbsp;<o:p></o:p></p> </u1:p> <p class=MsoNormal>The PowerPoint slides are <span style='mso-fareast-font-family: "Times New Roman"'><a href="http://www.stanford.edu/class/hrp223/2011/collection/collection_223_20110929.pptx">here</a> (updated 2011-10-10 to add in web stuff)</span>.</p> <p class=MsoNormal>The sample .<span class=SpellE>htaccess</span> file is <span style='mso-fareast-font-family:"Times New Roman"'><a href="http://www.stanford.edu/class/hrp223/2011/collection/x.htaccessx">here</a>.</span> (To save the file you may need to right click on the hyperlink and choose something like  Save Target as &  or  Save Link as&  )</p> <p class=MsoNormal>An Enterprise Guide project to easily load data from REDCap is <a href="http://www.stanford.edu/class/hrp223/2011/REDCapLoad20111010.egp">here</a> <span style='mso-fareast-font-family:"Times New Roman"'>(updated 2011-10-10 to be native for EG 4.3)</span>.</p> <h4><span style='color:windowtext'>&nbsp;Assignment 1 is </span><a href="http://www.stanford.edu/class/hrp223/2011/assignment1.html">here</a><span style='color:windowtext'> .<span style='mso-spacerun:yes'>  </span>It should be done before class on Oct 3<sup>th</sup>. <u1:p></u1:p><o:p></o:p></span></h4> <h4><span style='color:windowtext'>Assignment 2 is </span><a href="http://www.stanford.edu/class/hrp223/2011/assignment2.html">here</a><span style='color:windowtext'>.<span style='mso-spacerun:yes'>  </span>It should be done before class on Oct 5<sup>th</sup>.<o:p></o:p></span></h4> <h3><span style='color:#D99694;mso-themecolor:accent2;mso-themetint:153; mso-style-textfill-fill-color:#D99694;mso-style-textfill-fill-themecolor:accent2; mso-style-textfill-fill-alpha:100.0%;mso-style-textfill-fill-colortransforms: "lumm=60000 lumo=40000"'>Working with <i style='mso-bidi-font-style:normal'>Data</i> in Windows (Oct 5<sup>th </sup>- Oct 10<sup>th</sup>)<o:p></o:p></span></h3> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;Reading: Chapters 1, 2 and 4 in TLSB for EG. Skim chapter 3. </p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style='mso-tab-count:2'>                </span></p> <p class=MsoNoSpacing style='text-indent:.5in'>How SAS works in Windows</p> <p class=MsoNoSpacing style='text-indent:.5in'>Types of Files / Suffixes</p> <p class=MsoNoSpacing style='text-indent:.5in'>Libraries <span class=SpellE>vs</span> Folders</p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Loading data from Excel<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Simple subsets</p> <p class=MsoNoSpacing><span style='mso-tab-count:1'>            </span>Creating new variables<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Converting character variables to numeric with the input function</p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Basic numeric summaries </p> <p class=MsoNoSpacing style='text-indent:.5in'>Making better summary tables</p> <p class=MsoNoSpacing>&nbsp;</p> <p class=MsoNormal>The PowerPoint slides are <span style='mso-fareast-font-family: "Times New Roman"'><a href="http://www.stanford.edu/class/hrp223/2011/data/data_223_20111010.pptx">here</a> (updated 2011-10-10 to show table bug  slide 78)</span>.</p> <p class=MsoNoSpacing>An Excel 2007 spreadsheet showing mixed type issues is <a href="http://www.stanford.edu/class/hrp223/2009/data/lettersAndNumbers.xlsx">here</a> and the EG project is <a href="http://www.stanford.edu/class/hrp223/2011/data/mixedTypeExample20111004.egp">here</a>.</p> <p class=MsoNoSpacing>An Excel 2007 spreadsheet with fake drowning data is <a href="http://www.stanford.edu/class/hrp223/2011/data/fakeDrowningData.xls">here</a> and the EG project is <a href="http://www.stanford.edu/class/hrp223/2011/data/SummarizeDrowingData20111004.egp">here</a>.</p> <h3><span style='color:#D99694;mso-themecolor:accent2;mso-themetint:153; mso-style-textfill-fill-color:#D99694;mso-style-textfill-fill-themecolor:accent2; mso-style-textfill-fill-alpha:100.0%;mso-style-textfill-fill-colortransforms: "lumm=60000 lumo=40000"'>Lab 1 (Oct 12<sup>th</sup>-17<sup>th</sup>)<o:p></o:p></span></h3> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Setting up Windows</p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; File extensions</p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Folders</p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Office</p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DOS&nbsp;&nbsp;&nbsp; </p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Configuring SAS Enterprise Guide</p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Application options</p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Keyboard macros</p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Using SAS</p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Libraries</p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Subsets</p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Toy data sets</p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Loading real data sets</p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Simple descriptive statistics and graphics</p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </p> <p class=MsoNormal>The PowerPoint slides are <span style='mso-fareast-font-family: "Times New Roman"'><a href="http://www.stanford.edu/class/hrp223/2011/lab1/lab1_223_20111017.pptx">here</a></span>. </p> <p class=MsoNormal><o:p>&nbsp;</o:p></p> <p class=MsoNormal><b style='mso-bidi-font-weight:normal'><i style='mso-bidi-font-style: normal'>Homework 1 is </i></b><span style='mso-fareast-font-family:"Times New Roman"'><a href="http://www.stanford.edu/class/hrp223/2011/HW1">here</a> </span><b style='mso-bidi-font-weight:normal'><i style='mso-bidi-font-style:normal'>and is due Oct 24<sup>th</sup> before class.<o:p></o:p></i></b></p> <h3><span style='color:#D99694;mso-themecolor:accent2;mso-themetint:153; mso-style-textfill-fill-color:#D99694;mso-style-textfill-fill-themecolor:accent2; mso-style-textfill-fill-alpha:100.0%;mso-style-textfill-fill-colortransforms: "lumm=60000 lumo=40000"'>Beginning Data <i style='mso-bidi-font-style:normal'>Manipulation</i> (Oct 19<sup>th</sup>-Oct 24<sup>th</sup>)<o:p></o:p></span></h3> <p class=MsoNoSpacing>Reading: TLSB for EG 4.2 chapter 4.</p> <p class=MsoNoSpacing><o:p>&nbsp;</o:p></p> <p class=MsoNoSpacing style='margin-left:.5in'>Procedures <span class=SpellE>vs</span> Functions</p> <p class=MsoNoSpacing style='margin-left:.5in'>Code for data step</p> <p class=MsoNoSpacing style='margin-left:.5in'><span style='mso-tab-count:1'>            </span>Labels</p> <p class=MsoNoSpacing style='margin-left:.5in'><span style='mso-tab-count:1'>            </span>Formats</p> <p class=MsoNoSpacing style='margin-left:.5in'>Code for SQL</p> <p class=MsoNoSpacing style='margin-left:.5in'><span style='mso-tab-count:1'>            </span>Labels</p> <p class=MsoNoSpacing style='margin-left:.5in'><span style='mso-tab-count:1'>            </span>Formats</p> <p class=MsoNoSpacing style='margin-left:.5in'>GUI for SQL</p> <p class=MsoNoSpacing style='margin-left:.5in'>Process flow sheets and project organization</p> <p class=MsoNoSpacing style='margin-left:.5in'>Autoexec flow sheets</p> <p class=MsoNoSpacing style='margin-left:.5in'>Creating Formats with the GUI</p> <p class=MsoNoSpacing style='margin-left:.5in'>Data step if-else</p> <p class=MsoNormal><span style='mso-tab-count:1'>            </span>Data step select-when</p> <p class=MsoNormal><span style='mso-tab-count:1'>            </span>SQL case-when-then</p> <p class=MsoNormal><span style='mso-tab-count:1'>            </span>Showing combinations</p> <p class=MsoNormal><o:p>&nbsp;</o:p></p> <p class=MsoNormal>The slides are <span style='mso-fareast-font-family:"Times New Roman"'><a href="http://www.stanford.edu/class/hrp223/2011/manipulation/manipulation_223_20111019a.pptx">here</a></span> and the EG project is <span style='mso-fareast-font-family:"Times New Roman"'><a href="http://www.stanford.edu/class/hrp223/2011/manipulation/manipulation20111019a.egp">here</a></span>.&nbsp;</p> <h3><span style='mso-fareast-font-family:"Times New Roman";color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Inventing and <i style='mso-bidi-font-style:normal'>tweaking</i> data (Oct 26<sup>th</sup>)<o:p></o:p></span></h3> <p class=MsoNoSpacing>Reading: TLSB for EG 4.2 chapters 3, 4 and 9.</p> <p class=MsoNoSpacing style='margin-left:.5in'><span style='mso-fareast-font-family: "Times New Roman"'><o:p>&nbsp;</o:p></span></p> <p class=MsoNoSpacing style='margin-left:.5in'><span style='mso-fareast-font-family: "Times New Roman"'>Creating data <o:p></o:p></span></p> <p class=MsoNoSpacing style='margin-left:.5in'><span style='mso-fareast-font-family: "Times New Roman"'>Recoding values to make data<o:p></o:p></span></p> <p class=MsoNoSpacing style='margin-left:.5in'><span style='mso-fareast-font-family: "Times New Roman"'>Project organization<o:p></o:p></span></p> <p class=MsoNoSpacing style='margin-left:.5in'><span style='mso-fareast-font-family: "Times New Roman"'>Fixing bad values<o:p></o:p></span></p> <p class=MsoNoSpacing style='margin-left:.5in'><span style='mso-fareast-font-family: "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Using formats<o:p></o:p></span></p> <p class=MsoNoSpacing style='margin-left:.5in'><span style='mso-fareast-font-family: "Times New Roman"'>&nbsp;<o:p></o:p></span></p> <p class=MsoNormal>The PowerPoint slides are <span style='mso-fareast-font-family: "Times New Roman"'><a href="http://www.stanford.edu/class/hrp223/2011/tweaking/tweaking_223_20111025.pptx">here</a></span>.</p> <p class=MsoNormal>The Enterprise Guide project is located <a href="http://www.stanford.edu/class/hrp223/2010/lab2/lab2_20101002a.egp">here</a>.&nbsp; </p> <h4><span style='color:windowtext'>Assignment 3 is </span><a href="http://www.stanford.edu/class/hrp223/2010/assignment3/">here</a><span style='color:windowtext'>.<span style='mso-spacerun:yes'>  </span><o:p></o:p></span></h4> <h4><span style='color:windowtext'>Homework 2 is </span><a href="http://www.stanford.edu/class/hrp223/2011/HW2">here</a><span style='color:windowtext'> and the solution is </span><a href="http://www.stanford.edu/class/hrp223/2011/HW2/hw2solution20111121.egp">here</a><span style='color:windowtext'>.<o:p></o:p></span></h4> <h3><i style='mso-bidi-font-style:normal'><span style='color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Merging</span></i><span style='color:#D99694;mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color: #D99694;mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha: 100.0%;mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'> with SQL (Oct 31<sup>st</sup>)<o:p></o:p></span></h3> <p class=MsoNoSpacing>Reading: Tutorial D TLSB for EG 4.2 chapters 4 and 6.</p> <p class=MsoNoSpacing><o:p>&nbsp;</o:p></p> <p class=MsoNoSpacing style='margin-left:.5in'>SQL joins</p> <p class=MsoNoSpacing style='margin-left:.5in'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Inner joins</p> <p class=MsoNoSpacing style='margin-left:.5in'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Left joins</p> <p class=MsoNoSpacing style='margin-left:.5in'>The <span class=GramE>coalesce(</span>) and <span class=SpellE>coalescec</span>() functions<o:p></o:p></p> <p class=MsoNoSpacing style='margin-left:.5in'><u1:p>&nbsp;</u1:p></p> <p class=MsoNormal>The slides are <span style='mso-fareast-font-family:"Times New Roman"'><a href="http://www.stanford.edu/class/hrp223/2011/merging/merging_223_20111030.pptx">here</a></span>.</p> <p class=MsoNoSpacing>An Enterprise Guide project that uses SQL to merge files is <span style='mso-fareast-font-family:"Times New Roman"'><a href="http://www.stanford.edu/class/hrp223/2011/merging/merging20111030.egp">here</a></span>.</p> <h4><span style='color:windowtext'>Assignment 4 is </span><a href="http://www.stanford.edu/class/hrp223/2010/assignment4/">here</a><span style='color:windowtext'>.<span style='mso-spacerun:yes'>  </span><o:p></o:p></span></h4> <h3><span style='color:#D99694;mso-themecolor:accent2;mso-themetint:153; mso-style-textfill-fill-color:#D99694;mso-style-textfill-fill-themecolor:accent2; mso-style-textfill-fill-alpha:100.0%;mso-style-textfill-fill-colortransforms: "lumm=60000 lumo=40000"'>Lab 2 (Nov 2<sup>nd</sup>)<o:p></o:p></span></h3> <u1:p></u1:p> <p class=MsoNoSpacing>Reading: Tutorial D TLSB for EG 4.2 and chapters 4 and 6.</p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </p> <p class=MsoNoSpacing style='text-indent:.5in'>Joins<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Summary functions with SQL<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fixing bad values<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; By using functions like left<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; By recoding <o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='text-indent:.5in'>Finding discrepancies when matches fail<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing><u1:p>&nbsp;<o:p></o:p></p> </u1:p> <p class=MsoNoSpacing>The tasks for today are <a href="http://www.stanford.edu/class/hrp223/2011/lab2/">here</a>.</p> <p class=MsoNoSpacing>More SQL and querying voodoo is covered in a project <a href="http://www.stanford.edu/class/hrp223/2011/lab2/lab2_20111101.egp">here</a>. <o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>This assignment uses information in an Excel workbook that can be found <a href="http://www.stanford.edu/class/hrp223/2009/lab3/islands.xlsx">here</a>.</p> <h3><i style='mso-bidi-font-style:normal'><span style='color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Combine</span></i><span style='color:#D99694;mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color: #D99694;mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha: 100.0%;mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'> with SQL (Nov 7<sup>th</sup>) <o:p></o:p></span></h3> <u1:p></u1:p> <p class=MsoNoSpacing>Reading: Tutorial D TLSB for EG 4.2 and chapter 4 and 6.</p> <p class=MsoNoSpacing><o:p>&nbsp;</o:p></p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQL to select subsets of records from multiple tables<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style='mso-tab-count:1'>   </span>Outer union and/or outer union corresponding  concatenate<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:1.0in'>Union  unique rows from both tables<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:1.0in'>Except  rows that are part of the first query<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing style='margin-left:1.0in'>Intersect  rows common to both queries<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing><u1:p>&nbsp;<span style='color:red'><o:p></o:p></span></p> <p class=MsoNormal></u1:p>The slides are <a href="http://www.stanford.edu/class/hrp223/2011/combine/combine_223_20111106.pptx">here</a>.</p> <p class=MsoNoSpacing>The Enterprise Guide file for today is <a href="http://www.stanford.edu/class/hrp223/2011/combine/combine20111107.egp">here</a>.</p> <h3><span style='color:#D99694;mso-themecolor:accent2;mso-themetint:153; mso-style-textfill-fill-color:#D99694;mso-style-textfill-fill-themecolor:accent2; mso-style-textfill-fill-alpha:100.0%;mso-style-textfill-fill-colortransforms: "lumm=60000 lumo=40000"'>Idiosyncratic SAS stuff like formats and <i style='mso-bidi-font-style:normal'>Macro</i> Language (Nov 9<sup>th</sup>)<o:p></o:p></span></h3> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;<span style='mso-tab-count:1'>         </span><span class=SpellE><span class=GramE>proc</span></span> format library = blah</p> <p class=MsoNoSpacing style='margin-left:.5in'><span class=GramE>options</span> <span class=SpellE>fmtsearch</span> = (blah work);</p> <p class=MsoNoSpacing style='margin-left:.5in'><span class=SpellE><span class=GramE>proc</span></span> <span class=SpellE>cport</span> <span class=SpellE>memtype</span> = all;</p> <p class=MsoNoSpacing style='margin-left:.5in'><span class=SpellE><span class=GramE>proc</span></span> <span class=SpellE>cimport</span></p> <p class=MsoNoSpacing style='margin-left:.5in'><span class=GramE>options</span> <span class=SpellE>nofmterr</span>;</p> <p class=MsoNoSpacing style='margin-left:.5in'>EG prompts</p> <p class=MsoNoSpacing style='margin-left:.5in'><span class=GramE>macro</span> variables</p> <p class=MsoNoSpacing><span style='mso-tab-count:1'>            </span>%macro %mend</p> <p class=MsoNoSpacing><span style='mso-tab-count:1'>            </span>Examples of macros</p> <p class=MsoNoSpacing><span style='mso-tab-count:2'>                        </span>Dot/bar plot</p> <p class=MsoNoSpacing><span style='mso-tab-count:2'>                        </span><span class=SpellE>Quantile</span> plot</p> <p class=MsoNoSpacing><span style='mso-tab-count:2'>                        </span>Calculating sensitivity, specificity, PPV, NPV</p> <p class=MsoNoSpacing><span style='mso-tab-count:2'>                        </span>Binomial probabilities</p> <p class=MsoNoSpacing><span style='mso-tab-count:1'>            </span>&nbsp;</p> <p class=MsoNormal>The slides are <a href="http://www.stanford.edu/class/hrp223/2011/macro/macro_223_20111109.pptx">here</a>.</p> <p class=MsoNoSpacing>An Enterprise Guide project showing macros is <a href="http://www.stanford.edu/class/hrp223/2011/macro/macro20111109.egp">here</a>.</p> <h4><span style='color:windowtext'>Homework 3 is </span><a href="http://www.stanford.edu/class/hrp223/2011/HW3">here</a><span style='color:windowtext'> and is due before class on Nov 28<sup>th</sup><o:p></o:p></span></h4> <h3><i style='mso-bidi-font-style:normal'><span style='color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Grouped</span></i><span style='color:#D99694;mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color: #D99694;mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha: 100.0%;mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'> Data (Nov 14<sup>th</sup>)<o:p></o:p></span></h3> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; By processing<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Retain statements<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <o:p></o:p></p> <u1:p></u1:p> <p class=MsoNormal>The slides will be <a href="http://www.stanford.edu/class/hrp223/2011/grouped/grouped_223_20111112.pptx">here</a>.</p> <p class=MsoNoSpacing>An Enterprise Guide project showing working with grouped data is <a href="http://www.stanford.edu/class/hrp223/2011/grouped/grouped20111112.egp">here</a>.&nbsp;&nbsp; </p> <h4><span style='color:windowtext'>Assignment 5 is </span><a href="http://www.stanford.edu/class/hrp223/2011/assignment5/">here</a><span style='color:windowtext'> and the solution from class is </span><a href="http://www.stanford.edu/class/hrp223/2011/assignment5/assignment5solution.egp">here</a><span style='color:windowtext'>.<span style='mso-spacerun:yes'>  </span><o:p></o:p></span></h4> <h3><i style='mso-bidi-font-style:normal'><span style='color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Database</span></i><span style='color:#D99694;mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color: #D99694;mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha: 100.0%;mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'> issues (Nov 16<sup>th</sup>)<o:p></o:p></span></h3> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;<span style='mso-tab-count:1'>         </span>Queries and corrections when data is not normalized<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Normalizing data with arrays and loops in a data step</p> <p class=MsoNormal><o:p>&nbsp;</o:p></p> <p class=MsoNormal>The slides will are <a href="http://www.stanford.edu/class/hrp223/2011/database/database_223_20111112.pptx">here</a>.</p> <p class=MsoNoSpacing>An Enterprise Guide project is <a href="http://www.stanford.edu/class/hrp223/2011/database/databaseWide20111112.egp">here</a>.</p> <p class=MsoNoSpacing>A dataset is <a href="http://www.stanford.edu/class/hrp223/2011/database/wide.xlsx">here</a>.</p> <p class=MsoNoSpacing><o:p>&nbsp;</o:p></p> <h3><i style='mso-bidi-font-style:normal'><span style='color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Output Delivery System </span></i><span style='color:#D99694;mso-themecolor:accent2; mso-themetint:153;mso-style-textfill-fill-color:#D99694;mso-style-textfill-fill-themecolor: accent2;mso-style-textfill-fill-alpha:100.0%;mso-style-textfill-fill-colortransforms: "lumm=60000 lumo=40000"'>(Nov 28<sup>th</sup>)<o:p></o:p></span></h3> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;<span style='mso-tab-count:1'>         </span>Limiting out output from SAS</p> <p class=MsoNoSpacing style='text-indent:.5in'>How SAS creates different types of output</p> <p class=MsoNoSpacing style='text-indent:.5in'>Writing output to different file types</p> <p class=MsoNoSpacing style='text-indent:.5in'>SAS output table names</p> <p class=MsoNormal><o:p>&nbsp;</o:p></p> <p class=MsoNormal>The slides will are <a href="http://www.stanford.edu/class/hrp223/2011/ods/ods_223_20111127.pptx">here</a>.</p> <p class=MsoNoSpacing>An Enterprise Guide project is <a href="http://www.stanford.edu/class/hrp223/2011/ods/ods20111125.egp">here</a>.</p> <h3><i style='mso-bidi-font-style:normal'><span style='color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Graphics</span></i><span style='color:#D99694;mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color: #D99694;mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha: 100.0%;mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'> Data (Nov 28<sup>th</sup>, Nov 30<sup>th</sup>, Dec <span class=GramE>5<sup>th</sup> )</span><o:p></o:p></span></h3> <p class=MsoNoSpacing>Reading: TLSB for EG chapter 10 </p> <p class=MsoNoSpacing style='text-indent:.5in'><o:p>&nbsp;</o:p></p> <p class=MsoNoSpacing style='text-indent:.5in'>What makes a bad graphic bad<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The gurus of data visualization</p> <p class=MsoNoSpacing><span style='mso-tab-count:1'>            </span>A good graphic</p> <p class=MsoNoSpacing><span style='mso-tab-count:2'>                        </span><span class=SpellE>Sgplot</span> <span class=SpellE>vbox</span> inset<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Visualizing categorical data<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Bar charts<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dot plot<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Waffle plots<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Visualizing continuous data<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Histograms<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Box <span class=SpellE>plos<u1:p></u1:p></span></p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Violin plot<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; How to get image formats for publication<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Working with the SAS ODS<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ODS Statistical Graphics<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SAS Graphics Editor</p> <p class=MsoNoSpacing><span style='mso-tab-count:2'>                        </span><span class=SpellE><span class=GramE>ods</span></span> listing <span class=SpellE>sge</span> = on;<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Setting up R <o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span class=SpellE>Tinn</span>-R<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PERL&nbsp; <o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; High quality SAS graphics<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span class=SpellE>Sgplot</span> <span class=SpellE>hbox</span> / category =<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sgplot scatter<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span class=SpellE>Sgplot</span> <span class=SpellE>reg</span> / group =<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sgplot histogram<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span class=SpellE>Sgpanel</span> <span class=SpellE>panelby</span> histogram<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <span class=SpellE>Sgpanel</span> <span class=SpellE>panelby</span> scatter<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Lattice plots in SAS<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Ods graphics on<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Selecting a subset of ODS graphics<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ODS statistical graphics with many elements<o:p></o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Truly custom <span class=GramE>ODS</span> statistical graphics</p> <p class=MsoNoSpacing><span style='mso-tab-count:2'>                        </span><span class=SpellE><span class=GramE>proc</span></span> template;</p> <p class=MsoNoSpacing><span style='mso-tab-count:3'>                                    </span><span class=GramE>define</span> style <span class=SpellE>sexE</span>;</p> <p class=MsoNoSpacing><span style='mso-tab-count:3'>                                    </span><span class=GramE>parent</span> = <span class=SpellE>styles.Statistical</span>;</p> <p class=MsoNoSpacing><span style='mso-tab-count:4'>                                                </span><span class=GramE>style</span> graphdata1 / <span class=SpellE>contrastColor</span>=pink <span class=SpellE>markersymbol</span> = &quot;star&quot;; </p> <p class=MsoNoSpacing><span style='mso-tab-count:4'>                                                </span><span class=GramE>style</span> graphdata2 / <span class=SpellE>contrastColor</span>=blue <span class=SpellE>markersymbol</span> = &quot;plus&quot;; </p> <p class=MsoNoSpacing><span style='mso-tab-count:3'>                                    </span><span class=GramE>end</span>;</p> <p class=MsoNoSpacing style='margin-left:.5in;text-indent:.5in'><span class=GramE>run</span>;</p> <p class=MsoNoSpacing style='margin-left:.5in;text-indent:.5in'><span class=GramE>ods</span> listing style = <span class=SpellE>sexE</span>;</p> <p class=MsoNoSpacing><span style='mso-tab-count:1'>            </span>Making big pictures: </p> <p class=MsoNoSpacing style='margin-left:.5in;text-indent:.5in'><span class=SpellE><span class=GramE>goptions</span></span> <span class=SpellE>hsize</span>=11in <span class=SpellE>vsize</span>=8.5in;</p> <p class=MsoNoSpacing style='margin-left:.5in;text-indent:.5in'><span class=SpellE>ods</span> graphics / width=11in height=8.5in;</p> <p class=MsoNoSpacing style='margin-left:.5in;text-indent:.5in'><o:p>&nbsp;</o:p></p> <u1:p></u1:p> <p class=MsoNoSpacing>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <o:p></o:p></p> <u1:p></u1:p> <p class=MsoNormal><span style='mso-fareast-font-family:"Times New Roman"'>Notes on graphics in SAS 9.3 can be found </span><a href="http://www.stanford.edu/class/hrp223/2011/graphics/graphics_223_20111130.pptx">here</a><span style='mso-fareast-font-family:"Times New Roman"'>.<o:p></o:p></span></p> <p class=MsoNoSpacing>Enterprise Guide projects are <a href="http://www.stanford.edu/class/hrp223/2011/graphics/graphics20111125.egp">here</a> and <a href="http://www.stanford.edu/class/hrp223/2011/graphics/olderGraphics20111125.egp">here</a>.</p> <p class=MsoNoSpacing>SAS code showing <span class=GramE>ods</span> graphics can be found <a href="http://www.stanford.edu/class/hrp223/2010/graphics/heart.sas">here</a>.</p> <p class=MsoNoSpacing>SAS code showing setting colors in graphics with style templates is <a href="http://www.stanford.edu/class/hrp223/2010/graphics/scatterRegExample20101201.sas">here</a>.</p> <p class=MsoNoSpacing>R code for common R graphics is <a href="http://www.stanford.edu/class/hrp223/2009/graphics/graphics.r">here</a> along with data sets <a href="http://www.stanford.edu/class/hrp223/2010/graphics/NFL.xls">here</a> and <a href="http://www.stanford.edu/class/hrp223/2010/graphics/PAIN.xls">here</a>.</p> <p class=MsoNoSpacing>R code for categorical data is <a href="http://www.stanford.edu/class/hrp223/2009/graphics/categorical.r">here</a>. </p> <h3><span style='color:#D99694;mso-themecolor:accent2;mso-themetint:153; mso-style-textfill-fill-color:#D99694;mso-style-textfill-fill-themecolor:accent2; mso-style-textfill-fill-alpha:100.0%;mso-style-textfill-fill-colortransforms: "lumm=60000 lumo=40000"'>Final Summary (Dec 7<sup>th</sup>)<o:p></o:p></span></h3> <u1:p></u1:p> <p class=MsoNormal>The slides are <a href="http://www.stanford.edu/class/hrp223/2011/final/final_223_20111127.pptx">here</a>.</p> <p class=MsoNormal>Solution to HW3 will be here.</p> <h4><span style='color:windowtext'>Homework 4 is </span><a href="http://www.stanford.edu/class/hrp223/2011/HW4/">here</a> <span style='color:windowtext'>and is due Dec 16 before 11:31 am.<o:p></o:p></span></h4> <h2><span style='mso-fareast-font-family:"Times New Roman";color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Other stuff <o:p></o:p></span></h2> <p class=MsoNormal><span style='mso-fareast-font-family:"Times New Roman"'>SAS 2011 keyboard macros can be found <a href="http://www.stanford.edu/class/hrp223/2010/macros2010a.kmf">here</a>. </span></p> <p class=MsoNormal><span style='mso-fareast-font-family:"Times New Roman"'>A set of useful links can be found <a href="http://www.stanford.edu/class/hrp223/2008/usefulLinks.html">here</a>.<o:p></o:p></span></p> <h2><span style='mso-fareast-font-family:"Times New Roman";color:#D99694; mso-themecolor:accent2;mso-themetint:153;mso-style-textfill-fill-color:#D99694; mso-style-textfill-fill-themecolor:accent2;mso-style-textfill-fill-alpha:100.0%; mso-style-textfill-fill-colortransforms:"lumm=60000 lumo=40000"'>Other Books <o:p></o:p></span></h2> <p class=MsoNormal><span style='mso-fareast-font-family:"Times New Roman"'>(You can get many of these from the Stanford library but preview them on Amazon or books.google.com)<o:p></o:p></span></p> <p class=MsoNormal><span style='mso-fareast-font-family:"Times New Roman"'>A few of my old favorite books are listed <a href="http://www.amazon.com/lm/RHFF8RFBWIBL2/ref=cm_pdp_lm_title_1">here</a> <o:p></o:p></span></p> <p class=MsoNormal><span style='mso-fareast-font-family:"Times New Roman"'>My favorite scientific visualization books are <a href="http://www.amazon.com/lm/R391ZNGMU7WL2K/ref=cm_pdp_lm_title_2">here</a>.<o:p></o:p></span></p> </div> </body> </html>