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