1
2'6�IRU�'DWD�$QDO\VLV��2XWSXW�$V�<RX�/LNH�,W�LQ�9HUVLRQ��
&KULVWRSKHU�5��2OLQJHU
5DQGDOO�'��7RELDV
6$6�,QVWLWXWH�,QF���&DU\�1&
$EVWUDFW
7KLV� SDSHU� GLVFXVVHV� DGYDQFHV� PDGH� LQ� WKH� RXWSXW� JHQHUDWHG� E\� DOO� 9HUVLRQ� �� 6$6®� 6RIWZDUH
SURFHGXUHV�� � 1HZ� IHDWXUHV� SURYLGHG� E\� WKH� 2XWSXW� 'HOLYHU\� 6\VWHP� �2'6�� LQFOXGH� DXWRPDWLF
UHQGHULQJ�RI�SURFHGXUH�RXWSXW�LQ�+70/�IRU�WKH�ZHE��ULFK�WH[W��3RVWVFULSW�RU�3&/�IRUPDW��RXWSXW�GDWD
VHWV� IURP�DQ\�SULQWHG�RXWSXW��DQG� WKH�DELOLW\� WR�HGLW� WKH� ORRN�DQG� IHHO�RI�PRVW�RXWSXW�� �2'6� DOVR
VXSSRUWV�DOO� OHJDF\� OLQH�PRGH�SULQWLQJ�DQG�VXSSRUWV�D�GRFXPHQW� IHDWXUH� WR� DOORZ�SRVW�SURFHGXUH
UHSOD\LQJ� RI� RXWSXW�� 7KLV� WDON� LQWURGXFHV�2'6� IHDWXUHV� WR�EH�GHOLYHUHG� LQ�9HUVLRQ��� DQG� SURYLGHV
VRPH�FRQFUHWH�H[DPSOHV�RI�KRZ�GDWD�DQDO\VWV�DQG�VWDWLVWLFLDQV�FDQ�WDNH�DGYDQWDJH�RI�WKH�IHDWXUH�VHW
SURYLGHG�E\�2'6�
0RWLYDWLRQ
(YHU\�6$6�XVHU�NQRZV�DQG�ORYHV�WKH�OLVWLQJ�ILOH��WKH�YHKLFOH�IRU�DOO�SULQWHG�6$6�RXWSXW�IRU�PRUH�WKDQ
WZR�GHFDGHV��:KLOH� IDPLOLDU�� WKH� OLVWLQJ� ILOH�KDV� LWV� OLPLWDWLRQV��)RU�VWDUWHUV��RXWSXW� LV� UHVWULFWHG� WR
PRQRVSDFH�IRQWV�RQO\��2Q�WRS�RI�WKDW��WKHUH�LVQ·W�DQ\�WDE�LQIRUPDWLRQ�LQ�WKH�OLVWLQJ�WR�OHW�6$6�XVHUV
SDUVH�D� WDEOH� WKHPVHOYHV�� ,QGXVWULRXV�XVHUV�KDYH�EHHQ� IRUFHG� WR�XVH�DOO� VRUWV�RI� WULFNV� WR�JHW� 6$6
RXWSXW�LQWR�D�GRFXPHQW�HGLWRU�OLNH�0LFURVRIW�:RUG�
7KH�OLPLWDWLRQV�RI�WKH�6$6�OLVWLQJ�VWHPPHG�IURP�WKH�IDFW�WKDW�HDFK�SURFHGXUH�UHQGHUHG�LWV�RXWSXW�WR
WKH�OLVWLQJ�ILOH�RQH�OLQH�DW�D�WLPH��7KLV�RXWSXWWLQJ�WHFKQLTXH�PDGH�LW�YLUWXDOO\�LPSRVVLEOH�WR�DGG�QHZ
RXWSXW�GHVWLQDWLRQV��OLNH�+70/�DQG�57)��WR�WKH�6$6�6\VWHP�DV�HDFK�SURFHGXUH�ZDV�ZHG�WR�LWV�RZQ
LQWHUQDO�SULQW�URXWLQHV��$GGLQJ�QHZ�RXWSXW�GHVWLQDWLRQV�ZRXOG�UHTXLUH�HDFK�SURFHGXUH�WR�VXSSRUW�WKH
RXWSXW�GHVWLQDWLRQ�H[SOLFLWO\��2QH�RI�WKH�PDLQ�JRDOV�RI�2'6�ZDV�WR�JHW�WKH�VWDWLVWLFDO�SURFHGXUHV�RXW
RI�WKH�RXWSXW�IRUPDWWLQJ�EXVLQHVV�³�DQG��LQGHHG��RQH�RI�WKH�QLFH�WKLQJV�DERXW�9HUVLRQ���2'6�LV�WKDW
LW�FRPSOHWHO\�UHPRYHV�WKH�EXUGHQ�RI�DGGLQJ�QHZ�RXWSXW�GHVWLQDWLRQV�IURP�WKH�SURFHGXUHV�
+RZHYHU��WKH�OLVWLQJ�ILOH�LV�KDQG\�IRU�UHDGLQJ�DV�D�IODW�ILOH��,Q�IDFW��LW�LV�WRR�KDQG\��+DYH�\RX�HYHU�KDG
WR�UHDG�D�OLVWLQJ�ILOH�ZLWK�D�352&�35,1772�DQG�D��B18//B�'$7$�VWHS�MXVW�WR�UHDUUDQJH�VRPH�RXWSXW
RU� WR�JUDE�VRPH�VWDWLVWLF� WKDW�ZDVQ·W�RQ� WKH�RXWSXW�GDWD�VHW"� �'LG�\RX�HYHU� WKLQN� WR�\RXUVHOI� WKDW
WKHUH�VKRXOG�EH�D�EHWWHU�D�ZD\�WR�GR�WKHVH�VRUWV�RI�WKLQJV"
(QWHU�2'6��7KH�IROORZLQJ�WDEOH��JHQHUDWHG�E\�WKH�565(*�SURFHGXUH��ZDV�GURSSHG�LQWR�WKLV�GRFXPHQW
ZLWK�QR�LQWHUPHGLDWH�WUDQVODWLRQ��2WKHU�2'6�IHDWXUHV�PDNH�LW�SRVVLEOH�WR�FUHDWH�D�GDWD�VHW�GLUHFWO\
IURP�WKLV�SLHFH�RI�RXWSXW�
Factor DF Sum of Squares Mean Square F Value Pr > F
Temperature 4 5258.016026 1314.504006 2.60 0.1613
GasLiquidRatio 4 11045 2761.150641 5.46 0.0454
PackingHeight 4 3813.016026 953.254006 1.89 0.2510
Figure 1: RSREG output produced as RTF
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
2
7KH�2'6�6ROXWLRQ
2'6�SURYLGHV�D�PRUH�IOH[LEOH�PHFKDQLVP�IRU�SURFHGXUHV�WR�SURGXFH�RXWSXW��,QVWHDG�RI�ZULWLQJ�WR�WKH
OLVWLQJ�ILOH�GLUHFWO\��WKH�SURFHGXUH�FUHDWHV�DQ�RXWSXW�REMHFW��IRU�HDFK�SLHFH�RI�RXWSXW�WR�EH�GLVSOD\HG�
(YHU\�WDEOH��SORW��DQG�FKDUW�LV�WKXV�D�VHSDUDWH�HQWLW\�LQ�WKH�V\VWHP��(DFK�RXWSXW�REMHFW�FDQ�EH�IXUWKHU
EURNHQ�GRZQ�LQWR�WZR�FRPSRQHQW�SDUWV�
• D�GDWD�FRPSRQHQW��WKH�FROOHFWLRQ�RI�UDZ�QXPEHUV�DQG�FKDUDFWHUV�FRPSULVLQJ�WKH�FRQWHQWV�RI�WKH
RXWSXW
• D� WHPSODWH� FRPSRQHQW�� WKH�GHVFULSWLRQ�RI�ZKDW� WKH�RXWSXW� LV� VXSSRVHG� WR� ORRN� OLNH�ZKHQ� WKH
GDWD�LV�IRUPDWWHG�DQG�DUUDQJHG�RQ�D�SDJH
(DFK�SLHFH�RI�RXWSXW�H[LVWV�LQ�D�ORJLFDO�KLHUDUFK\�RI�RXWSXW�GLUHFWRULHV�WKDW�LV�FUHDWHG�DV�\RXU�6$6�MRE
H[HFXWHV��)RU�LQVWDQFH��FRQVLGHU�WKH�IROORZLQJ�H[DPSOH�
data a; do a = 1 to 4; do b = 1 to 4; do c = 1 to 4; n = int(6*ranuni(1)); do i = 1 to n; y = a + b + rannor(1); x = a * b / rannor(3); output; end; end; end; end; end; run;
proc glm data=a; class a b c; model x y = a|b|c / ss1 ; run;
7KH�RXWSXW�IURP�WKH�*/0�SURFHGXUH�LV�DUUDQJHG�LQ�WKH�IROORZLQJ�RXWSXW�GLUHFWRU\�VWUXFWXUH��,WHPV�LQ
EROG�DUH�GLUHFWRULHV�DQG�LWHPV�LQ�LWDOLFV�DUH�RXWSXW�REMHFW�QDPHV�
GLM Data Class Levels Number of Observations Analysis of Variance Dependent Variable X Overall ANOVA Fit Statistics Type I Model ANOVA Dependent Variable Y Overall ANOVA Fit Statistics Type I Model ANOVA
(YHU\�SLHFH�RI�RXWSXW�WKDW�D�SURFHGXUH�SURGXFHV�KDV�D�QDPH��D�ODEHO��DQG�D�GLUHFWRU\�SDWK�GHVFULELQJ
ZKHUH�WKH�RXWSXW�UHVLGHV�LQ�WKH�GLUHFWRU\�VWUXFWXUH�
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
3
2XWSXW� REMHFWV� DUH� FUHDWHG� E\� WKH� SURFHGXUH�� DQG� WKH\� DUH� UHQGHUHG� EDVHG� RQ� WKH� RXWSXW
GHVWLQDWLRQV� WKDW� WKH�XVHU�KDV�UHTXHVWHG�� �$Q�RXWSXW�GHVWLQDWLRQ�GHVFULEHV� WKH� W\SH�RI� IRUPDWWLQJ
UHTXHVWHG�IRU�WKH�RXWSXW��+70/��57)��DQG�VR�IRUWK���<RX�FDQ�FRQWURO�ZKLFK�RXWSXW�GHVWLQDWLRQV�DUH�LQ
HIIHFW�E\�XVLQJ�WKH�2'6�VWDWHPHQW�RU�E\�VHOHFWLQJ�RXWSXW�GHVWLQDWLRQV�LQ�WKH�6$6�([SORUHU�
7KUHH� QHZ� IHDWXUHV� DIIRUG� XVHUV� FRQWURO� RI� 2'6� RXWSXW�� WKH� 2'6� VWDWHPHQW�� WKH� 7(03/$7(
SURFHGXUH��DQG�WKH�2'6�2XWSXW�'RFXPHQW�
• 8VLQJ�WKH�2'6�VWDWHPHQW��\RX�FDQ�VHW�RXWSXW�GHVWLQDWLRQ�DWWULEXWHV��VHOHFW�RU�H[FOXGH�LQGLYLGXDO
SLHFHV� RI� RXWSXW�� UHTXHVW� WKDW�SLHFHV� RI� RXWSXW� EH� WXUQHG� LQWR� D� GDWD� VHW�� DQG� FRQWURO� ZKLFK
WHPSODWHV�VKRXOG�EH�XVHG�IRU�UHQGHULQJ�SXUSRVHV�
• 7KH�7(03/$7(�SURFHGXUH� HQDEOHV� \RX� WR� VSHFLI\� WKH� DWWULEXWHV� WKDW� GHVFULEH� KRZ� D� SLHFH� RI
RXWSXW�VKRXOG�EH� IRUPDWWHG��DV�ZHOO�DV�VSHFLI\�VW\OLVWLF�HOHPHQWV� IRU� RXWSXW� GHVWLQDWLRQV��<RX
FDQ�VSHFLI\�FHOO�IRUPDWV�DQG�KHDGHUV��FKDQJH�FROXPQ�RUGHULQJ��VSHFLI\�FRORUV�DQG�IRQWV��DGG�*,)
LPDJHV�WR�+70/��DQG�VSHFLI\�YDULRXV�RWKHU�IRUPDWWLQJ�DQG�VW\OLVWLF�FKDUDFWHULVWLFV�
• $QG��ILQDOO\��WKHUH�LV�VXSSRUW�IRU�D�SHUVLVWHQW�IRUP�RI�\RXU�RXWSXW��7KH�2'6�2XWSXW�'RFXPHQW
HQDEOHV�\RX�WR�VDYH�\RXU�RXWSXW�LQ�UDZ�IRUP��PRGLI\�WKH�DSSHDUDQFH�RI�D�SLHFH�RI�RXWSXW��DQG
UHSOD\� LW� WR� DQ\� RXWSXW� GHVWLQDWLRQ�� 7KH� 'RFXPHQW� DOVR� HQDEOHV� \RX� WR� SLFN� DQG� FKRRVH
LQGLYLGXDO�SLHFHV�RI�RXWSXW�DQG�FRPELQH�WKHP�LQWR�PRUH�FRPSOH[�UHSRUWV��<RX�FDQ�GR�DOO�RI�WKLV
ZLWKRXW�UHUXQQLQJ�WKH�SURFHGXUH�WKDW�LQLWLDOO\�FUHDWHG�WKH�RXWSXW�
'HWDLOV
$OO�SURFHGXUHV�KDYH�EHHQ�FRQYHUWHG�WR�SURGXFH�WKHLU�RXWSXW�DV�2'6�RXWSXW�REMHFWV���<RX�FDQ�FRQWURO
WKHVH� REMHFWV� DQG� LQWHUDFW� ZLWK�2'6� LQ� D� YDULHW\� RI� ZD\V�� 7KH� SULPDU\� ZD\V� WR� LQWHUDFW� ZLWK� WKH
V\VWHP�DUH�WKURXJK�WKH�2'6�VWDWHPHQW��WKH�6$6�([SORUHU��352&�7(03/$7(��DQG�352&�287387�
7KH�2'6�6WDWHPHQW
7KH�2'6�VWDWHPHQW�LV�D�JOREDO�VWDWHPHQW�WKDW�HQDEOHV�\RX�WR�FRQWURO�2'6�LQ�EDWFK�PRGH���8VLQJ�WKH
2'6�VWDWHPHQW��\RX�FDQ�VSHFLI\�RSWLRQV� IRU�RXWSXW�GHVWLQDWLRQV�� FRQWURO� WKH� WHPSODWHV� WKDW�DUH� LQ
HIIHFW�IRU�\RXU�6$6�MRE��DQG�VHOHFW�DQG�H[FOXGH�YDULRXV�SLHFHV�RI�RXWSXW��<RX�FDQ�DOVR�XVH�WKH�2'6
VWDWHPHQW�WR�GLVSOD\�WKH�QDPHV�RI�LQGLYLGXDO�SLHFHV�RI�RXWSXW�DV�WKH\�DUH�JHQHUDWHG�
2XWSXW�'HVWLQDWLRQV
(DFK� RXWSXW� GHVWLQDWLRQ� JHQHUDWHV� D� SDUWLFXODU� W\SH� RI� RXWSXW�� +70/�� RXWSXW� GDWD� VHWV�� DQG
3RVWVFULSW� DUH� DOO� VHSDUDWH� RXWSXW� GHVWLQDWLRQV�� 2'6� LV� GHVLJQHG� WR� DOORZ� PXOWLSOH� RXWSXW
GHVWLQDWLRQV�WR�EH�DFWLYH�DW�WKH�VDPH�WLPH��$�VLQJOH�6$6�MRE�FDQ��WKHUHIRUH��FUHDWH�ERWK�+70/�DQG
WKH�6$6�OLVWLQJ�FRQFXUUHQWO\�
7KH�LQLWLDO�UHOHDVH�RI�9HUVLRQ���ZLOO�FRQWDLQ�VXSSRUW�IRU�WKH�IROORZLQJ�RXWSXW�GHVWLQDWLRQV�
• WKH�VWDQGDUG�6$6�OLVWLQJ
• +70/�IRU�WKH�:HE
• RXWSXW�GDWD�VHWV
1 6RPH�SURFHGXUHV�DUH�PRUH�2'6�FRPSOLDQW�WKDQ�RWKHUV��7KH�3/27�SURFHGXUH��IRU�LQVWDQFH��GRHV�QRW
VHSDUDWH�GDWD�DQG�WHPSODWH� LQIRUPDWLRQ�� ,W�UHOLHV�RQ�ZKDW�LV�NQRZQ�DV�´EDWFK�PRGHµ���WKH�ROG�6$6
OLVWLQJ�LV�FDSWXUHG�DQG�SDVVHG�DORQJ�DV�WKH�RXWSXW�REMHFW·V�GDWD�
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
4
6RRQ�DIWHU�WKH�LQLWLDO�UHOHDVH�RI�9HUVLRQ����6$6�,QVWLWXWH�ZLOO�EH�UHOHDVLQJ�VXSSRUW�IRU� WKH�IROORZLQJ
RXWSXW�GHVWLQDWLRQV�
• WKH�2'6�2XWSXW�'RFXPHQW�IRU�PRGLI\LQJ�DQG�UHSOD\LQJ�RXWSXW�ZLWKRXW�UHUXQQLQJ�WKH�SURFHGXUH
WKDW�FUHDWHG�LW
• 57)�IRU�LQFOXVLRQ�LQ�0LFURVRIW�:RUG
• 36�DQG�3&/�IRU�KLJK�ILGHOLW\�SULQWHUV
• SRVVLEO\�6*0/�DQG�/D7H[
<RX�VHOHFW�DQ�RXWSXW�GHVWLQDWLRQ�E\�VSHFLI\LQJ�WKH�DSSURSULDWH�2'6�VWDWHPHQW�RSWLRQV�EHIRUH�\RXU
6$6�MRE�LV�H[HFXWHG�� �$V�DQ�H[DPSOH�� FRQVLGHU� WKH�IROORZLQJ�VWDWHPHQWV� WKDW�FRPSXWH�D�UHVSRQVH
VXUIDFH� UHJUHVVLRQ� DQDO\VLV� DQG� � UHQGHU� WKH� UHVXOWV� DV� 57)�� 7KH� WDEOH� SURGXFHG� E\� WKLV� MRE� LV
LQFOXGHG�DW�WKH�VWDUW�RI�WKLV�SDSHU��)LJXUH����
ods rtf file=’example.rtf’ ; ods select factorANOVA;
data a; input Odor Temperature GasLiquidRatio PackingHeight @@; datalines; 66 -1 -1 0 39 1 -1 0 43 -1 1 0 49 1 1 0 58 -1 0 -1 17 1 0 -1 -5 -1 0 1 -40 1 0 1 65 0 -1 -1 7 0 1 -1 43 0 -1 1 -22 0 1 1 -31 0 0 0 -35 0 0 0 -26 0 0 0 run;
proc rsreg; model odor=Temperature GasLiquidRatio PackingHeight; run;
ods rtf close;
6HH�WKH�´([DPSOHVµ�VHFWLRQ�IRU�VRPH�H[DPSOHV�RI�RWKHU�RXWSXW�GHVWLQDWLRQV�
7UDFLQJ�DQG�6HOHFWLQJ�2XWSXW
<RX�PD\�KDYH�QRWLFHG�LQ�WKH�SUHYLRXV�H[DPSOH�WKDW�\RX�FDQ�VHOHFW�DQG�H[FOXGH�LQGLYLGXDO�SLHFHV�RI
RXWSXW� ZLWK� WKH� 2'6� VWDWHPHQW�� (DFK� SLHFH� RI� RXWSXW� KDV� DVVRFLDWHG� ZLWK� LW� D� QDPH�� D� ODEHO�� D
GLUHFWRU\� SDWK�� DQG� D� WHPSODWH� SDWK�� <RX� FDQ� GLVSOD\� WKLV� LQIRUPDWLRQ� E\� XVLQJ� WKH� 2'6� 75$&(
RSWLRQ��2QFH�\RX�NQRZ�WKH�QDPH�RU�ODEHO�RI�D�SLHFH�RI�RXWSXW��\RX�FDQ�VHOHFW�LW��H[FOXGH�LW��RU�WXUQ�LW
LQWR�D�6$6�GDWD�VHW���6HH�WKH�´([DPSOHVµ�VHFWLRQ�IRU�D�GHPRQVWUDWLRQ�
7KH�6$6�([SORUHU
7KH�6$6�([SORUHU�LV�D�QHZ�IHDWXUH�LQ�WKH�9HUVLRQ���6$6�'LVSOD\�0DQDJHU�WKDW�HQDEOHV�\RX�WR�H[SORUH
WKH�YDULRXV�SLHFHV�DQG�SDUWV�RI�WKH�6$6�6\VWHP��3DUW�RI�WKH�6$6�([SORUHU� LV�WKH�5(68/76�QRGH��7KH
5(68/76�QRGH�UHWDLQV�D�UXQQLQJ�UHFRUG�RI� WKH�RXWSXW�GLUHFWRU\�KLHUDUFK\� WKDW� LV�SURGXFHG�ZKHQ�D
6$6� MRE� LV� H[HFXWHG�� )LJXUH� �� VKRZV� WKH�([SORUHU�ZLWK� WKH� UHVXOWV� IRU�DQ� DQDO\VLV� RI� YDULDQFH�� %\
FOLFNLQJ�RQ�WKH�RXWSXW�ODEHOV�LQ�WKH�([SORUHU�\RX�FDQ�OLQN�GLUHFWO\�WR�WKH�RXWSXW�LQ�WKH�RXWSXW�ZLQGRZ
RU�LQ�DQ�+70/�EURZVHU��7KH�LWHPV�RQ�WKH�OHIW�KDQG�VLGH�RI�WKH�5(68/76�QRGH�DUH�RXWSXW�GLUHFWRULHV�
7KH�LWHPV�RQ�WKH�ULJKW�KDQG�VLGH�RI�WKH�5(68/76�QRGH�DUH�SLHFHV�RI�RXWSXW��WDEOHV�LQ�WKLV�FDVH��
7KH�([SORUHU�DOVR�HQDEOHV�\RX�WR�VHW�2'6�RSWLRQV�DQG�HGLW�WHPSODWHV��$OO�RI�WKH�RSWLRQV�DYDLODEOH�LQ
WKH�2'6�VWDWHPHQW�FDQ�EH�VHW�IURP�WKH�([SORUHU��7KH�WHPSODWH�HGLWRU�LV�D�GLDORJXH�EDVHG�HGLWRU�WKDW
DOORZV�\RX�WR�VHW�YDOXHV�IRU�DOO�RI�WKH�WHPSODWH�RSWLRQV�
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
5
Figure 2: The SAS Explorer
7KH�7HPSODWH�3URFHGXUH
$�WHPSODWH�LV�DQ�DEVWUDFW�GHVFULSWLRQ�RI�ZKDW�D�SLHFH�RI�RXWSXW� LV�VXSSRVHG�WR�ORRN�OLNH�ZKHQ�LW� LV
IRUPDWWHG�� $� WHPSODWH� FRQWDLQV� DWWULEXWHV� GHVFULELQJ� FROXPQ� RUGHULQJ�� VW\OH� LQIRUPDWLRQ�
MXVWLILFDWLRQ��FHOO�IRUPDWV��DQG�RWKHU�IRUPDWWLQJ�FKDUDFWHULVWLFV��0RVW�RXWSXW�REMHFWV�KDYH�D�WHPSODWH
DVVRFLDWHG�ZLWK� WKHP�� <RX� FDQ� ILQG� WKH� WHPSODWH� DVVRFLDWHG� ZLWK� D� SDUWLFXODU� SLHFH� RI� RXWSXW� E\
ORRNLQJ�DW�WKH�2'6�75$&(�UHFRUG��)RU�DQ�H[DPSOH��SOHDVH�VHH�)LJXUH���
7KH�7(03/$7(�SURFHGXUH�HQDEOHV�\RX� WR�FUHDWH�DQG�HGLW� WHPSODWHV� LQ�EDWFK�PRGH��7HPSODWHV�DUH
IXOO\� HGLWDEOH�� VR� \RX� FDQ� FKDQJH� WKH� DSSHDUDQFH� RI�PRVW� RXWSXW� LQ� WKH� V\VWHP�� <RX� FDQ� HGLW� D
WHPSODWH�LQ�'LVSOD\�0DQDJHU�PRGH�E\�XVLQJ�WKH�QHZ�6$6�([SORUHU�
6$6�6\VWHP�WHPSODWHV�DUH�VWRUHG�LQ�WKH�6$6+(/3�OLEUDU\��:KHQ�\RX�UXQ�352&�7(03/$7(�WR�PRGLI\�RU
HGLW�D� WHPSODWH�� WKH� WHPSODWH� LV� VWRUHG� LQ� WKH� 6$686(5� OLEUDU\�� <RX� FDQ�PRGLI\� WKH� FRQFDWHQDWLRQ
SDWK�WKDW�2'6�XVHV�WR�ORRN�XS�WHPSODWHV�ZLWK�WKH�2'6�3$7+�VWDWHPHQW��,Q�WKLV�PDQQHU�\RX�FDQ�VHW
XS�D�GHIDXOW� VHW�RI� WHPSODWHV� IRU�\RXU�RUJDQL]DWLRQ� WR�XVH� WKDW�PRGLILHV� WKH�ORRN�DQG� IHHO� RI� 6$6
RXWSXW��2QFH�\RX�KDYH�HGLWHG�D� WHPSODWH� IRU�D�SLHFH�RI�RXWSXW�� WKH�RXWSXW� � FRQWLQXHV� WR�XVH� WKDW
WHPSODWH�XQWLO�WKH�WHPSODWH�LV�GHOHWHG�
)RU�DQ�H[DPSOH�RI�HGLWLQJ�DQG�XVLQJ�WHPSODWHV��SOHDVH�VHH�WKH�´([DPSOHVµ�VHFWLRQ�
6W\OHV
$� VW\OH� WHPSODWH� LV�PRVWO\� FRQFHUQHG�ZLWK� VW\OLVWLF� LVVXHV� VXFK� DV� FRORUV�� IRQWV�� DQG� SUHVHQWDWLRQ
DWWULEXWHV��$�VW\OH�FDQ�EH�VSHFLILHG�RQO\�IRU�RXWSXW�GHVWLQDWLRQV�WKDW�VXSSRUW�WKHP��$W�SUHVHQW��WKH
RQO\�GHVWLQDWLRQV�WKDW�VXSSRUW�VW\OHV�DUH�+70/��57)��DQG�36�3&/��7KH�6$6�RXWSXW�ZLQGRZ�GRHV�QRW
SDUWLFLSDWH�LQ�WKH�VW\OH�VFKHPH��VR�LI�\RX�ZDQW�WR�XVH�VW\OHV�\RX�QHHG�WR�XVH�DQ�RXWSXW�GHVWLQDWLRQ
WKDW�IXOO\�VXSSRUWV�WKHP�
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
6
,W�LV�LPSRUWDQW�WR�QRWH�WKH�GLIIHUHQFH�EHWZHHQ�D�VW\OH�WHPSODWH�DQG�D�QRUPDO�WDEOH�WHPSODWH��$�VW\OH
DSSOLHV� WR� DQ� HQWLUH� 6$6� MRE�� DQG� D� WDEOH� WHPSODWH� DSSOLHV� RQO\� WR� WKH� WDEOHV� WKDW� UHIHUHQFH� WKH
WHPSODWH��8VH�RI�VW\OHV�HQVXUHV�D�FRQVLVWHQW� ORRN�DQG� IHHO�DFURVV�DOO�RXWSXW�IURP�WKH�6$6�6\VWHP�
<RX�FDQ��KRZHYHU��UHIHUHQFH�VW\OH�LQIRUPDWLRQ�LQ�WHPSODWHV�IRU�LQGLYLGXDO�KHDGHUV�DQG�GDWD�FHOOV�
<RX�FDQ�VSHFLI\�D�VW\OH�WR�XVH�IRU�DQ�RXWSXW�GHVWLQDWLRQ�XVLQJ�WKH�2'6�VWDWHPHQW��$V�DQ�H[DPSOH�RI
ZKDW�\RX�FDQ�GR�ZLWK�VW\OHV��VHH�WKH�352&�7$%8/$7(�RXWSXW�LQ�)LJXUH���
Figure 3: PROC TABULATE example using styles
7KH�2'6�2XWSXW�'RFXPHQW
+DYH� \RX� HYHU�ZDQWHG� WR� UHIRUPDW� RXWSXW� IURP�D� SURFHGXUH� ZLWKRXW� DFWXDOO\� KDYLQJ� WR� UHUXQ� WKH
SURFHGXUH"�,I�VR�WKHQ�WKH�'RFXPHQW�LV�IRU�\RX��7KH�'RFXPHQW�LV�D�SHUVLVWHQW�UHSUHVHQWDWLRQ�RI�WKH
RXWSXW�WKDW�LV�SURGXFHG�E\�\RXU�6$6�MRE��2XWSXW�LV�VWRUHG�FRPSOHWHO\�LQ�UDZ�IRUP��7KLV�HQDEOHV�\RX
WR� FKDQJH� IRUPDWWLQJ� FKDUDFWHULVWLFV� �IRUPDWV�� FROXPQ�KHDGHUV�� DQG� VR� RQ��ZLWKRXW� UHUXQQLQJ� WKH
SURFHGXUH� WKDW� FUHDWHG� WKH� RXWSXW�� 7KH� 'RFXPHQW� DOVR� HQDEOHV� \RX� WR� EURZVH� DQG� PRGLI\� 6$6
RXWSXW� IURP� SUHYLRXV� UXQV�� FRPELQH� RXWSXW� LQWR� FXVWRP� UHSRUWV�� DQG� DFFHVV� \RXU� RXWSXW� IURP
FOLHQW�VHUYHU�DSSOLFDWLRQV�
7KH�287387�3URFHGXUH
7KH�287387�SURFHGXUH�HQDEOHV�\RX�WR�PDQLSXODWH�2'6�2XWSXW�'RFXPHQWV�LQ�EDWFK�PRGH��7KHUH�DUH
FRPPDQGV� WR� UHRUGHU� RXWSXW� LQ� WKH� RXWSXW� GLUHFWRU\�KLHUDUFK\�� WR�PRYH� DQG� FRS\� RXWSXW� WR� QHZ
GLUHFWRULHV��DQG�WR�UHSOD\�RXWSXW�WR�WKH�YDULRXV�2'6�RXWSXW�GHVWLQDWLRQV��)RU�'LVSOD\�0DQDJHU�XVHUV�
WKHUH� LV� VXSSRUW� IRU�PDQDJLQJ�2XWSXW� 'RFXPHQWV� LQ� WKH� 6$6� ([SORUHU�� $OO� RI� WKH� IXQFWLRQDOLW\� LQ
352&�287387�ZLOO�EH�DYDLODEOH�LQ�WKH�([SORUHU�
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
7
([DPSOHV
Using Output Delivery in a Pharmaceutical Trial
,QWURGXFWLRQ
7KLV� H[DPSOH� XVHV� D� SUH�FOLQLFDO� GUXJ� H[SHULPHQW� WR� GHPRQVWUDWH� KRZ� 2'6� JLYHV� \RX
XQSUHFHGHQWHG�FRQWURO�RYHU�6$6�RXWSXW��7KH�GDWD�LV�WDNHQ�IURP�&ROH�DQG�*UL]]OH���������,Q�RUGHU�WR
VWXG\�WKH�HIIHFW�RI�WZR�GLIIHUHQW�GUXJV�RQ�KLVWDPLQH�OHYHOV�LQ�WKH�EORRG��WKH�GUXJV�ZHUH�JLYHQ�WR���
DQLPDOV��VRPH�ZLWK�GHSOHWHG�KLVWDPLQH�OHYHOV��DQG�WKH�OHYHOV�RI�KLVWDPLQH�LQ�WKH�DQLPDOV�EORRG�ZDV
PHDVXUHG�DIWHU����������DQG���PLQXWHV��7KH�UHVSRQVH�YDULDEOH�LV�WKH�ORJDULWKP�RI�WKH�KLVWDPLQH�OHYHO�
7KH� IROORZLQJ�VWDWHPHQWV�FUHDWH�D�6$6�GDWD�VHW�QDPHG�+,67$0,1(� WKDW� FRQWDLQV� WKH� H[SHULPHQWDO
GDWD�
title "Histamine Study"; data Histamine; input Drug $12. Depleted $ hist0 hist1 hist3 hist5; logHist0 = log(hist0); logHist1 = log(Hist1); logHist3 = log(hist3); logHist5 = log(Hist5); datalines; Morphine N .04 .20 .10 .08 Morphine N .02 .06 .02 .02 Morphine N .07 1.40 .48 .24 Morphine N .17 .57 .35 .24 Morphine Y .10 .09 .13 .14 Morphine Y .07 .07 .06 .07 Morphine Y .05 .07 .06 .07 Trimethaphan N .03 .62 .31 .22 Trimethaphan N .03 1.05 .73 .60 Trimethaphan N .07 .83 1.07 .80 Trimethaphan N .09 3.13 2.06 1.23 Trimethaphan Y .10 .09 .09 .08 Trimethaphan Y .08 .09 .09 .10 Trimethaphan Y .13 .10 .12 .12 Trimethaphan Y .06 .05 .05 .05 ;
7KH�DSSURSULDWH�DQDO\VLV�IRU�WKLV�W\SH�RI�H[SHULPHQW�LV�D�UHSHDWHG�PHDVXUHV�DQDO\VLV��ZKLFK�DVVXPHV
WKDW�UHVSRQVHV�IURP�GLIIHUHQW�DQLPDOV�DUH�LQGHSHQGHQW�EXW�UHVSRQVHV�DW�GLIIHUHQW�WLPHV�IRU�WKH�VDPH
DQLPDO� DUH� FRUUHODWHG�� 7KH� IROORZLQJ� VWDWHPHQWV� XVH� 352&� */0� WR� SHUIRUP�D� UHSHDWHG�PHDVXUHV
DQDO\VLV��QDPLQJ�WKH�GUXJ�DQG�GHSOHWLRQ�VWDWXV�DV�EHWZHHQ�VXEMHFW�IDFWRUV�LQ�WKH�02'(/�VWDWHPHQW�
DQG� QDPLQJ� SRVW�DGPLQLVWUDWLRQ� PHDVXUHPHQW� WLPH� DV� WKH� ZLWKLQ�VXEMHFW� IDFWRU�� � � �)RU� PRUH
LQIRUPDWLRQ� RQ� WKLV� VWXG\�DQG� LWV� DQDO\VLV�� VHH�([DPSOH� �� LQ� WKH�*/0� FKDSWHU� RI� WKH� 6$6�67$7®
GRFXPHQWDWLRQ��
proc glm data=Histamine; class Drug Depleted; model LogHist0—LogHist5 = Drug Depleted Drug*Depleted / nouni; repeated Time 4 (0 1 3 5) polynomial / summary printe; quit;
'HOLYHULQJ�2XWSXW�RQ�WKH�:HE
5HSHDWHG�PHDVXUHV�DQDO\VHV�SURGXFH�D�ORW�RI�RXWSXW��LQFOXGLQJ�XQLYDULDWH�DQG�PXOWLYDULDWH�$129$V�
FRUUHODWLRQ�PDWULFHV��ZLWKLQ��DQG�EHWZHHQ�VXEMHFW�WHVWV��DQG�VR�RQ�� ,Q�WKLV�FDVH�� WKH�RXWSXW�VWDUWV
ZLWK�WKH�FODVV� OHYHO� LQIRUPDWLRQ�DQG�JRHV�RQ�IRU�RYHU����� OLQHV�RQ� ILYH�RU�VL[�SDJHV��6R�\RXU� ILUVW
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
8
TXHVWLRQ�PLJKW�EH��´+RZ�FDQ�,�JHW�DOO�WKDW�RXWSXW�WR�P\�FROOHDJXHV�ZLWKRXW�KDYLQJ�WR�SXW�DOO� WKRVH
SDJHV�LQ�WKH�PDLO"µ�2'6�SURYLGHV�WKH�DQVZHU��\RX�FDQ�SURGXFH�WKH�*/0�RXWSXW�GLUHFWO\�DV�+70/�DQG
SXW�LW�RQ�\RXU�FRPSDQ\V�LQWUDQHW��$OO�\RX�KDYH�WR�GR�LV�QDPH�WKH�ILOH�ZKHUH�\RX�ZDQW�WKH�+70/�WR
EH�ZULWWHQ��DV�VKRZQ�LQ�WKH�IROORZLQJ�VWDWHPHQWV�
ods html body = ’HistGLM.html’; proc glm data=Histamine; class Drug Depleted; model LogHist0--LogHist5 = Drug Depleted Drug*Depleted / nouni; repeated Time 4 (0 1 3 5) polynomial / summary printe; quit; ods html close;
7KH ods html body= RSWLRQ�VSHFLILHV�WKH�ILOH�ZKHUH�WKH�+70/�RXWSXW�LV�WR�EH�ZULWWHQ��DQG��WKH�ods
html close�RSWLRQ�GLUHFWV�WKH�V\VWHP�WR�VWRS�ZULWLQJ�+70/��7KH�UHVXOWV�XVH�+70/V�EXLOW�LQ�WDEOH
IRUPDWWLQJ�IDFLOLWLHV�WR�PDNH�RXWSXW�WKDW�ORRNV�ULJKW�RQ�DQ\�EURZVHU��)LJXUH����
Figure 4: HTML output for GLM repeated measures analysis
%HFDXVH� WKHUH� DUH� VR� PDQ\� WDEOHV� WR� PDNH� VHQVH� RI�� D� WDEOH� RI� FRQWHQWV� ZRXOG� EH� KHOSIXO�
)RUWXQDWHO\��2'6�FDQ�SURGXFH�WKDW��WRR��-XVW�QDPH�DQRWKHU�ILOH�WR�FRQWDLQ�WKH�WDEOH�RI�FRQWHQWV��DV
VKRZQ�LQ�WKH�IROORZLQJ�VWDWHPHQWV�
ods html body = ’HistGLM.html’ contents = ’HistGLMContents.html’; proc glm data=Histamine; class Drug Depleted; model LogHist0--LogHist5 = Drug Depleted Drug*Depleted / nouni;
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
9
repeated Time 4 (0 1 3 5) polynomial / summary printe; quit; ods html close;
7KH�UHVXOWLQJ�:HE�SDJH��)LJXUH����FRQWDLQV�D�URDG�PDS�IRU�WKH�*/0�RXWSXW�
Figure 5: HTML table of contents for GLM repeated measures analysis
0RUHRYHU�� WKH� FRQWHQWV� DUH� OLQNHG� WR� WKH�ERG\� RI� WKH� RXWSXW�� 7KDW� LV�� LI� \RX� FOLFN� RQ� ´6SKHULFLW\
7HVWV�µ� \RXU�EURZVHU� WDNHV� \RX� ULJKW� WR� WKH� WHVW� IRU�D� VSKHULFDO� FRYDULDQFH� VWUXFWXUH� EHWZHHQ� WKH
ZLWKLQ�VXEMHFW�PHDVXUHPHQWV� �)LJXUH� ���� �1RWH� WKDW� WKH� VSKHULFLW\� WHVWV� DUH� VLJQLILFDQW�� LQGLFDWLQJ
WKDW�\RX�VKRXOG�XVH�WKH�PXOWLYDULDWH�WHVWV�IRU�ZLWKLQ�VXEMHFW�HIIHFWV��<RX�FDQ�HYHQ�PDNH�D�:HE�SDJH
WKDW�GLVSOD\V� WKH�FRQWHQWV�DQG� WKH�ERG\�RI� WKH�RXWSXW�DW�WKH� VDPH� WLPH��XVLQJ�+70/� IUDPLQJ��DV
GHPRQVWUDWHG�LQ�WKH�IROORZLQJ�VWDWHPHQWV�
ods html body = ’HistGLM.html’ contents = ’HistGLMContents.html’ frame = ’HistGLMFrame.html’;proc glm data=Histamine; class Drug Depleted; model LogHist0--LogHist5 = Drug Depleted Drug*Depleted / nouni; repeated Time 4 (0 1 3 5) polynomial / summary printe;quit;
ods html close;
7KH�UHVXOWLQJ�:HE�SDJH�LV�VKRZQ�LQ�)LJXUH���
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
10
Figure 6: Sphericity tests
Figure 7: Combined table of contents and repeated measures analysis
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
11
'HOLYHULQJ�-XVW�WKH�2XWSXW�<RX�:DQW
(YHQ�WKRXJK�WKH�+70/�RXWSXW�ZLWK�D�WDEOH�RI�FRQWHQWV�KHOSV�WR�NHHS�WKH�*/0�UHVXOWV�LQ�RUGHU��WKHUH
PLJKW�EH�PRUH�LQIRUPDWLRQ�WKDQ�\RX�QHHG��<RX�FDQ�DOVR�XVH�2'6�WR�GLVSOD\�MXVW�WKH�WDEOHV�\RX�ZDQW
WR�VHH�
(DFK� SLHFH� RI� RXWSXW� KDV� D� QDPH� DQG� D� SDWK�� FRUUHVSRQGLQJ� WR� ZKHUH� LW� RFFXUV� LQ� WKH� WDEOH� RI
FRQWHQWV��7R�OLPLW�ZKLFK�WDEOHV�DUH�GLVSOD\HG��\RX�VLPSO\�WHOO�2'6�WKH�QDPHV�RI�WKH�WDEOHV�\RX�ZDQW
WR� VHH�� 7KH� HDVLHVW� ZD\� WR� ILQG� RXW� WKH� QDPHV� RI� D� SURFHGXUHV� WDEOHV� LV� WR� XVH� WKH� ods trace
output RSWLRQ����7KLV�RSWLRQ�GLVSOD\V�WKH�QDPH���DQG�RWKHU�LQIRUPDWLRQ��DVVRFLDWHG�ZLWK�HDFK�SLHFH
RI�RXWSXW�DV�LW�LV�SURGXFHG�����7KLV�LV�GHPRQVWUDWHG�LQ�WKH�IROORZLQJ�VWDWHPHQWV�
ods trace output;proc glm data=Histamine; class Drug Depleted; model LogHist0—LogHist5 = Drug Depleted Drug*Depleted; repeated Time 4 (0 1 3 5) polynomial / summary printe;quit;ods trace off;
)RU�H[DPSOH��WKH�LQIRUPDWLRQ�GLVSOD\HG�IRU�WKH�EHWZHHQ�VXEMHFWV�$129$�LV�VKRZQ�LQ�)LJXUH���
6XSSRVH�WKDW�\RX�ZDQW�MXVW�WKHVH�WDEOHV�WR�EH�GLVSOD\HG��$OO�\RX�KDYH�WR�GR�LV�WHOO�2'6�WR�VHOHFW�RQO\
WDEOHV�ZLWK�WKHVH�QDPHV�
ods select Mtests BetweenSubjects.ModelANOVA;proc glm data=Histamine; class Drug Depleted; model LogHist0--LogHist5 = Drug Depleted Drug*Depleted / nouni; repeated Time 4 (0 1 3 5) polynomial / summary printe;quit;
2QO\�WKH�IRXU�WDEOHV�ZLWK�WKH�PXOWLYDULDWH�WHVWV�IRU�WKH�ZLWKLQ�VXEMHFW�HIIHFWV�DQG�WKH�WDEOH�IRU�WKH
EHWZHHQ�VXEMHFW�WHVWV�DUH�GLVSOD\HG�� �$OO� IRXU�PXOWLYDULDWH� WHVW� WDEOHV�DUH�GLVSOD\HG��VLQFH� WKH\�DOO
KDYH� WKH� QDPH� ´0WHVWV�µ� HYHQ� WKRXJK� WKH\� RFFXU� LQ� GLIIHUHQW� GLUHFWRULHV� LQ� WKH� RXWSXW� GLUHFWRU\
KLHUDUFK\���2Q�WKH�RWKHU�KDQG��´%HWZHHQ6XEMHFWV�0RGHO$129$µ�UHIHUV�MXVW�WR�WKH�PRGHO�$129$�WDEOH
WKDW�RFFXUV�LQ�WKH�´%HWZHHQ6XEMHFWVµ�GLUHFWRU\�
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
12
Output Added:-------------Name: MtestsLabel: Multivariate TestsTemplate: stat.GLM.MtestsPath: GLM.Repeated.MANOVA.Model.Time_Drug_Depleted.MTests-------------
Manova Test Criteria and Exact F Statistics for the Hypothesis of no Time*Drug*Depleted Effect H = Type III SS&CP Matrix for Time*Drug*Depleted E = Error SS&CP Matrix
S=1 M=0.5 N=3.5
Statistic Value F Value Num DF Den DF Pr > F
Wilks’ Lambda 0.19383010 12.48 3 9 0.0015 Pillai’s Trace 0.80616990 12.48 3 9 0.0015 Hotelling-Lawley Trace 4.15915732 12.48 3 9 0.0015 Roy’s Greatest Root 4.15915732 12.48 3 9 0.0015
Output Added:-------------Name: ModelANOVALabel: Type III Model ANOVATemplate: stat.GLM.TestsPath: GLM.Repeated.BetweenSubjects.ModelANOVA-------------
Histamine Study
General Linear Models Procedure Repeated Measures Analysis of Variance Tests of Hypotheses for Between Subjects Effects
Source DF Type III SS Mean Square F Value Pr > F
Drug 1 5.99336243 5.99336243 2.71 0.1281 Depleted 1 15.44840703 15.44840703 6.98 0.0229 Drug*Depleted 1 4.69087508 4.69087508 2.12 0.1734 Error 11 24.34683348 2.21334850Figure 8: Listing output with interleaved TRACE OUTPUT results
'HOLYHULQJ�2XWSXW�WR�'DWD�6HWV
7KH�GLVSOD\HG� RXWSXW�PD\� VWLOO� EH�PRUH�YHUERVH� WKDQ�\RX�ZDQW�� <RX�PD\�ZDQW� WR� UHRUJDQL]H� WKH
LQIRUPDWLRQ�LQ�WKH�ILYH�WDEOHV�VHOHFWHG�SUHYLRXVO\�LQWR�RQH�WDEOH�ZLWK�D�OLQH�IRU�HDFK�HIIHFW��,I�\RX�KDG
WKH�GLIIHUHQW�WDEOHV�LQ�GDWD�VHWV��\RX�FRXOG�XVH�WKH�H[WHQVLYH�GDWD�PDQLSXODWLRQ�IDFLOLWLHV�RI�WKH�6$6
ODQJXDJH�WR�JHW�WKH�MRE�GRQH�
6$6�SURFHGXUHV�KDYH�DOZD\V�PDGH� WKH�PRVW� LPSRUWDQW�VWDWLVWLFV� DYDLODEOH� LQ� DX[LOLDU\� RXWSXW� GDWD
VHWV��EXW�ZLWK�WKH�DGYHQW�RI�2XWSXW�'HOLYHU\��HYHU\�QXPEHU�LQ�HYHU\�WDEOH�RI�HYHU\�SURFHGXUH�FDQ�EH
DFFHVVHG�YLD�D�GDWD�VHW��7KH�V\QWD[� LV�YHU\�VLPLODU� WR� WKDW� IRU� VHOHFWLQJ� VSHFLILF� WDEOHV� WR�GLVSOD\�
6LPSO\�QDPH�WKH�WDEOHV�WR�EH�VDYHG�DQG�HTXDWH�WKHP�WR�WKH�QDPHV�RI�GDWD�VHWV�LQ�ZKLFK�WKH\�VKRXOG
EH�VDYHG.
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
13
ods output Mtests = HistWithin BetweenSubjects.ModelANOVA = HistBetween;proc glm data=Histamine; class Drug Depleted; model LogHist0—LogHist5 = Drug Depleted Drug*Depleted / nouni; repeated Time 4 (0 1 3 5) polynomial / summary printe;
quit;
$OO� WKH� PXOWLYDULDWH� WHVW� UHVXOWV� DSSHDU� LQ� WKH� +,67:,7+,1� GDWD� VHW�� 7KLV� LV� EHFDXVH� DOO� WKH
PXOWLYDULDWH� WHVW� WDEOHV� DUH� QDPHG� ´07HVWV��� DOWKRXJK� WKH\� RFFXU� LQ� GLIIHUHQW� GLUHFWRULHV� LQ� WKH
RXWSXW� GLUHFWRU\� KLHUDUFK\�� 7KHUH� DUH� DOVR� RWKHU� WDEOHV� QDPHG� ´0RGHO$129$��� EXW� WKH� DERYH
VWDWHPHQW�PDNHV�VXUH�\RX�JHW�RQO\�WKH�EHWZHHQ�VXEMHFW�$129$�LQ� WKH�+,67%(7:((1� �GDWD�VHW�E\
DGGLWLRQDOO\�VSHFLI\LQJ�WKH�JURXS�LQ�ZKLFK�LW�RFFXUV�
'HOLYHULQJ�&RPELQHG�2XWSXW
6R��QRZ�WKDW�\RX�KDYH�WKH�WHVWV�LQ�GDWD�VHWV��KRZ�FDQ�\RX�GLVSOD\�DOO�WKH�LQIRUPDWLRQ�LQ�RQH�RYHU�DOO
VXPPDU\�WDEOH"�7KH�IROORZLQJ�VWDWHPHQWV�VKRZ�KRZ�WR�FRPELQH�WKH�WZR�GDWD�VHWV�LQWR�D�VLQJOH�GDWD
VHW��GURSSLQJ� WKH� URZ�FRUUHVSRQGLQJ� WR� ´(UURUµ� IURP�WKH�EHWZHHQ�WHVWV�DQG�UHQDPLQJ�D�FRXSOH�RI
YDULDEOHV� LQ� WKH� ZLWKLQ�WHVWV� GDWD� VHW�� � � $OVR�� \RX� UHWDLQ� WKH� UHVXOWV� RI� MXVW� RQH� RI� WKH� IRXU
PXOWLYDULDWH�WHVWV�
data HistTests; set HistBetween(where =(Source ^= "Error") ) HistWithin (rename=(Hypothesis = Source NumDF=DF) where =(Statistic = "Hotelling-Lawley Trace")); run;
1RZ��\RX�FDQ�XVH�WKH�'$7$�VWHS�WR�DSSO\�D�WHPSODWH�WR�WKH�FRPELQHG�WHVW�GDWD��$�WHPSODWH�VSHFLILHV
KRZ�DQ�DEVWUDFW�UHFWDQJOH�RI�GDWD�VKRXOG�EH�GLVSOD\HG�� ,Q�WKH�RXWSXW�IURP�WKH�ods trace RXWSXW
VWDWHPHQW� EHIRUH�� \RX� VDZ� WKDW� HDFK� WDEOH� KDV� D� WHPSODWH� DV� ZHOO� DV� D� QDPH�� ,Q� SDUWLFXODU�� WKH
WHPSODWH�DVVRFLDWHG�ZLWK�WKH�$129$�WDEOHV�LV�´6WDW�*/0�7HVWV����/RRNLQJ�DW�)LJXUH���\RX�FDQ�VHH�WKDW
WKH�*/0�SURFHGXUH�XVHV�WKLV�WHPSODWH�WR�IRUPDW�$129$�WDEOHV��DQG�\RX�FDQ�XVH�LW�� WRR�� �6XSSRVH
WKH�FRPELQHG�GDWD�VHW�LV�QDPHG�+,677(676���7KH�IROORZLQJ�VWDWHPHQWV�´UHQGHU��WKLV�GDWD�VHW�XVLQJ
WKH�´6WDW�*/0�7HVWV��WHPSODWH�
data _null_; set HistTests; file print ods=(template='Stat.GLM.Tests'); put _ods_; run;
7KH�UHVXOWV� ORRN�MXVW� OLNH�DQ\�RWKHU�$129$� WDEOH�GLVSOD\HG�E\� WKH�*/0�SURFHGXUH��<RX�FDQ�GUHVV
WKHP�XS�D�ELW�E\�DGGLQJ�7,7/(�DQG�)227127(�VWDWHPHQWV�DQG�GLVSOD\LQJ�WKHP�DV�+70/��DV�VKRZQ
LQ�WKH�IROORZLQJ�VWDWHPHQWV�
ods html body = 'HistTests1.html';title "Histamine Study";footnote1"Within-subject tests are computed using Hotelling-Lawley trace";data _null_; set HistTests; file print ods=(template='Stat.GLM.Tests'); put _ods_; run;
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
14
title;footnote1;ods html close;
7KH�UHVXOWV�DUH�VKRZQ�LQ�)LJXUH������7KH�IRRWQRWH�H[SODLQV�ZK\�WKH�ZLWKLQ�VXEMHFW�WHVWV�KDYH�PLVVLQJ
66� DQG�06� FROXPQV�� )RU�PRUH� LQIRUPDWLRQ� RQ�KRZ� WR� XVH� WKH� '$7$� VWHS� WR� LQWHUIDFH� ZLWK� 2'6�
SOHDVH�UHIHU�WR�+HIIQHU��������
Figure 9: Combined tests for within- and between-subject effects
'HOLYHULQJ�&XVWRPL]HG�2XWSXW
)RU�KLVWRULFDO�UHDVRQV��WKH�*/0�SURFHGXUH�GLVSOD\V�VXPV�RI�VTXDUHV�DQG�PHDQ�VTXDUHV�ZLWK�PDQ\
GLJLWV�E\�GHIDXOW��6XSSRVH�WKDW�\RX�ZDQW�WR�GLVSOD\�WKHP�ZLWK�IHZHU�GLJLWV��,W�LV�HDV\�WR�UHGHILQH�WKH
IRUPDW�XVHG� WR� GLVSOD\�D� FROXPQ� LQ�D� WHPSODWH�� � )RU� H[DPSOH�� WKH� IROORZLQJ� VWDWHPHQWV� FRS\� WKH
FXUUHQW�´6WDW�*/0�7HVWVµ�WHPSODWH��FKDQJLQJ�WKH�IRUPDW�IRU�SULQWLQJ�WKHVH�WZR�FROXPQV�
proc template; edit Stat.GLM.Tests as CombinedTests; edit SS; format=D7.3; end; edit MS; format=D7.3; end; end; run;
<RX�FDQ�DSSO\�WKLV�QHZ�WHPSODWH�WR�WKH�FRPELQHG�WHVW�GDWD�LQ�WKH�VDPH�ZD\�WKDW�\RX�DSSOLHG�WKH
SUHGHILQHG�WHPSODWH�
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
15
title "Histamine Study";footnote1 "Within-subject tests are computed using Hotelling-Lawley trace";ods html body = ’HistTests2.html’;data _null_; set HistTests; file print ods=(template=’CombinedTests’); put _ods_; run;ods html close;title;footnote1;ods html close;
7KH�UHVXOWV�DUH�VKRZQ�LQ�)LJXUH����
Figure 10: Combined tests with reformatted SS and MS columns
7R�PDNH�WKH�DQDO\VLV�UHDOO\�HDV\�WR�LQWHUSUHW��\RXG�OLNH�WR�HPSKDVL]H�HIIHFWV�WKDW�DUH�VLJQLILFDQW�DW
WKH������OHYHO�� �7KLV�\RX�FDQ�DOVR�GR�ZLWK�WKH�WHPSODWH�XVHG�WR�GLVSOD\�WKH�UHVXOWV�� �7KH�IROORZLQJ
VWDWHPHQWV�XVH�WKH�WHPSODWH�WR
• UHGHILQH�WKH�IRUPDW�IRU�WKH�66�DQG�06�FROXPQV��DV�VKRZQ�SUHYLRXVO\
• LQFOXGH�WKH�WDEOH�WLWOH�DQG�IRRWQRWH�LQ�WKH�ERG\�RI�WKH�WDEOH
• WUDQVODWH� WKH�PLVVLQJ�YDOXHV� IRU�66�DQG�06� LQ� WKH� URZV�FRUUHVSRQGLQJ� WR�PXOWLYDULDWH� WHVWV� WR
DVWHULVNV��UHIHUULQJ�WR�WKH�IRRWQRWH
• HPSKDVL]H�VLJQLILFDQW�S�YDOXHV�ZLWK�D�EROG�IRQW
• DGG�D�FROXPQ�GHSLFWLQJ�WKH�OHYHO�RI�VLJQLILFDQFH
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
16
proc template; define table CombinedTests; parent=Stat.GLM.Tests;
header "#Histamine Study##"; footer "#* - Test computed using Hotelling-Lawley trace";
column Source DF SS MS FValue ProbF Star;
define SS; parent = Stat.GLM.SS; format = D7.3; translate _val_ = . into ’ *’; end; define MS; parent = Stat.GLM.MS; format = D7.3; translate _val_ = . into ’ *’; end; define ProbF; parent = Stat.GLM.ProbF; cellstyle _val_ < 0.02 as Styles.DataCellEmphasis; end; define Star; compute as ProbF; translate _val_ > 0.05 into "", _val_ > 0.01 into "*", _val_ > 0.001 into "**", _val_ <= 0.001 into "***"; pre_space=1 width=3 just=l; end; end; run;
ods html body = ’HistTests3.html’ palette=Palettes.Brown;data _null_; set HistTests; file print ods=(template=’CombinedTests’); put _ods_; run;ods html close;
7KH�UHVXOWV�DUH�VKRZQ�LQ�)LJXUH����
,I�\RX�ZDQW� WR�FKDQJH� WKH�ZD\�DOO�$129$� WHVWV�DUH�GLVSOD\HG�E\�352&�*/0��\RX�FDQ�UHGHILQH� WKH
WHPSODWHV� WKDW� WKH�SURFHGXUH�XVHV��)RU�H[DPSOH�� LQ�RUGHU� WR�KDYH� WKH� 66� DQG�06� FROXPQV�DOZD\V
GLVSOD\HG� ZLWK� IHZHU� GLJLWV�� VLPSO\� UHGHILQH� WKH� URRW� FROXPQV� XVHG� E\� WKH� SURFHGXUH� WR� GLVSOD\
WKHP�
proc template; edit Stat.GLM.SS; format=D7.3; end; edit Stat.GLM.MS; format=D7.3; end;run;
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
17
Figure 11: Combined tests with special formatting
8VLQJ�2XWSXW�'HOLYHU\�LQ�DQ�,QGXVWULDO�([SHULPHQW
,QWURGXFWLRQ
7KH�SUHFHGLQJ�VHFWLRQV�GHPRQVWUDWH�KRZ�\RX�FDQ�XVH�2'6� WR� FXVWRPL]H��PDQLSXODWH�� DQG�GHOLYHU
MXVW�WKH�6$6�SURFHGXUH�RXWSXW�\RX�ZDQW�GLUHFWO\�WR�\RXU�FROOHDJXHV��6R�IDU� WKH�H[DPSOHV� IRFXV�RQ
UHVXOWV� WKDW� FDQ� EH� VXPPDUL]HG� LQ� D� VLQJOH� WDEOH�� :KHQ� VWDWLVWLFDO� UHVXOWV� DUH� QHFHVVDULO\� PRUH
FRPSOLFDWHG��\RX�FDQ�XVH�2'6�WR�OLQN�GLIIHUHQW�SDUWV�WRJHWKHU��<RX�FDQ�HYHQ�FUHDWH�+70/�IRU�\RXU
LQWUDQHW�WKDW�PL[HV�DQG�OLQNV�WH[W�DQG�JUDSKLFV�
6XSSRVH� \RX� DUH� DQDO\]LQJ� D� ��� IDFWRULDO� H[SHULPHQW� IRU� DQ� LQGXVWULDO� SURFHVV�� WHVWLQJ� IRU
GLIIHUHQFHV�LQ�WKH�QXPEHU�RI�GHIHFWLYH�SURGXFWV�PDQXIDFWXUHG�E\�GLIIHUHQW�PDFKLQHV�XVLQJ�GLIIHUHQW
VRXUFHV�RI�UDZ�PDWHULDO�
data Experiment; do Supplier = ’A’,’B’,’C’,’D’; do Machine = 1 to 4; do rep = 1 to 5; input Defects @@; output; end; end; end; datalines; 2 6 3 3 6 8 6 6 4 4 4 2 4 0 4 5 5 7 8 513 12 12 11 12 16 15 14 14 13 11 10 12 12 10 13 13 14 15 12 2 6 3 6 6 6 4 4 6 6 0 3 2 0 2 4 6 7 6 420 19 18 21 22 22 24 23 20 20 17 19 18 16 17 23 20 20 22 21;
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
18
,I� WKH� )�WHVW� IRU� D� IDFWRU� LV� VLJQLILFDQW�� \RX� ZRXOG� OLNH� WR� IROORZ� XS� ZLWK� D�PXOWLSOH� FRPSDULVRQV
SURFHGXUH�� 6LQFH� WKLV� LV� D�EDODQFHG� H[SHULPHQW�� WKH� $129$�SURFHGXUH� FRPSXWHV� WKH� DSSURSULDWH
DQDO\VLV��DV�VKRZQ�LQ�WKH�IROORZLQJ�VWDWHPHQWV�
proc anova data=Experiment; class Supplier Machine; model Defects = Supplier Machine; means Supplier Machine / tukey;quit;
'HOLYHULQJ�/LQNHG�2XWSXW
7KH�WDEOHV�RI�LQWHUHVW�DUH�WKH�PRGHO�$129$�DQG�WKH�PXOWLSOH�FRPSDULVRQV�RXWSXW����<RX�FDQ�OLQN�D
URZ� RI� WKH� $129$� WDEOH� WR� WKH� FRUUHVSRQGLQJ� PXOWLSOH� FRPSDULVRQV� WDEOH� ZLWK� WKH� IROORZLQJ
WHPSODWH�
proc template; edit Stat.GLM.Tests; edit Source; translate _val_ = "Supplier" into concat( ’<a href="#IDX6"> ’, _val_, " </a>" ), _val_ = "Machine" into concat( ’<a href="#IDX8"> ’, _val_, " </a>" ); end; end; run;ods html body="MachinesAndSuppliers1.html";proc anova data=Experiment; class Supplier Machine; model Defects = Supplier Machine; means Supplier Machine / tukey;quit;ods html close;
7KH� UHVXOWV� DUH� VKRZQ� LQ� )LJXUH� ���� 7KH� DUURZ� LQGLFDWHV� D� OLQN� IURP� WKH� URZ� IRU� 6XSSOLHU� LQ� WKH
$129$�WDEOH�WR�WKH�PXOWLSOH�FRPSDULVRQV�DQDO\VLV�IRU�6XSSOLHU�
Figure 12: Linked output
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
19
$OWHUQDWLYHO\�� \RX� FDQ� XVH� *DEULHOV� SURFHGXUH� WR� GLVSOD\� WKH� PXOWLSOH� FRPSDULVRQV� UHVXOWV� DV
LQWHUYDOV�DURXQG�WKH�HVWLPDWHG�PHDQV���7KH�IROORZLQJ�VWDWHPHQWV�OLQN�WKH�URZV�RI�WKH�$129$�WDEOH
WR�JUDSKLFV� WKDW�HQDEOH�\RX� WR�MXGJH�ZKHWKHU� WZR�PHDQV� FRPSDUH� HTXDO� RQ� WKH�EDVLV� RI�ZKHWKHU
WKHLU�FRUUHVSRQGLQJ�LQWHUYDOV�RYHUODS�� �1RWH� WKDW� WKLV�H[DPSOH�QRW�RQO\�XVHV� WDEOH�UHIRUPDWWLQJ� WR
LQVHUW� OLQNV�� EXW� DOVR� RXWSXWV� WKH� WDEOHV� IURP� *DEULHO·V� DQDO\VLV� LQ� D� JUDSKLFDO� IRUP� XVLQJ� WKH
6+(:+$57�SURFHGXUH���7KH�UHVXOWV�DUH�VKRZQ�LQ�)LJXUH����
proc template; edit Stat.GLM.Tests; edit Source; translate _val_ = "Supplier" into concat( ’<a href="#IDX13"> ’, _val_, " </a>" ), _val_ = "Machine" into concat( ’<a href="#IDX14"> ’, _val_, " </a>" ); end; end; run;
ods html body="MachinesAndSuppliers2.html";
ods output CLMeans = CLMeans; /* Produce analysis of variance, */
proc anova data=Experiment; /* saving Gabriel’s analysis in */ class Supplier Machine; /* a data set. */ model Defects = Supplier Machine; means Supplier Machine / gabriel clm;quit;
goptions target=gif hsize=6in vsize=6in /* Use PROC SHEWHART to plot */ ftext=swissb htext=0.25in; /* Gabriel’s analysis for */
data M_CLMeans; set CLMeans; /* Machine. */ drop Dependent Effect Method; where (Effect='Machine') & (Method='Gabriel'); rename Level =Machine LowerCL=DefectsL Mean =DefectsX UpperCL=DefectsH N =DefectsN; label Level = 'Machine'; DefectsS = (UpperCL - LowerCL)/10; DefectsM = Mean; Defects1 = LowerCL; Defects3 = UpperCL;
proc sort data=M_CLMeans out=M_CLMeans; by Machine;
title "Comparison of Machine Means";
proc shewhart history=M_CLMeans; boxchart Defects*Machine / nolimits nolegend cframe = ligr cboxes = black cboxfill = orange; run;
data S_CLMeans; set CLMeans; /* Use PROC SHEWHART to plot */ drop Dependent Effect Method; /* Gabriel’s analysis for */ where (Effect='Supplier') /* Supplier. */ & (Method='Gabriel' );
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
20
rename Level =Supplier LowerCL=DefectsL Mean =DefectsX UpperCL=DefectsH N =DefectsN; label Level = ’Supplier’; DefectsS = (UpperCL - LowerCL)/10; DefectsM = Mean; Defects1 = LowerCL; Defects3 = UpperCL;
proc sort data=S_CLMeans out=S_CLMeans; by Supplier;
title "Comparison of Supplier Means";
proc shewhart history=S_CLMeans; boxchart Defects*Supplier / nolimits nolegend cframe = ligr cboxes = black cboxfill = orange;run;
ods html close;
Figure 13: Tables linked to graphics
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
21
7KH�8VXDO�&DYHDWV
&RPSDWLELOLW\�,VVXHV�ZLWK�9HUVLRQ���2'6�3URWRW\SH
• ,Q�9HUVLRQ�����D�IHZ�SURFHGXUHV�VXFK�DV�WKH�0,;('�SURFHGXUH�DQG�WKH�*(102'�SURFHGXUH�XVH�D
SURWRW\SH� 2'6� DQG� XVH� WKH� 0$.(� VWDWHPHQW� WR� FUHDWH� GDWD� VHWV� IURP� RXWSXW� REMHFWV�� 7KLV
VWDWHPHQW� UHPDLQV� VXSSRUWHG� LQ� WKHVH� SURFHGXUHV�� EXW� DOO� RWKHU� SURFHGXUHV� DFKLHYH� WKLV
REMHFWLYH�ZLWK�WKH�JOREDO�2'6�287387�VWDWHPHQW�
• 7KH�9HUVLRQ���SURWRW\SH�RI�WKH�2'6�RXWSXW�KLHUDUFK\�LV�VWRUHG�LQ�D�6$6�FDWDORJ��9HUVLRQ���6$6
6RIWZDUH� KDV� D� PRUH� IOH[LEOH� LWHP�VWRUH� ILOH� W\SH� XVHG� WR� VWRUH� WHPSODWHV� DQG� 2'6� 2XWSXW
'RFXPHQWV��7KHUH�DUH�FXUUHQWO\�QR�SODQV�IRU�D�FRQYHUVLRQ�SURFHGXUH�
• 7KH�9HUVLRQ���SURWRW\SH�2'6�XVHV� WZR�PDFUR�YDULDEOHV� �B',6.B� DQG� B35,17B�� WR� UHJXODWH� WKH
VDYLQJ�RI�DQ�RXWSXW�KLHUDUFK\��9HUVLRQ���XVHV�WKH�JOREDO�2'6�VWDWHPHQW�WR�LQGLFDWH�WKLV�
• 7KH�9HUVLRQ���DQG�9HUVLRQ���352&�7(03/$7(�DQG�352&�287387�V\QWD[�DUH�QRW�FRPSDWLEOH�
<RXU�7XUQ
7KH� 6$6� ,QVWLWXWH� VWDII� WKDW� EULQJV� \RX� 2'6� LV� YHU\� H[FLWHG� DERXW� WKH� SRWHQWLDO� RI� WKHVH� QHZ
FDSDELOLWLHV�RI� WKH�6$6�6\VWHP��<RX�FDQ�VHQG�HOHFWURQLF�PDLO�ZLWK�\RXU� FRPPHQWV� RU� WR� UHTXHVW� D
FRS\�RI�H[DPSOH�+70/�ILOHV�WR�RGV#XQ[�VDV�FRP�
:H� ZLOO� EH� DGGLQJ� PRUH� LQIRUPDWLRQ� DERXW� 2'6� FDSDELOLWLHV� WR� WKH� 5HVHDUFK� DQG� 'HYHORSPHQW
VHFWLRQ�RI�6$6�,QVWLWXWH·V�:HE�3DJH��6HH�KWWS���ZZZ�VDV�FRP�UQG
<RX� FDQ� ILQG�PRUH� LQIRUPDWLRQ� DERXW�YDULRXV� DVSHFWV� RI�2'6� E\� UHIHUULQJ� WR� +HIIQHU� ������� DQG
3DWHO��������
$FNQRZOHGJHPHQWV
2'6��LV��WKH��ZRUN��RI��PDQ\��LQGLYLGXDOV��LQ���WKH���$SSOLFDWLRQV���'LYLVLRQ����,3'���'HSDUWPHQW����DQG
3XEOLFDWLRQV��'LYLVLRQ�
5HIHUHQFHV
&ROH����-�:�/���DQG��*UL]]OH���-�(������������´$SSOLFDWLRQV��RI��0XOWLYDULDWH����$QDO\VLV���RI���9DULDQFH
WR���5HSHDWHG���0HDVXUHV���([SHULPHQWV�µ�%LRPHWULFV��������������
+HIIQHU�� :�� )�� �������� ´2'6�� 7KH� 'DWD� 6WHS� .QRZV�µ� LQ� WKH� 3URFHHGLQJV� IRU� WKH� 7ZHQW\�7KLUG
$QQXDO�6$6�8VHUV�*URXS�,QWHUQDWLRQDO�&RQIHUHQFH��&DU\��1&��6$6�,QVWLWXWH�,QF�
3DWHO���+����������´8VLQJ�6$6�*5$3+��6RIWZDUH�WR�&UHDWH�*UDSKV�RQ�WKH�:HE�µ�LQ�WKH�3URFHHGLQJV
IRU� WKH�7ZHQW\�7KLUG�$QQXDO�6$6�8VHUV�*URXS� ,QWHUQDWLRQDO�&RQIHUHQFH��&DU\��1&�� 6$6� ,QVWLWXWH
,QF�
6$6�,QVWLWXWH�,QF����������6$6�67$7��8VHUV��*XLGH���9HUVLRQ�������)RXUWK�(GLWLRQ��9ROXPH����&DU\�
1&��6$6�,QVWLWXWH�,QF�
6$6��6$6�*5$3+��DQG�6$6�67$7�DUH�UHJLVWHUHG�WUDGHPDUNV�RU�WUDGHPDUNV�RI�6$6�,QVWLWXWH� ,QF�� LQ
WKH�86$�DQG�RWKHU�FRXQWULHV��®�LQGLFDWHV�86$�UHJLVWUDWLRQ�
2WKHU� EUDQG� DQG� SURGXFW� QDPHV� DUH� UHJLVWHUHG� WUDGHPDUNV� RU� WUDGHPDUNV� RI� WKHLU� UHVSHFWLYH
FRPSDQLHV�
Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling
Top Related