1                                        The SAS System         09:37 Wednesday, October 21, 2009

NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA. 
NOTE: SAS (r) 9.1 (TS1M3)
      Licensed to SY TRUONG, Site 0051884001.
NOTE: This session is executing on the XP_PRO  platform.



NOTE: (E9BX04) SAS 9.1.3 SP 4

NOTE: SAS initialization used:
      real time           0.64 seconds
      cpu time            0.56 seconds
      

NOTE: AUTOEXEC processing beginning; file is C:\apache\htdocs\cdiscbuilder\saspgm\autoexec.sas.

NOTE: Libref _CDISC_ was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: C:\apache\htdocs\cdiscbuilder\saspgm

NOTE: AUTOEXEC processing completed.

1          /*------------------------------------------------------------*
2          * program:     cdisc19.sas                                     *
3          * Description: Zero Rows Identifies domain table that has zero rows and therefore
3        ! contains no data. Case #19*
4          * By:          Sy Truong, 10/14/2009                          *
5          *-------------------------------------------------------------*/
6          
7          libname templib '../data';
NOTE: Libref TEMPLIB was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: C:\apache\htdocs\cdiscbuilder\data
8          
9          *** Create some data to be selected ***;
10         data templib.dv(label="Protocol Deviations");
11         attrib STUDYID	label="Study Identifier" length=$100;
12         attrib DOMAIN	label="Domain Abbreviation"	length=$100;
13         attrib USUBJID	label="Unique Subject Identifier"	length=$100;
14         attrib DVSEQ	label="Sequence Number"	length=8;
15         attrib DVREFID	label="Reference ID"	length=$100;
16         attrib DVSPID	label="Sponsor-Defined Identifier"	length=$100;
17         attrib DVTERM	label="Protocol Deviation Term"	length=$100;
18         attrib DVDECOD	label="Protocol Deviation Coded Term"	length=$100;
19         attrib DVCAT	label="Category for Protocol Deviation"	length=$100;
20         attrib DVSCAT	label="Subcategory for Protocol Deviation"	length=$100;
21         attrib EPOCH	label="Epoch"	length=$100;
22         attrib DVSTDTC	label="Start Date/Time of Deviation"	length=$100;
23         attrib DVENDTC	label="End Date/Time of Deviation"	length=$100;
24         if (1=1) then delete;
25         run;

NOTE: Variable STUDYID is uninitialized.
2                                        The SAS System         09:37 Wednesday, October 21, 2009

NOTE: Variable DOMAIN is uninitialized.
NOTE: Variable USUBJID is uninitialized.
NOTE: Variable DVSEQ is uninitialized.
NOTE: Variable DVREFID is uninitialized.
NOTE: Variable DVSPID is uninitialized.
NOTE: Variable DVTERM is uninitialized.
NOTE: Variable DVDECOD is uninitialized.
NOTE: Variable DVCAT is uninitialized.
NOTE: Variable DVSCAT is uninitialized.
NOTE: Variable EPOCH is uninitialized.
NOTE: Variable DVSTDTC is uninitialized.
NOTE: Variable DVENDTC is uninitialized.
NOTE: The data set TEMPLIB.DV has 0 observations and 13 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.04 seconds
      

26         %cdisc(datlib=templib,datname=dv);

27                              data misobs(keep=obsnum);
28                                 retain obsnum 0;
29                                 set templib.dv(keep=STUDYID);
30                                 obsnum=obsnum+1;
31                                 if missing(STUDYID) then
32                                    output;
33                              run;

NOTE: There were 0 observations read from the data set TEMPLIB.DV.
NOTE: The data set WORK.MISOBS has 0 observations and 1 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

34                              data misobs(keep=obsnum);
35                                 retain obsnum 0;
36                                 set templib.dv(keep=DOMAIN);
37                                 obsnum=obsnum+1;
38                                 if missing(DOMAIN) then
39                                    output;
40                              run;

NOTE: There were 0 observations read from the data set TEMPLIB.DV.
NOTE: The data set WORK.MISOBS has 0 observations and 1 variables.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds
      

41                              data misobs(keep=obsnum);
42                                 retain obsnum 0;
43                                 set templib.dv(keep=USUBJID);
3                                        The SAS System         09:37 Wednesday, October 21, 2009

44                                 obsnum=obsnum+1;
45                                 if missing(USUBJID) then
46                                    output;
47                              run;

NOTE: There were 0 observations read from the data set TEMPLIB.DV.
NOTE: The data set WORK.MISOBS has 0 observations and 1 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

48         data _30;
49         retain obsnum 0;
50         set templib.dv(keep=DVSTDTC DVENDTC);
51         obsnum = obsnum + 1;
52         run;

NOTE: There were 0 observations read from the data set TEMPLIB.DV.
NOTE: The data set WORK._30 has 0 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

53         data _30;
54         set _30;
55         if DVSTDTC ne "" and DVENDTC ne "" and input(DVSTDTC,is8601da.) gt
55       ! input(DVENDTC,is8601da.) then output;
56         run;

NOTE: There were 0 observations read from the data set WORK._30.
NOTE: The data set WORK._30 has 0 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.04 seconds
      

57         proc sort data=templib.dv out=dv nodupkey;
58         by usubjid;
59         run;

NOTE: Input data set is empty.
NOTE: 0 observations with duplicate key values were deleted.
NOTE: The data set WORK.DV has 0 observations and 13 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds
      

NOTE: Table WORK._72 created, with 0 rows and 1 columns.

60         data _111;
4                                        The SAS System         09:37 Wednesday, October 21, 2009

61         retain obsnum 0;
62         set templib.dv;
63         obsnum = obsnum + 1;
64         if DVTERM ne '' then do;
65         output;
66         end;
67         run;

NOTE: There were 0 observations read from the data set TEMPLIB.DV.
NOTE: The data set WORK._111 has 0 observations and 14 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

68         proc sort data=_111 out =_1112 NODUPKEY;
69         by DVTERM;
70         run;

NOTE: Input data set is empty.
NOTE: 0 observations with duplicate key values were deleted.
NOTE: The data set WORK._1112 has 0 observations and 14 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

71         proc sort data=_111 out =_1113 NODUPKEY;
72         by DVDECOD;
73         run;

NOTE: Input data set is empty.
NOTE: 0 observations with duplicate key values were deleted.
NOTE: The data set WORK._1113 has 0 observations and 14 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds
      

74                  proc sort data=cdisc nodupkey;
75                     by libname datname datlab variable length label type case comment;
76                  run;

NOTE: There were 13 observations read from the data set WORK.CDISC.
NOTE: 0 observations with duplicate key values were deleted.
NOTE: The data set WORK.CDISC has 13 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds
      

77               proc sort data = work.cdisc;
78                  by libname datname datlab variable case;
5                                        The SAS System         09:37 Wednesday, October 21, 2009

79               run;

NOTE: There were 13 observations read from the data set WORK.CDISC.
NOTE: The data set WORK.CDISC has 13 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds
      

80         
81               proc format;
82                  *** Generate the comments for the CDISC evaluation case number ***;
83                  value $casefmt
84                  '1' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#1">1</a>'
85                  '2' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#2">2</a>'
86                  '3' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#3">3</a>'
87                  '4' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#4">4</a>'
88                  '5' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#5">5</a>'
89                  '6' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#6">6</a>'
90                  '7' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#7">7</a>'
91                  '8' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#8">8</a>'
92                  '9' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#9">9</a>'
93                  '10' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#10">10</a>'
94                  '11' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#11">11</a>'
95                  '12' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#12">12</a>'
96                  '13' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#13">13</a>'
97                  '14' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#14">14</a>'
98                  '15' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#15">15</a>'
99                  '16' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#16">16</a>'
100                 '17' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#17">17</a>'
101                 '18' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#18">18</a>'
102                 '19' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#19">19</a>'
103                 '20' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#20">20</a>'
104                 '21' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#21">21</a>'
105                 '22' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#22">22</a>'
106                 '23' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#23">23</a>'
107                 '24' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#24">24</a>'
108                 '25' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#25">25</a>'
109                 '26' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#26">26</a>'
110                 '27' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#27">27</a>'
111                 '28' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#28">28</a>'
112                 '29' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#29">29</a>'
113                 '30' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#30">30</a>'
114                 '31' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#31">31</a>'
115                 '32' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#32">32</a>'
116                 '33' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#33">33</a>'
117                 '34' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#34">34</a>'
118                 '35' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#35">35</a>'
119                 '36' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#36">36</a>'
120                 '37' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#37">37</a>'
121                 '38' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#38">38</a>'
122                 '39' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#39">39</a>'
123                 '40' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#40">40</a>'
6                                        The SAS System         09:37 Wednesday, October 21, 2009

124                 '41' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#41">41</a>'
125                 '42' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#42">42</a>'
126                 '43' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#43">43</a>'
127                 '44' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#44">44</a>'
128                 '45' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#45">45</a>'
129                 '46' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#46">46</a>'
130                 '47' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#47">47</a>'
131                 '48' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#48">48</a>'
132                 '49' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#49">49</a>'
133                 '50' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#50">50</a>'
134                 '51' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#51">51</a>'
135                 '52' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#52">52</a>'
136                 '53' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#53">53</a>'
137                 '54' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#54">54</a>'
138                 '55' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#55">55</a>'
139                 '56' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#56">56</a>'
140                 '57' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#57">57</a>'
141                 '58' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#58">58</a>'
142                 '59' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#59">59</a>'
143                 '60' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#60">60</a>'
144                 '61' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#61">61</a>'
145                 '62' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#62">62</a>'
146                 '63' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#63">63</a>'
147                 '64' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#64">64</a>'
148                 '65' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#65">65</a>'
149                 '66' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#66">66</a>'
150                 '67' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#67">67</a>'
151                 '68' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#68">68</a>'
152                 '69' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#69">69</a>'
153                 '70' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#70">70</a>'
154                 '71' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#71">71</a>'
155                 '72' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#72">72</a>'
156                 '73' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#73">73</a>'
157                 '74' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#74">74</a>'
158                 '75' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#75">75</a>'
159                 '76' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#76">76</a>'
160                 '77' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#77">77</a>'
161                 '78' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#78">78</a>'
162                 '79' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#79">79</a>'
163                 '80' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#80">80</a>'
164                 '81' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#81">81</a>'
165                 '82' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#82">82</a>'
166                 '83' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#83">83</a>'
167                 '84' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#84">84</a>'
168                 '85' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#85">85</a>'
169                 '86' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#86">86</a>'
170                 '87' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#87">87</a>'
171                 '88' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#88">88</a>'
172                 '89' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#89">89</a>'
173                 '90' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#90">90</a>'
174                 '91' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#91">91</a>'
175                 '92' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#92">92</a>'
176                 '93' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#93">93</a>'
7                                        The SAS System         09:37 Wednesday, October 21, 2009

177                 '94' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#94">94</a>'
178                 '95' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#95">95</a>'
179                 '96' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#96">96</a>'
180                 '97' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#97">97</a>'
181                 '98' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#98">98</a>'
182                 '99' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#99">99</a>'
183                 '100' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#100">100</a>'
184                 '101' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#101">101</a>'
185                 '102' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#102">102</a>'
186                 '103' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#103">103</a>'
187                 '104' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#104">104</a>'
188                 '105' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#105">105</a>'
189                 '106' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#106">106</a>'
190                 '107' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#107">107</a>'
191                 '108' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#108">108</a>'
192                 '109' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#109">109</a>'
193                 '110' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#110">110</a>'
194                 '111' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#111">111</a>'
195                 '112' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#112">112</a>'
196                 '113' = '<a href="http://meta-x.com/cdiscbuilder/cdisc.html#113">113</a>';
NOTE: Format $CASEFMT has been output.
197        
198        
199        
200                 *** Generate the format for the bookmark of variables ***;
201                 value $bookfmt
202                 "dv.studyid" = '<a name="dv.studyid">dv.studyid</a>'
203                 "dv.domain" = '<a name="dv.domain">dv.domain</a>'
204                 "dv.usubjid" = '<a name="dv.usubjid">dv.usubjid</a>'
205                 "dv.dvseq" = '<a name="dv.dvseq">dv.dvseq</a>'
206                 "dv.dvrefid" = '<a name="dv.dvrefid">dv.dvrefid</a>'
207                 "dv.dvspid" = '<a name="dv.dvspid">dv.dvspid</a>'
208                 "dv.dvterm" = '<a name="dv.dvterm">dv.dvterm</a>'
209                 "dv.dvdecod" = '<a name="dv.dvdecod">dv.dvdecod</a>'
210                 "dv.dvcat" = '<a name="dv.dvcat">dv.dvcat</a>'
211                 "dv.dvscat" = '<a name="dv.dvscat">dv.dvscat</a>'
212                 "dv.epoch" = '<a name="dv.epoch">dv.epoch</a>'
213                 "dv.dvstdtc" = '<a name="dv.dvstdtc">dv.dvstdtc</a>'
214                 "dv.dvendtc" = '<a name="dv.dvendtc">dv.dvendtc</a>'
215                 ;
NOTE: Format $BOOKFMT has been output.
216        
217                 *** Generate the format for dataset linking ***;
218                 value $datfmt
219                 "ae" = '<a name="ae">ae</a><br>'
220                 "ae3a" = '<a name="ae3a">ae3a</a><br>'
221                 "cdisc10" = '<a name="cdisc10">cdisc10</a><br>'
222                 "cdisc11" = '<a name="cdisc11">cdisc11</a><br>'
223                 "cdisc14" = '<a name="cdisc14">cdisc14</a><br>'
224                 "cdisc15" = '<a name="cdisc15">cdisc15</a><br>'
225                 "cdisc18" = '<a name="cdisc18">cdisc18</a><br>'
226                 "cdisc2" = '<a name="cdisc2">cdisc2</a><br>'
227                 "cdisc21" = '<a name="cdisc21">cdisc21</a><br>'
8                                        The SAS System         09:37 Wednesday, October 21, 2009

228                 "cdisc2b_1" = '<a name="cdisc2b_1">cdisc2b_1</a><br>'
229                 "cdisc2b_2" = '<a name="cdisc2b_2">cdisc2b_2</a><br>'
230                 "cdisc2b_3" = '<a name="cdisc2b_3">cdisc2b_3</a><br>'
231                 "cdisc2_b" = '<a name="cdisc2_b">cdisc2_b</a><br>'
232                 "cdisc2_c" = '<a name="cdisc2_c">cdisc2_c</a><br>'
233                 "cdisc4" = '<a name="cdisc4">cdisc4</a><br>'
234                 "cdisc5" = '<a name="cdisc5">cdisc5</a><br>'
235                 "cdisc6" = '<a name="cdisc6">cdisc6</a><br>'
236                 "cdisc7" = '<a name="cdisc7">cdisc7</a><br>'
237                 "cdisc8" = '<a name="cdisc8">cdisc8</a><br>'
238                 "cdisc9" = '<a name="cdisc9">cdisc9</a><br>'
239                 "ce" = '<a name="ce">ce</a><br>'
240                 "cm" = '<a name="cm">cm</a><br>'
241                 "co" = '<a name="co">co</a><br>'
242                 "da" = '<a name="da">da</a><br>'
243                 "dm" = '<a name="dm">dm</a><br>'
244                 "ds" = '<a name="ds">ds</a><br>'
245                 "dv" = '<a name="dv">dv</a><br>'
246                 "eg" = '<a name="eg">eg</a><br>'
247                 "ex" = '<a name="ex">ex</a><br>'
248                 "fa" = '<a name="fa">fa</a><br>'
249                 "ie" = '<a name="ie">ie</a><br>'
250                 "lb" = '<a name="lb">lb</a><br>'
251                 "mb" = '<a name="mb">mb</a><br>'
252                 "mh" = '<a name="mh">mh</a><br>'
253                 "ms" = '<a name="ms">ms</a><br>'
254                 "notdm" = '<a name="notdm">notdm</a><br>'
255                 "pc" = '<a name="pc">pc</a><br>'
256                 "pe" = '<a name="pe">pe</a><br>'
257                 "pp" = '<a name="pp">pp</a><br>'
258                 "qs" = '<a name="qs">qs</a><br>'
259                 "relrec" = '<a name="relrec">relrec</a><br>'
260                 "sc" = '<a name="sc">sc</a><br>'
261                 "se" = '<a name="se">se</a><br>'
262                 "su" = '<a name="su">su</a><br>'
263                 "supmh" = '<a name="supmh">supmh</a><br>'
264                 "suppae" = '<a name="suppae">suppae</a><br>'
265                 "suppp" = '<a name="suppp">suppp</a><br>'
266                 "supte" = '<a name="supte">supte</a><br>'
267                 "supvs" = '<a name="supvs">supvs</a><br>'
268                 "sv" = '<a name="sv">sv</a><br>'
269                 "ta" = '<a name="ta">ta</a><br>'
270                 "te" = '<a name="te">te</a><br>'
271                 "ti" = '<a name="ti">ti</a><br>'
272                 "ts" = '<a name="ts">ts</a><br>'
273                 "tv" = '<a name="tv">tv</a><br>'
274                 "vs" = '<a name="vs">vs</a><br>'
275                 ;
NOTE: Format $DATFMT has been output.
276              run;

NOTE: PROCEDURE FORMAT used (Total process time):
      real time           0.06 seconds
9                                        The SAS System         09:37 Wednesday, October 21, 2009

      cpu time            0.01 seconds
      

277        
278              data work.cdisc;
279                 set work.cdisc;
280                 by libname datname datlab variable case;
281        
282                 attrib datvar label="Dataset and Variable" length=$100 format=$bookfmt.;
283                 if variable ne '' then
284                 datvar = compress(lowcase(datname) || "." || lowcase(variable));
285                 else datvar = lowcase(datname);
286                 /*format case casefmt.;*/
287                 attrib charcase label = "Case Number" length = $10;
288                 charcase = trim(left(put(case, best.)));
289                 format charcase $casefmt.;
290                 *format datname $datfmt.;
291              run;

NOTE: There were 13 observations read from the data set WORK.CDISC.
NOTE: The data set WORK.CDISC has 13 observations and 13 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.04 seconds
      

292        
293              *** Remove The Special Characters ******;
294              proc template;
295                 define style styles.test/store=work.test;
296                 parent=styles.default;
297                 style byline from titlesandfooters /
298                    protectspecialchars=off;
299                 end;
NOTE: STYLE 'Styles.Test' has been saved to: WORK.TEST
300              run;
NOTE: PROCEDURE TEMPLATE used (Total process time):
      real time           0.07 seconds
      cpu time            0.03 seconds
      

301        
302              proc sort data = work.cdisc;
303                 by libname datname datlab variable case;
304              run;

NOTE: There were 13 observations read from the data set WORK.CDISC.
NOTE: The data set WORK.CDISC has 13 observations and 13 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.04 seconds
      cpu time            0.04 seconds
      

10                                       The SAS System         09:37 Wednesday, October 21, 2009

305        
306              ods listing close;
307              ods html file='cdisc19.html' style=styles.mxistyle;
NOTE: Writing HTML Body file: cdisc19.html
308              data work.dv (drop=usrname datetime);
309                 set work.cdisc;
310                 where lowcase(datname)=lowcase("dv");
311              run;

NOTE: There were 13 observations read from the data set WORK.CDISC.
      WHERE LOWCASE(datname)='dv';
NOTE: The data set WORK.DV has 13 observations and 11 variables.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds
      

312                       data dv(drop=xxx);
313                          set dv;
314                          retain xxx 0;
315                          if xxx = 2 then xxx = 1;
316                          else xxx = xxx + 1;
317                          yyy = compress(put(xxx,best.));
318                       run;

NOTE: There were 13 observations read from the data set WORK.DV.
NOTE: The data set WORK.DV has 13 observations and 12 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

319        
320              %let newlab = %nrbquote(Protocol Deviations);
321              title1 height=2 '<a name="dv"> Findings from CDISC Evaluation</a>';
322              title2 height=2 "Data Table Name = dv Data Table Label=&newlab";
323              footnote1 height=2 "Generated on: 10/21/2009,  9:37:38 am, Administrator";
324              footnote2 height=2 "Located at: C:\apache\htdocs\cdiscbuilder\data";
325               proc report data = work.dv nowindows;
326                    column obs libname datvar label type length charcase comment yyy;
327                       define obs/computed 'Obs';
328                       define libname/width=20;
329                       define datvar/width=50;
330                       define label/width=50;
331                       define type/width=20;
332                       define length/width=50;
333                       define comment/width=50;
334                       define charcase/width=50;
335                       define yyy/ noprint;
336        
337                    compute yyy;
338                       if yyy = "2" then do;
339                          call define (_row_,'style','STYLE=[BACKGROUND=cxFFFFCC]');
11                                       The SAS System         09:37 Wednesday, October 21, 2009

340                       end;
341                    endcompute;
342        
343                    compute charcase;
344                       if charcase='1' then call define
344      ! ('charcase','style','STYLE=[BACKGROUND=CXccffcc JUST=CENTER]');
345                       if charcase='2' then call define
345      ! ('charcase','style','STYLE=[BACKGROUND=CXcd0030 JUST=CENTER]');
346                       if charcase='3' then call define
346      ! ('charcase','style','STYLE=[BACKGROUND=CXcd0094 JUST=CENTER]');
347                       if charcase='4' then call define
347      ! ('charcase','style','STYLE=[BACKGROUND=CXcd00f8 JUST=CENTER]');
348                       if charcase='5' then call define
348      ! ('charcase','style','STYLE=[BACKGROUND=CXcd015c JUST=CENTER]');
349                       if charcase='6' then call define
349      ! ('charcase','style','STYLE=[BACKGROUND=CXcd01c0 JUST=CENTER]');
350                       if charcase='7' then call define
350      ! ('charcase','style','STYLE=[BACKGROUND=CXcd0224 JUST=CENTER]');
351                       if charcase='8' then call define
351      ! ('charcase','style','STYLE=[BACKGROUND=CXcd0288 JUST=CENTER]');
352                       if charcase='9' then call define
352      ! ('charcase','style','STYLE=[BACKGROUND=CXcd02ec JUST=CENTER]');
353                       if charcase='10' then call define
353      ! ('charcase','style','STYLE=[BACKGROUND=CXcd0350 JUST=CENTER]');
354                       if charcase='11' then call define
354      ! ('charcase','style','STYLE=[BACKGROUND=CXcd03b4 JUST=CENTER]');
355                       if charcase='12' then call define
355      ! ('charcase','style','STYLE=[BACKGROUND=CXcd0418 JUST=CENTER]');
356                       if charcase='13' then call define
356      ! ('charcase','style','STYLE=[BACKGROUND=CXcd047c JUST=CENTER]');
357                       if charcase='14' then call define
357      ! ('charcase','style','STYLE=[BACKGROUND=CXcd04e0 JUST=CENTER]');
358                       if charcase='15' then call define
358      ! ('charcase','style','STYLE=[BACKGROUND=CXcd0544 JUST=CENTER]');
359                       if charcase='16' then call define
359      ! ('charcase','style','STYLE=[BACKGROUND=CXcd05a8 JUST=CENTER]');
360                       if charcase='17' then call define
360      ! ('charcase','style','STYLE=[BACKGROUND=CXcd060c JUST=CENTER]');
361                       if charcase='18' then call define
361      ! ('charcase','style','STYLE=[BACKGROUND=CXcd0670 JUST=CENTER]');
362                       if charcase='19' then call define
362      ! ('charcase','style','STYLE=[BACKGROUND=CXcd06d4 JUST=CENTER]');
363                       if charcase='20' then call define
363      ! ('charcase','style','STYLE=[BACKGROUND=CXffffcc JUST=CENTER]');
364                       if charcase='21' then call define
364      ! ('charcase','style','STYLE=[BACKGROUND=CX398C54 JUST=CENTER]');
365                       if charcase='22' then call define
365      ! ('charcase','style','STYLE=[BACKGROUND=CX398d1c JUST=CENTER]');
366                       if charcase='23' then call define
366      ! ('charcase','style','STYLE=[BACKGROUND=CX398d80 JUST=CENTER]');
367                       if charcase='24' then call define
367      ! ('charcase','style','STYLE=[BACKGROUND=CX398de4 JUST=CENTER]');
368                       if charcase='25' then call define
12                                       The SAS System         09:37 Wednesday, October 21, 2009

368      ! ('charcase','style','STYLE=[BACKGROUND=CX398e48 JUST=CENTER]');
369                       if charcase='26' then call define
369      ! ('charcase','style','STYLE=[BACKGROUND=CX398eac JUST=CENTER]');
370                       if charcase='27' then call define
370      ! ('charcase','style','STYLE=[BACKGROUND=CX398f10 JUST=CENTER]');
371                       if charcase='28' then call define
371      ! ('charcase','style','STYLE=[BACKGROUND=CX398f74 JUST=CENTER]');
372                       if charcase='29' then call define
372      ! ('charcase','style','STYLE=[BACKGROUND=CX398fd8 JUST=CENTER]');
373                       if charcase='30' then call define
373      ! ('charcase','style','STYLE=[BACKGROUND=CX39903c JUST=CENTER]');
374                       if charcase='31' then call define
374      ! ('charcase','style','STYLE=[BACKGROUND=CX3990a0 JUST=CENTER]');
375                       if charcase='32' then call define
375      ! ('charcase','style','STYLE=[BACKGROUND=CX399104 JUST=CENTER]');
376                       if charcase='33' then call define
376      ! ('charcase','style','STYLE=[BACKGROUND=CX399168 JUST=CENTER]');
377                       if charcase='34' then call define
377      ! ('charcase','style','STYLE=[BACKGROUND=CX3991cc JUST=CENTER]');
378                       if charcase='35' then call define
378      ! ('charcase','style','STYLE=[BACKGROUND=CX399230 JUST=CENTER]');
379                       if charcase='36' then call define
379      ! ('charcase','style','STYLE=[BACKGROUND=CX399294 JUST=CENTER]');
380                       if charcase='37' then call define
380      ! ('charcase','style','STYLE=[BACKGROUND=CX3992f8 JUST=CENTER]');
381                       if charcase='38' then call define
381      ! ('charcase','style','STYLE=[BACKGROUND=CX39935c JUST=CENTER]');
382                       if charcase='39' then call define
382      ! ('charcase','style','STYLE=[BACKGROUND=CXffcccc JUST=CENTER]');
383                       if charcase='40' then call define
383      ! ('charcase','style','STYLE=[BACKGROUND=CXffcd30 JUST=CENTER]');
384                       if charcase='41' then call define
384      ! ('charcase','style','STYLE=[BACKGROUND=CXffcd94 JUST=CENTER]');
385                       if charcase='42' then call define
385      ! ('charcase','style','STYLE=[BACKGROUND=CXffcdf8 JUST=CENTER]');
386                       if charcase='43' then call define
386      ! ('charcase','style','STYLE=[BACKGROUND=CXffce5c JUST=CENTER]');
387                       if charcase='44' then call define
387      ! ('charcase','style','STYLE=[BACKGROUND=CXffcec0 JUST=CENTER]');
388                       if charcase='45' then call define
388      ! ('charcase','style','STYLE=[BACKGROUND=CXffcf24 JUST=CENTER]');
389                       if charcase='46' then call define
389      ! ('charcase','style','STYLE=[BACKGROUND=CXffcf88 JUST=CENTER]');
390                       if charcase='47' then call define
390      ! ('charcase','style','STYLE=[BACKGROUND=CXffcfec JUST=CENTER]');
391                       if charcase='48' then call define
391      ! ('charcase','style','STYLE=[BACKGROUND=CXffd050 JUST=CENTER]');
392                       if charcase='49' then call define
392      ! ('charcase','style','STYLE=[BACKGROUND=CXffd0b4 JUST=CENTER]');
393                       if charcase='50' then call define
393      ! ('charcase','style','STYLE=[BACKGROUND=CXffd118 JUST=CENTER]');
394                       if charcase='51' then call define
394      ! ('charcase','style','STYLE=[BACKGROUND=CXffd17c JUST=CENTER]');
13                                       The SAS System         09:37 Wednesday, October 21, 2009

395                       if charcase='52' then call define
395      ! ('charcase','style','STYLE=[BACKGROUND=CXffd1e0 JUST=CENTER]');
396                       if charcase='53' then call define
396      ! ('charcase','style','STYLE=[BACKGROUND=CXffd244 JUST=CENTER]');
397                       if charcase='54' then call define
397      ! ('charcase','style','STYLE=[BACKGROUND=CXffd2a8 JUST=CENTER]');
398                       if charcase='55' then call define
398      ! ('charcase','style','STYLE=[BACKGROUND=CXffd30c JUST=CENTER]');
399                       if charcase='56' then call define
399      ! ('charcase','style','STYLE=[BACKGROUND=CXffd370 JUST=CENTER]');
400                       if charcase='57' then call define
400      ! ('charcase','style','STYLE=[BACKGROUND=CXffd3d4 JUST=CENTER]');
401                       if charcase='58' then call define
401      ! ('charcase','style','STYLE=[BACKGROUND=CXccccff JUST=CENTER]');
402                       if charcase='59' then call define
402      ! ('charcase','style','STYLE=[BACKGROUND=CXcccd63 JUST=CENTER]');
403                       if charcase='60' then call define
403      ! ('charcase','style','STYLE=[BACKGROUND=CXcccdc7 JUST=CENTER]');
404                       if charcase='61' then call define
404      ! ('charcase','style','STYLE=[BACKGROUND=CXccce2b JUST=CENTER]');
405                       if charcase='62' then call define
405      ! ('charcase','style','STYLE=[BACKGROUND=CXccce8f JUST=CENTER]');
406                       if charcase='63' then call define
406      ! ('charcase','style','STYLE=[BACKGROUND=CXcccef3 JUST=CENTER]');
407                       if charcase='64' then call define
407      ! ('charcase','style','STYLE=[BACKGROUND=CXcccf57 JUST=CENTER]');
408                       if charcase='65' then call define
408      ! ('charcase','style','STYLE=[BACKGROUND=CXcccfbb JUST=CENTER]');
409                       if charcase='66' then call define
409      ! ('charcase','style','STYLE=[BACKGROUND=CXccd01f JUST=CENTER]');
410                       if charcase='67' then call define
410      ! ('charcase','style','STYLE=[BACKGROUND=CXccd083 JUST=CENTER]');
411                       if charcase='68' then call define
411      ! ('charcase','style','STYLE=[BACKGROUND=CXccd0e7 JUST=CENTER]');
412                       if charcase='69' then call define
412      ! ('charcase','style','STYLE=[BACKGROUND=CXccd14b JUST=CENTER]');
413                       if charcase='70' then call define
413      ! ('charcase','style','STYLE=[BACKGROUND=CXccd1af JUST=CENTER]');
414                       if charcase='71' then call define
414      ! ('charcase','style','STYLE=[BACKGROUND=CXccd213 JUST=CENTER]');
415                       if charcase='72' then call define
415      ! ('charcase','style','STYLE=[BACKGROUND=CXccd277 JUST=CENTER]');
416                       if charcase='73' then call define
416      ! ('charcase','style','STYLE=[BACKGROUND=CXccd2db JUST=CENTER]');
417                       if charcase='74' then call define
417      ! ('charcase','style','STYLE=[BACKGROUND=CXccd33f JUST=CENTER]');
418                       if charcase='75' then call define
418      ! ('charcase','style','STYLE=[BACKGROUND=CXccd3a3 JUST=CENTER]');
419                       if charcase='76' then call define
419      ! ('charcase','style','STYLE=[BACKGROUND=CXccd407 JUST=CENTER]');
420                       if charcase='77' then call define
420      ! ('charcase','style','STYLE=[BACKGROUND=CX99ccff JUST=CENTER]');
421                       if charcase='78' then call define
14                                       The SAS System         09:37 Wednesday, October 21, 2009

421      ! ('charcase','style','STYLE=[BACKGROUND=CX99cd63 JUST=CENTER]');
422                       if charcase='79' then call define
422      ! ('charcase','style','STYLE=[BACKGROUND=CX99cdc7 JUST=CENTER]');
423                       if charcase='80' then call define
423      ! ('charcase','style','STYLE=[BACKGROUND=CX99ce2b JUST=CENTER]');
424                       if charcase='81' then call define
424      ! ('charcase','style','STYLE=[BACKGROUND=CX99ce8f JUST=CENTER]');
425                       if charcase='82' then call define
425      ! ('charcase','style','STYLE=[BACKGROUND=CX99cef3 JUST=CENTER]');
426                       if charcase='83' then call define
426      ! ('charcase','style','STYLE=[BACKGROUND=CX99cf57 JUST=CENTER]');
427                       if charcase='84' then call define
427      ! ('charcase','style','STYLE=[BACKGROUND=CX99cfbb JUST=CENTER]');
428                       if charcase='85' then call define
428      ! ('charcase','style','STYLE=[BACKGROUND=CX99d01f JUST=CENTER]');
429                       if charcase='86' then call define
429      ! ('charcase','style','STYLE=[BACKGROUND=CX99d083 JUST=CENTER]');
430                       if charcase='87' then call define
430      ! ('charcase','style','STYLE=[BACKGROUND=CX99d0e7 JUST=CENTER]');
431                       if charcase='88' then call define
431      ! ('charcase','style','STYLE=[BACKGROUND=CX99d14b JUST=CENTER]');
432                       if charcase='89' then call define
432      ! ('charcase','style','STYLE=[BACKGROUND=CX99d1af JUST=CENTER]');
433                       if charcase='90' then call define
433      ! ('charcase','style','STYLE=[BACKGROUND=CX99d213 JUST=CENTER]');
434                       if charcase='91' then call define
434      ! ('charcase','style','STYLE=[BACKGROUND=CX99d277 JUST=CENTER]');
435                       if charcase='92' then call define
435      ! ('charcase','style','STYLE=[BACKGROUND=CX99d2db JUST=CENTER]');
436                       if charcase='93' then call define
436      ! ('charcase','style','STYLE=[BACKGROUND=CX99d33f JUST=CENTER]');
437                       if charcase='94' then call define
437      ! ('charcase','style','STYLE=[BACKGROUND=CX99d3a3 JUST=CENTER]');
438                       if charcase='95' then call define
438      ! ('charcase','style','STYLE=[BACKGROUND=CX99d407 JUST=CENTER]');
439                       if charcase='96' then call define
439      ! ('charcase','style','STYLE=[BACKGROUND=CXffcc99 JUST=CENTER]');
440                       if charcase='97' then call define
440      ! ('charcase','style','STYLE=[BACKGROUND=CXffccfd JUST=CENTER]');
441                       if charcase='98' then call define
441      ! ('charcase','style','STYLE=[BACKGROUND=CXffcd61 JUST=CENTER]');
442                       if charcase='99' then call define
442      ! ('charcase','style','STYLE=[BACKGROUND=CXffcdc5 JUST=CENTER]');
443                       if charcase='100' then call define
443      ! ('charcase','style','STYLE=[BACKGROUND=CXffce29 JUST=CENTER]');
444                       if charcase='101' then call define
444      ! ('charcase','style','STYLE=[BACKGROUND=CXffce8d JUST=CENTER]');
445                       if charcase='102' then call define
445      ! ('charcase','style','STYLE=[BACKGROUND=CXffcef1 JUST=CENTER]');
446                       if charcase='103' then call define
446      ! ('charcase','style','STYLE=[BACKGROUND=CXffcf55 JUST=CENTER]');
447                       if charcase='104' then call define
447      ! ('charcase','style','STYLE=[BACKGROUND=CXffcfb9 JUST=CENTER]');
15                                       The SAS System         09:37 Wednesday, October 21, 2009

448                       if charcase='105' then call define
448      ! ('charcase','style','STYLE=[BACKGROUND=CXffd01d JUST=CENTER]');
449                       if charcase='106' then call define
449      ! ('charcase','style','STYLE=[BACKGROUND=CXffd081 JUST=CENTER]');
450                       if charcase='107' then call define
450      ! ('charcase','style','STYLE=[BACKGROUND=CXffd0e5 JUST=CENTER]');
451                       if charcase='108' then call define
451      ! ('charcase','style','STYLE=[BACKGROUND=CXffd149 JUST=CENTER]');
452                       if charcase='109' then call define
452      ! ('charcase','style','STYLE=[BACKGROUND=CXffd1ad JUST=CENTER]');
453                       if charcase='110' then call define
453      ! ('charcase','style','STYLE=[BACKGROUND=CXffd211 JUST=CENTER]');
454                       if charcase='111' then call define
454      ! ('charcase','style','STYLE=[BACKGROUND=CXffd275 JUST=CENTER]');
455                       if charcase='112' then call define
455      ! ('charcase','style','STYLE=[BACKGROUND=CXffd2d9 JUST=CENTER]');
456                       if charcase='113' then call define
456      ! ('charcase','style','STYLE=[BACKGROUND=CXffd33d JUST=CENTER]');
457                    endcomp;
458        
459                    compute obs;
460                       dobs + 1;
461                       obs = dobs;
462                    endcompute;
463                 run;

NOTE: There were 13 observations read from the data set WORK.DV.
NOTE: PROCEDURE REPORT used (Total process time):
      real time           0.14 seconds
      cpu time            0.04 seconds
      

464              run;
465              ods html close;
466              ods listing;
NOTE: PROCEDURE DISPLAY used (Total process time):
      real time           3.00 seconds
      cpu time            2.59 seconds
      


NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
      real time           3.78 seconds
      cpu time            3.24 seconds
      
