1                                          The SAS System           15:17 Wednesday, August 24, 2005

NOTE: Copyright (c) 2002-2003 by SAS Institute Inc., Cary, NC, USA. 
NOTE: SAS (r) 9.1 (TS1M3)
      Licensed to META-XCEED INC, Site 0035729001.
NOTE: This session is executing on the XP_HOME  platform.



NOTE: SAS initialization used:
      real time           0.93 seconds
      cpu time            0.87 seconds
      

NOTE: AUTOEXEC processing beginning; file is C:\WorkRoom\comment\Test 
      Macro\testing\saspgm\autoexec.sas.

NOTE: Libref CDISCBLD was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: C:\WorkRoom\comment\Test Macro\testing\saspgm

NOTE: AUTOEXEC processing completed.

1          /*--------------------------------------------------------------------------------	*
2          * program:     comment7.sas                                   					 	*
3          * Description: Verify that if the macro is called multiple times from the same		*
4          * 				 source data, the output is updated and not appended.					*
5          * By:          Meta-Xceed, Nam Phuong, 8/18/2005										*
6          *---------------------------------------------------------------------------------	*/
7          libname mylib "..\data\comment";
NOTE: Libref MYLIB was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: C:\WorkRoom\comment\Test Macro\testing\data\comment
8          %comment (data= mylib.ae,
9                   comvar=comment,
10         		  datevar=	rslvdt1,
11                  rdomain=ae,
12                  studyid=1232,
13                  usubjid = ptid,
14                  idvar = rslvdt1,
15                  output = mylib.metax
16         );

17                  data sasuser.co;
18                     set mylib.metax (label="Comments Domain Model");
19                  run;

NOTE: There were 327 observations read from the data set MYLIB.METAX.
NOTE: The data set SASUSER.CO has 327 observations and 14 variables.
NOTE: DATA statement used (Total process time):
      real time           0.51 seconds
      cpu time            0.09 seconds
      

20         
21                  data mylib.metax (label="Comments Domain Model");
2                                          The SAS System           15:17 Wednesday, August 24, 2005

22                     set mylib.metax (label="Comments Domain Model");
23                     if lowcase(rdomain) = lowcase("ae") and srcdat = "mylib.ae" then delete;
24                  run;

NOTE: There were 327 observations read from the data set MYLIB.METAX.
NOTE: The data set MYLIB.METAX has 0 observations and 14 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.03 seconds
      

NOTE: Table WORK.INDATA created, with 327 rows and 31 columns.

  
NOTE: [comment] has updated the existing output data: mylib.metax (label="Comments Domain Model") 
      located at: C:\WorkRoom\comment\Test Macro\testing\data\comment 
  
NOTE: PROCEDURE DISPLAY used (Total process time):
      real time           23.25 seconds
      cpu time            0.59 seconds
      

25         
26         %comment (data= mylib.ae,
27                  comvar=comment,
28         		  datevar=	rslvdt2,
29                  rdomain=ae,
30                  studyid=1232,
31                  usubjid = ptid,
32                  idvar = rslvdt2,
33                  output = mylib.metax
34         );

35                  data sasuser.co;
36                     set mylib.metax (label="Comments Domain Model");
37                  run;

NOTE: There were 327 observations read from the data set MYLIB.METAX.
NOTE: The data set SASUSER.CO has 327 observations and 14 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.04 seconds
      

38         
39                  data mylib.metax (label="Comments Domain Model");
40                     set mylib.metax (label="Comments Domain Model");
41                     if lowcase(rdomain) = lowcase("ae") and srcdat = "mylib.ae" then delete;
42                  run;

NOTE: There were 327 observations read from the data set MYLIB.METAX.
NOTE: The data set MYLIB.METAX has 0 observations and 14 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
3                                          The SAS System           15:17 Wednesday, August 24, 2005

      cpu time            0.01 seconds
      

NOTE: Table WORK.INDATA created, with 327 rows and 31 columns.

  
NOTE: [comment] has updated the existing output data: mylib.metax (label="Comments Domain Model") 
      located at: C:\WorkRoom\comment\Test Macro\testing\data\comment 
  
NOTE: PROCEDURE DISPLAY used (Total process time):
      real time           0.17 seconds
      cpu time            0.17 seconds
      


NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
      real time           24.45 seconds
      cpu time            1.68 seconds