1                                                          The SAS System                            09:23 Thursday, August 18, 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.78 seconds
      cpu time            0.51 seconds
      

NOTE: AUTOEXEC processing beginning; file is C:\test\fmtsum_test\testing\saspgm\autoexec.sas.


NOTE: AUTOEXEC processing completed.

1          /*------------------------------------------------------------*
2          * program:     fmtsum3.sas                                    *
3          * Description: Verify that the backcode option does generate  *
4          *              the proper program                             *
5          * By:          Sy Truong, 7/01/2003                           *
6          *-------------------------------------------------------------*/
7          
8          
9          *** Create sample format catalog for testing ***;
10         libname curlib '..\data';
NOTE: Libref CURLIB was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: C:\test\fmtsum_test\testing\data
11         
12         proc format library=curlib.formats;
13            invalue incode
14               "one" = 1
15               "two" = 2
16               "three" = 3;
NOTE: Informat INCODE is already on the library.
NOTE: Informat INCODE has been output.
17         
18            value diffcode
19               1 = "one"
20               2 = "two"
21               3 = "three"
22               4 = "four";
2                                       The SAS System          09:23 Thursday, August 18, 2005

NOTE: Format DIFFCODE is already on the library.
NOTE: Format DIFFCODE has been written to CURLIB.FORMATS.
23         
24            value diffname
25               1 = "one"
26               2 = "two"
27               3 = "three";
NOTE: Format DIFFNAME is already on the library.
NOTE: Format DIFFNAME has been written to CURLIB.FORMATS.
28         
29            value $charfmt
30               "test 1" = "one"
31               "test 2" = "two"
32               "test 3" = "three"
33               "test 4" = "four"
34               "test 5" = "five";
NOTE: Format $CHARFMT is already on the library.
NOTE: Format $CHARFMT has been written to CURLIB.FORMATS.
35         run;

NOTE: PROCEDURE FORMAT used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

36         
37         libname library '..\data';
NOTE: Libname LIBRARY refers to the same physical library as CURLIB.
NOTE: Libref LIBRARY was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: C:\test\fmtsum_test\testing\data
38         
39         data work.test;
40            attrib var1 length=$20 format=$charfmt.;
41            attrib var2 length=8 format=diffname.  ;
42            attrib var3 length=8 informat=incode. ;
43         
44            var1 = "test 1";
45            var2 = 1;
46            var3 = 2;
47         run;

NOTE: The data set WORK.TEST has 1 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.09 seconds
      cpu time            0.07 seconds
      

48         
49         %fmtsum(fmtpath=..\data,datname=work.test,backcode=fmtsum4_back.sas);
NOTE: Libname TEMPLIB refers to the same physical library as LIBRARY.
3                                       The SAS System          09:23 Thursday, August 18, 2005

NOTE: Libref TEMPLIB was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: C:\test\fmtsum_test\testing\data
NOTE: Libname LIBRARY refers to the same physical library as TEMPLIB.
NOTE: Libref LIBRARY was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: C:\test\fmtsum_test\testing\data

NOTE: PROCEDURE FORMAT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      
NOTE: The data set WORK.FORMAT has 18 observations and 21 variables.

NOTE: Libref _TEMPLIB was successfully assigned as follows: 
      Engine:        V9 
      Physical Name: C:\test\fmtsum_test\testing\saspgm

NOTE: Table WORK.FMTSUM created, with 11 rows and 3 columns.

NOTE: Table WORK.FMTSUMVAR created, with 3 rows and 1 columns.

50            *** Create the summary of the formats with associated data sets ***;
51            data work.fmtsum;
52               set work.fmtsum;
53               attrib data length=$100 label="Associated Data";
54               if fmtname = "CHARFMT" or fmtname = "" then data = "work.test";
55               if fmtname = "DIFFNAME" or fmtname = "" then data = "work.test";
56               if fmtname = "" or fmtname = "INCODE" then data = "work.test";
57            run;

NOTE: There were 11 observations read from the data set WORK.FMTSUM.
NOTE: The data set WORK.FMTSUM has 11 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

58            *** Create the summary of formats pertaining to variables ***;
59            data work.fmtsumvar;
60               set work.fmtsumvar;
61               attrib data length=$100 label="Associated Data";
62               attrib var1 length=$100 label="Associated Variable as Format";
63               attrib var2 length=$100 label="Associated Variable as Informat";
64               if fmtname = "CHARFMT" then do;
65                  data = "work.test";
66                  var1 = "var1";
67               end;
68               if fmtname = "CHARFMT" or fmtname="" then output;
69               if fmtname = "DIFFNAME" then do;
70                  data = "work.test";
4                                       The SAS System          09:23 Thursday, August 18, 2005

71                  var1 = "var2";
72               end;
73               if fmtname = "DIFFNAME" or fmtname="" then output;
74               if fmtname = "INCODE" then do;
75                  data = "work.test";
76                  var2 = "var3";
77               end;
78               if fmtname = "" or fmtname="INCODE" then output;
79            run;

NOTE: There were 3 observations read from the data set WORK.FMTSUMVAR.
NOTE: The data set WORK.FMTSUMVAR has 3 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.01 seconds
      

80         

81         proc sort data = work.fmtsum;
82            by fmtname;
83         run;

NOTE: There were 11 observations read from the data set WORK.FMTSUM.
NOTE: The data set WORK.FMTSUM has 11 observations and 4 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

84         
85         title1 height=2'--- Format Summary ---';
86         title2 height=2'--- Format Path: ..\data ---';
87         title3 height=2'--- Data: work.test ---';
88         
89         proc print data = work.fmtsum label
90                  style(header)=[font_size=2]
91                  style(column)=[font_size=2];
92         
93         by fmtname;
94         run;

NOTE: There were 11 observations read from the data set WORK.FMTSUM.
NOTE: The PROCEDURE PRINT printed page 1.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.07 seconds
      cpu time            0.04 seconds
      

95         title1 height=2'--- Format Summary Detailed Variables ---';
96         title2 height=2'--- Format Path: ..\data ---';
5                                       The SAS System          09:23 Thursday, August 18, 2005

97         title3 height=2'--- Data: work.test ---';
98         
99         proc print data = work.fmtsumvar label
100                 style(header)=[font_size=2]
101                 style(column)=[font_size=2];
102        
103        run;

NOTE: There were 3 observations read from the data set WORK.FMTSUMVAR.
NOTE: The PROCEDURE PRINT printed page 2.
NOTE: PROCEDURE PRINT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

  
NOTE: [fmtsum] successfully saved code to for PROC FORMAT. 
      The file: C:\test\fmtsum_test\testing\saspgm\fmtsum4_back.sas has been saved. 
  
WARNING: Closing data set WORK.FORMAT left open by program
NOTE: The PROCEDURE DISPLAY printed pages 1-2.
NOTE: PROCEDURE DISPLAY used (Total process time):
      real time           0.71 seconds
      cpu time            0.21 seconds
      

104        

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