%PDF-1.7
%
1076 0 obj
<>/Metadata 1111 0 R/Pages 1073 0 R/StructTreeRoot 60 0 R/Type/Catalog/ViewerPreferences 1092 0 R>>
endobj
1111 0 obj
<>stream
11.0
8.5
9
2019-04-24T14:01:11.014-04:00
Microsoft® Word for Office 365
Jenna Cody
513a84437121b36f408841ddfd8293e4209bac4f
195626
"SAS, software, clinical trials, shift tables, PROC SQL, programming, biostatistics"
Microsoft® Word for Office 365
<p>Shift tables display the change in the frequency of subjects across specified categories from baseline to post-baseline time points. They are commonly used in clinical data to display the shift in the values of laboratory parameters, ECG interpretations, or other ordinal variables of interest across visits. The INTO clause in the SQL procedure can be used to create macro variables for the denominators used in these tables. These macro variables can be accessed throughout the program, allowing for easy computation of percentages and the ability to call the same macro variable to display the subject count value in the header. This paper outlines the steps for creating a shift table using an example with dummy data. It describes the process of creating macro variables in PROC SQL using the INTO clause, creating shift table shells using the DATA step, conducting frequency tabulations using PROC FREQ, calling the macro variables to calculate and present the incidence and percent, and using the macro variables for the subject count value in the headers. It then discusses the efficiency of the use of PROC SQL to create macro variable denominators over other methods of calculating denominators, such as in PROC FREQ. Code examples are provided to compare shift table generation techniques.</p>
<p>Jenna Cody, IQVIA</p>
<p style="font-family: Arial,Helvetica,sans-serif; font-size: 90%; line-height: 300%; margin: -3em 0em 2em 0em;"><a href="https://github.com/sascommunities/sas-global-forum-2019">Access sample code</a></p>
Session 3928
en
jeff
<p>Shift tables display the change in the frequency of subjects across specified categories from baseline to post-baseline time points. They are commonly used in clinical data to display the shift in the values of laboratory parameters, ECG interpretations, or other ordinal variables of interest across visits. The INTO clause in the SQL procedure can be used to create macro variables for the denominators used in these tables. These macro variables can be accessed throughout the program, allowing for easy computation of percentages and the ability to call the same macro variable to display the subject count value in the header. This paper outlines the steps for creating a shift table using an example with dummy data. It describes the process of creating macro variables in PROC SQL using the INTO clause, creating shift table shells using the DATA step, conducting frequency tabulations using PROC FREQ, calling the macro variables to calculate and present the incidence and percent, and using the macro variables for the subject count value in the headers. It then discusses the efficiency of the use of PROC SQL to create macro variable denominators over other methods of calculating denominators, such as in PROC FREQ. Code examples are provided to compare shift table generation techniques.</p>
<p><a href="https://github.com/sascommunities/sas-global-forum-2019">Access sample code files now</a></p>
<p>Jenna Cody, IQVIA<br>
</p>
Microsoft® Word for Office 365
2019-04-12T16:30:16.000-04:00
2019-04-12T16:30:16.000-04:00
2019-03-25T19:28:12.000-04:00
application/pdf
SAS, software, clinical trials, shift tables, PROC SQL, programming, biostatistics
2019-04-24T14:01:08.487-04:00
Jenna Cody
Shift tables display the change in the frequency of subjects across specified categories from baseline to post-baseline time points. They are commonly used in clinical data to display the shift in the values of laboratory parameters, ECG interpretations, or other ordinal variables of interest across visits. The INTO clause in the SQL procedure can be used to create macro variables for the denominators used in these tables. These macro variables can be accessed throughout the program, allowing for easy computation of percentages and the ability to call the same macro variable to display the subject count value in the header. This paper outlines the steps for creating a shift table using an example with dummy data. It describes the process of creating macro variables in PROC SQL using the INTO clause, creating shift table shells using the DATA step, conducting frequency tabulations using PROC FREQ, calling the macro variables to calculate and present the incidence and percent, and using the macro variables for the subject count value in the headers. It then discusses the efficiency of the use of PROC SQL to create macro variable denominators over other methods of calculating denominators, such as in PROC FREQ. Code examples are provided to compare shift table generation techniques.
Access sample code files now
Jenna Cody, IQVIA
Using PROC SQL to Generate Shift Tables More Efficiently
uuid:F6CA7418-C4FD-4343-B1E0-096E5DAA93D7
uuid:480375c9-a29f-421a-9277-74f19b45d0a8
thirdparty
support:customer-roles/programmer
support:sgf-papers/topic/data-management/data-quality
support:sgf-papers
support:skill-level/intermediate
industry:3150
software:BASE
year:2019
event-type:180/session-type/breakout
endstream
endobj
1073 0 obj
<>
endobj
60 0 obj
<>
endobj
1092 0 obj
<>
endobj
61 0 obj
<>
endobj
62 0 obj
<>
endobj
63 0 obj
[98 0 R 99 0 R 100 0 R 101 0 R 102 0 R 103 0 R 104 0 R 105 0 R 106 0 R 107 0 R 108 0 R 109 0 R 110 0 R 111 0 R 112 0 R]
endobj
64 0 obj
[113 0 R 1048 0 R 1072 0 R 1049 0 R 1070 0 R 1050 0 R 1045 0 R 1068 0 R 1046 0 R 1066 0 R 1047 0 R 1043 0 R 1064 0 R 1044 0 R 117 0 R 118 0 R 119 0 R 120 0 R 121 0 R 122 0 R 123 0 R 124 0 R]
endobj
65 0 obj
<>
endobj
66 0 obj
<>
endobj
67 0 obj
<>
endobj
68 0 obj
<>
endobj
69 0 obj
<>
endobj
70 0 obj
[1042 0 R 1041 0 R 1040 0 R 1039 0 R 1038 0 R 1032 0 R 1031 0 R 1030 0 R 1029 0 R 1028 0 R 1022 0 R 1021 0 R 1020 0 R 1019 0 R 1018 0 R 1017 0 R 1016 0 R 1008 0 R 1007 0 R 1006 0 R 1005 0 R 1004 0 R 1003 0 R 1002 0 R 994 0 R 993 0 R 992 0 R 991 0 R 990 0 R 989 0 R 988 0 R 980 0 R 979 0 R 978 0 R 977 0 R 976 0 R 975 0 R 974 0 R 966 0 R 965 0 R 964 0 R 963 0 R 962 0 R 961 0 R 960 0 R 952 0 R 951 0 R 950 0 R 949 0 R 948 0 R 947 0 R 946 0 R 938 0 R 937 0 R 936 0 R 935 0 R 934 0 R 933 0 R 932 0 R 924 0 R 923 0 R 922 0 R 921 0 R 920 0 R 919 0 R 918 0 R 910 0 R 909 0 R 908 0 R 907 0 R 906 0 R 905 0 R 904 0 R 896 0 R 895 0 R 894 0 R 893 0 R 892 0 R 891 0 R 890 0 R 882 0 R 881 0 R 880 0 R 879 0 R 878 0 R 877 0 R 876 0 R 868 0 R 867 0 R 866 0 R 865 0 R 864 0 R 863 0 R 862 0 R 854 0 R 853 0 R 852 0 R 851 0 R 850 0 R 849 0 R 848 0 R 840 0 R 839 0 R 838 0 R 837 0 R 836 0 R 835 0 R 834 0 R 826 0 R 825 0 R 824 0 R 823 0 R 822 0 R 821 0 R 820 0 R 812 0 R 811 0 R 810 0 R 809 0 R 808 0 R 807 0 R 806 0 R 798 0 R 797 0 R 796 0 R 795 0 R 794 0 R 793 0 R 792 0 R 784 0 R 783 0 R 782 0 R 781 0 R 780 0 R 779 0 R 778 0 R 770 0 R 769 0 R 768 0 R 767 0 R 766 0 R 765 0 R 764 0 R 756 0 R 755 0 R 754 0 R 753 0 R 752 0 R 751 0 R 750 0 R 742 0 R 741 0 R 740 0 R 739 0 R 738 0 R 737 0 R 736 0 R 728 0 R 727 0 R 726 0 R 725 0 R 724 0 R 723 0 R 722 0 R 714 0 R 713 0 R 712 0 R 711 0 R 710 0 R 709 0 R 708 0 R 700 0 R 699 0 R 698 0 R 697 0 R 696 0 R 695 0 R 694 0 R 126 0 R 127 0 R 659 0 R 658 0 R 657 0 R 656 0 R 651 0 R 650 0 R 649 0 R 644 0 R 645 0 R 643 0 R 642 0 R 641 0 R 639 0 R 640 0 R 638 0 R 637 0 R 636 0 R 634 0 R 635 0 R 624 0 R 623 0 R 622 0 R 621 0 R 620 0 R 619 0 R 618 0 R 617 0 R 616 0 R 606 0 R 605 0 R 604 0 R 603 0 R 602 0 R 601 0 R 600 0 R 599 0 R 598 0 R 588 0 R 587 0 R 586 0 R 585 0 R 584 0 R 583 0 R 582 0 R 581 0 R 580 0 R 570 0 R 569 0 R 568 0 R 567 0 R 566 0 R 565 0 R 564 0 R 563 0 R 562 0 R 552 0 R 551 0 R 550 0 R 549 0 R 548 0 R 547 0 R 546 0 R 545 0 R 544 0 R 534 0 R 533 0 R 532 0 R 531 0 R 530 0 R 529 0 R 528 0 R 527 0 R 526 0 R 516 0 R 515 0 R 514 0 R 513 0 R 512 0 R 511 0 R 510 0 R 509 0 R 508 0 R 498 0 R 497 0 R 496 0 R 495 0 R 494 0 R 493 0 R 492 0 R 491 0 R 490 0 R 480 0 R 479 0 R 478 0 R 477 0 R 476 0 R 475 0 R 474 0 R 473 0 R 472 0 R 462 0 R 461 0 R 460 0 R 459 0 R 458 0 R 457 0 R 456 0 R 455 0 R 454 0 R 444 0 R 443 0 R 442 0 R 441 0 R 440 0 R 439 0 R 438 0 R 437 0 R 436 0 R 426 0 R 425 0 R 424 0 R 423 0 R 422 0 R 421 0 R 420 0 R 419 0 R 418 0 R 408 0 R 407 0 R 406 0 R 405 0 R 404 0 R 403 0 R 402 0 R 401 0 R 400 0 R 390 0 R 389 0 R 388 0 R 387 0 R 386 0 R 385 0 R 384 0 R 383 0 R 382 0 R 372 0 R 371 0 R 370 0 R 369 0 R 368 0 R 367 0 R 366 0 R 365 0 R 364 0 R 129 0 R 130 0 R 131 0 R 334 0 R 1062 0 R 335 0 R 133 0 R]
endobj
71 0 obj
<>
endobj
72 0 obj
[134 0 R 134 0 R 135 0 R 135 0 R 136 0 R 136 0 R 137 0 R 137 0 R 138 0 R 139 0 R 139 0 R 140 0 R 140 0 R 141 0 R 141 0 R 142 0 R 142 0 R 143 0 R 143 0 R 144 0 R 145 0 R 145 0 R 146 0 R 146 0 R 147 0 R 147 0 R 148 0 R 149 0 R 149 0 R 150 0 R 150 0 R 151 0 R 151 0 R 152 0 R 152 0 R 153 0 R 153 0 R 154 0 R 154 0 R 155 0 R 156 0 R 156 0 R 157 0 R 157 0 R 158 0 R 158 0 R 159 0 R 159 0 R 160 0 R 160 0 R 161 0 R 162 0 R 163 0 R 164 0 R 165 0 R 166 0 R 166 0 R 167 0 R 167 0 R 168 0 R 168 0 R 169 0 R 169 0 R 170 0 R 170 0 R 171 0 R 171 0 R 172 0 R 172 0 R 173 0 R 173 0 R 174 0 R 174 0 R 175 0 R 175 0 R 176 0 R 176 0 R 177 0 R 177 0 R 178 0 R 178 0 R]
endobj
73 0 obj
[179 0 R 180 0 R 181 0 R 182 0 R 183 0 R 1060 0 R 333 0 R 185 0 R 186 0 R 187 0 R 188 0 R 189 0 R 190 0 R 191 0 R 192 0 R 193 0 R 194 0 R 195 0 R 196 0 R 197 0 R 198 0 R 199 0 R 200 0 R]
endobj
74 0 obj
<>
endobj
75 0 obj
[201 0 R 202 0 R 203 0 R 203 0 R 1058 0 R 332 0 R 205 0 R 206 0 R 207 0 R 208 0 R 209 0 R 210 0 R 211 0 R 212 0 R 213 0 R 214 0 R 215 0 R 216 0 R 217 0 R 218 0 R 219 0 R 220 0 R 221 0 R 222 0 R 223 0 R 224 0 R 225 0 R 226 0 R 227 0 R 228 0 R 229 0 R]
endobj
76 0 obj
<>
endobj
77 0 obj
[230 0 R 231 0 R 232 0 R 233 0 R 234 0 R 235 0 R 236 0 R 237 0 R 238 0 R 239 0 R 240 0 R 241 0 R 242 0 R 243 0 R 244 0 R 245 0 R 246 0 R 247 0 R 248 0 R 249 0 R 250 0 R 251 0 R 252 0 R 253 0 R 254 0 R 255 0 R 256 0 R 257 0 R 258 0 R 259 0 R 260 0 R 261 0 R 262 0 R 263 0 R 264 0 R 265 0 R 266 0 R 267 0 R 268 0 R 269 0 R 270 0 R 271 0 R 272 0 R 273 0 R 330 0 R 1056 0 R 331 0 R 275 0 R 275 0 R 276 0 R 276 0 R 277 0 R 277 0 R 278 0 R 278 0 R 279 0 R 279 0 R 1054 0 R 329 0 R]
endobj
78 0 obj
<>
endobj
79 0 obj
<>
endobj
80 0 obj
[281 0 R 282 0 R 283 0 R 284 0 R 285 0 R 286 0 R 287 0 R 288 0 R 289 0 R 290 0 R 291 0 R 292 0 R 293 0 R 294 0 R 295 0 R 296 0 R 297 0 R 298 0 R 299 0 R 300 0 R 301 0 R 302 0 R 302 0 R 303 0 R 303 0 R 304 0 R 304 0 R 305 0 R 305 0 R 306 0 R 306 0 R 307 0 R 307 0 R 308 0 R 308 0 R 309 0 R 309 0 R 310 0 R 310 0 R 311 0 R 311 0 R 312 0 R 312 0 R 313 0 R 313 0 R 1052 0 R 328 0 R 315 0 R 316 0 R 317 0 R 318 0 R 319 0 R 320 0 R 321 0 R 322 0 R 323 0 R 324 0 R 325 0 R 326 0 R 327 0 R]
endobj
81 0 obj
<>
endobj
82 0 obj
[83 0 R 84 0 R 85 0 R 86 0 R 87 0 R 88 0 R 89 0 R 90 0 R 91 0 R 92 0 R 93 0 R 94 0 R 95 0 R 96 0 R]
endobj
83 0 obj
<>
endobj
84 0 obj
<>
endobj
85 0 obj
<>
endobj
86 0 obj
<>
endobj
87 0 obj
<>
endobj
88 0 obj
<>
endobj
89 0 obj
<>
endobj
90 0 obj
<>
endobj
91 0 obj
<>
endobj
92 0 obj
<>
endobj
93 0 obj
<>
endobj
94 0 obj
<>
endobj
95 0 obj
<>
endobj
96 0 obj
<>
endobj
97 0 obj
<>
endobj
17 0 obj
<>/MediaBox[0 0 612 792]/Parent 1073 0 R/Resources<>/Font<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]>>/Rotate 0/StructParents 19/Tabs/S/Type/Page>>
endobj
18 0 obj
<>stream
x\YoH~7Gqy3x
w
;c7>ڧO[25$S'7y;w'<~1X˃1[ġ;Wq_m~P-h L-ܘq2fp;NIM&4 0L'fgJHEeDɓM}\>5MLɐ8xDzo>>XmR(m0p`IdȰҺkGcye,dTeFt#Pjk֚sk'}@F魄:&Fz3:>{(le` ;
+XpFG܌LX[\.Z6߭?
.bGF.jY)R$,}eAWxz6<]T[?2lsOP<%F:qS8O 3)&S"
~
6 LKEtdG`e?$ڡ1Y L