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