1                                                          The SAS System                                 10:27 Friday, May 13, 2005

NOTE: Unable to open SASUSER.REGSTRY. WORK.REGSTRY will be opened instead.
NOTE: All registry changes will be lost at the end of the session.

WARNING: Unable to copy SASUSER registry to WORK registry. Because of this, you will not see registry customizations during this 
         session.
NOTE: Unable to open SASUSER.PROFILE. WORK.PROFILE will be opened instead.
NOTE: All profile changes will be lost at the end of the session.
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.37 seconds
      cpu time            0.04 seconds
      

NOTE: AUTOEXEC processing beginning; file is C:\temp\sydata\matchvar\matchvar\autoexec.sas.

NOTE: Libref SYDATA was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: C:\temp\sydata\matchvar\matchvar

NOTE: AUTOEXEC processing completed.

1          /*------------------------------------------------------------*
2          * program:     matchvar4.sas                                 *
3          * Description: Verify that variables that match and variables *
4          *              that closely match are captured.				    *
5          * By:          Meta-Xceed, Inc.                               *
6          *              Nhi Nguyen, 05/12/2005                         *
7          *-------------------------------------------------------------*/
8          
9          libname templib '.\data1';
NOTE: Libref TEMPLIB was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: C:\temp\sydata\matchvar\matchvar\data1
10         libname templib1 '.\data2';
NOTE: Libref TEMPLIB1 was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: C:\temp\sydata\matchvar\matchvar\data2
11         
12         
13         data templib.DEMOG;
14         	protocol = 'pcyc';
15         	ptid = '95001';
16         	ptinit='J-W';
17         	sex='Male';
18         	dob=1456;
19         	race='Caucasian';
20         	othrace='.';
2                                         The SAS System                10:27 Friday, May 13, 2005

21         	dfseq=0;
22         	childpot='No';
23         	smoker='No';
24         run;

NOTE: The data set TEMPLIB.DEMOG has 1 observations and 10 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.03 seconds
      

25         data templib1.DEMOGS;
26         	protocol = '0210';
27         	ptid = '95005';
28         	ptinit='AR';
29         	sex='Female';
30         	dob=1343;
31         	smokehx='No';
32         	weight=.;
33         	wunits='';
34         	scrndt=.;
35         	viadate=.; 	
36         run;

NOTE: The data set TEMPLIB1.DEMOGS has 1 observations and 10 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

37         
38         
39         **missing dataset name ***;
40         %matchvar(path_a=.\data1,path_b=.\data2,dat_a1=DEMOG,dat_b1=DEMOGS);

NOTE: The execution of this query involves performing one or more Cartesian product joins that 
      can not be optimized.
NOTE: Table WORK.DATPAT created, with 4 rows and 6 columns.

NOTE: 1 row was inserted into WORK.MATCHV1.

NOTE: 1 row was inserted into WORK.MATCHV1.

NOTE: 1 row was inserted into WORK.MATCHV1.

NOTE: 1 row was inserted into WORK.MATCHV1.

NOTE: 1 row was inserted into WORK.MATCHV1.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

3                                         The SAS System                10:27 Friday, May 13, 2005

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.
4                                         The SAS System                10:27 Friday, May 13, 2005


NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

5                                         The SAS System                10:27 Friday, May 13, 2005

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.
6                                         The SAS System                10:27 Friday, May 13, 2005


NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: 1 row was inserted into WORK.MATCHV2.

NOTE: No rows were deleted from WORK.MATCHV1.

NOTE: No rows were deleted from WORK.MATCHV2.

  
NOTE: [matchvest] was successful at creating C:\temp\sydata\matchvar\matchvar\matchv1.html 
  
  
NOTE: [matchvest] was successful at creating C:\temp\sydata\matchvar\matchvar\matchv2.html 
  
  
NOTE: [matchvest] was successful at creating C:\temp\sydata\matchvar\matchvar\matchvar.html 
  
NOTE: PROCEDURE DISPLAY used (Total process time):
      real time           1.28 seconds
      cpu time            0.32 seconds
7                                         The SAS System                10:27 Friday, May 13, 2005

      


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