sugi 23: it chops, it dices, it makes julienne slices! ods ......2 6roxwlrq2'67kh...

21
1 ® 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 Modeling Statistics, Data Analysis, and Modeling

Upload: others

Post on 11-Oct-2020

2 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 2: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 3: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 4: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 5: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 6: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 7: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 8: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 9: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 10: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

10

Figure 6: Sphericity tests

Figure 7: Combined table of contents and repeated measures analysis

Statistics, Data Analysis, and ModelingStatistics, Data Analysis, and Modeling

Page 11: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 12: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 13: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 14: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 15: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 16: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 17: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 18: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 19: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 20: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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

Page 21: SUGI 23: It Chops, It Dices, It Makes Julienne Slices! ODS ......2 6roxwlrq2'67kh 2'6surylghvdpruhioh[leohphfkdqlvpiruurfhgsxuhvwrurgsxfhrxwxw ,sqvwhdgrizulwlqjwrwkh olvwlqjilohgluhfwo\

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