1                                          The SAS System          08:35 Thursday, February 16, 2006

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.14 seconds
      cpu time            0.13 seconds
      

NOTE: AUTOEXEC processing beginning; file is C:\temp\cdiscbld\testing\saspgm\autoexec.sas.

NOTE: Libref _CDISC_ was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: d:\My Projects\SAS\CDISCBUILDER\sashelp

NOTE: AUTOEXEC processing completed.

1          /*------------------------------------------------------------*
2          * program:     ordervar6.sas                                  *
3          * Description: Test condition where the parameter rdomain is  *
4          *              missing and variable domain is existed.        *
5          *                                                             *
6          * By:          Meta-Xceed, Inc.                               *
7          *              Minh Nguyen, 09/15/2005                        *
8          *-------------------------------------------------------------*/
9          libname data '..\data\ordervar';
NOTE: Libref DATA was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: C:\temp\cdiscbld\testing\data\ordervar
10         data data.shoes;
11         attrib domain length=$30 label="Domain Abbreviation";
12         set sashelp.shoes;
13         domain = "AE";
14         run;

NOTE: There were 395 observations read from the data set SASHELP.SHOES.
NOTE: The data set DATA.SHOES has 395 observations and 8 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

15         
16         
17         *** Test condition where the parameter rdomain is missing and variable domain is existed
17       ! ***;
18         %ordervar(data=data.shoes, rdomain=, key1=product, basecode=);

19         options nofmterr;
20         data data.shoes(label='No label');
21            *** Order the position through a retain statement ***;
2                                          The SAS System          08:35 Thursday, February 16, 2006

22            *** Retain the key variables ***;
23            retain
24                product
25            ;
26            *** Retain the non-key variables ***;
27            retain
28                domain
29                region
30                subsidiary
31                stores
32                sales
33                inventory
34                returns
35            ;
36            set data.shoes;
37         run;

NOTE: There were 395 observations read from the data set DATA.SHOES.
NOTE: The data set DATA.SHOES has 395 observations and 8 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

38         *** Sort the data set according to the keys and original sort order ***;
39         proc sort data = data.shoes;
40            by product;
41         run;

NOTE: There were 395 observations read from the data set DATA.SHOES.
NOTE: The data set DATA.SHOES has 395 observations and 8 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

42         ods listing close;
43         ods html file = 'ord_report.html';
NOTE: Writing HTML Body file: ord_report.html
44         
45         *** Generate the final report ***;
46         proc contents data = data.shoes;
47            title 'shoes dataset';
48         run;

NOTE: PROCEDURE CONTENTS used (Total process time):
      real time           0.07 seconds
      cpu time            0.01 seconds
      

49         
50         ods html close;
51         ods listing;
52         
3                                          The SAS System          08:35 Thursday, February 16, 2006

53         
54         

NOTE: [ordervar] has sucessfully create dataset data.shoes 
NOTE: PROCEDURE DISPLAY used (Total process time):
      real time           0.57 seconds
      cpu time            0.34 seconds
      

55         

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