1 The SAS System 10:25 Wednesday, August 17, 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 1.31 seconds
cpu time 0.85 seconds
NOTE: AUTOEXEC processing beginning; file is C:\WorkRoom\Metadata\test
Macro\testing\saspgm\autoexec.sas.
NOTE: Libref COMDATA was successfully assigned as follows:
Engine: V9
Physical Name: C:\WorkRoom\Metadata\test Macro\testing\saspgm
NOTE: AUTOEXEC processing completed.
1 /*-------------------------------------------------------------------------------- *
2 * program: metadata9.sas *
3 * Description: Verify the sample template code generated matches with the *
4 * attribute in the output report. *
5 * Parameters: source = source datasets *
6 * metadb = metadata database library *
7 * search = search criteria *
8 * task = database management tasks *
9 * output = output report *
10 * By: Nam Phuong, 8/3/2005 *
11 *--------------------------------------------------------------------------------- */
12 libname mylib ".";
NOTE: Libname MYLIB refers to the same physical library as COMDATA.
NOTE: Libref MYLIB was successfully assigned as follows:
Engine: V9
Physical Name: C:\WorkRoom\Metadata\test Macro\testing\saspgm
13
14 %metadata (source = mylib.ae,
15 metadb = mylib.metadb,
16 search = ,
17 task = update,
18 output = C:\metadb.html);
19 *** Remove the old metadata before updating ***;
20 data mylib.metadb;
21 set mylib.metadb;
2 The SAS System 10:25 Wednesday, August 17, 2005
22 if compress(upcase(libname || '.' || memname)) = upcase("mylib.ae") then
22 ! delete;
23 run;
NOTE: There were 33 observations read from the data set MYLIB.METADB.
NOTE: The data set MYLIB.METADB has 0 observations and 40 variables.
NOTE: DATA statement used (Total process time):
real time 0.12 seconds
cpu time 0.06 seconds
24
25 *** Capture the meta data for mylib.ae ***;
26 proc contents data = mylib.ae noprint
27 out=curdat;
28 run;
NOTE: The data set WORK.CURDAT has 33 observations and 40 variables.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.12 seconds
cpu time 0.04 seconds
29
30 *** Appply the updates to the destination for mylib.ae ***;
31 data mylib.metadb;
32 set mylib.metadb curdat;
33 run;
NOTE: There were 0 observations read from the data set MYLIB.METADB.
NOTE: There were 33 observations read from the data set WORK.CURDAT.
NOTE: The data set MYLIB.METADB has 33 observations and 40 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds
WARNING: A GROUP BY clause has been transformed into an ORDER BY clause because neither the SELECT
clause nor the optional HAVING clause of the associated table-expression referenced a
summary function.
NOTE: Table WORK.LSTDAT created, with 1 rows and 3 columns.
34 *** Create a dataset to store the index of the datasets being created ***;
35 data work.index (label="Data Set Index");
36 attrib libname length=$20 label="Library Name";
37 attrib memname length=$40 label="Data Transformation Name";
38 attrib memlabel length=$80 label="Label";
39 attrib link length=$100 label="Details";
40 libname = "MYLIB";
41 memname = "AE";
42 memlabel = "%nrbquote()";
43 link = 'details...';
44 output;
3 The SAS System 10:25 Wednesday, August 17, 2005
45 run;
NOTE: The data set WORK.INDEX has 1 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
46 ods listing close;
47 ods html3 file="C:\metadb.html";
NOTE: Writing HTML3 Body file: C:\metadb.html
48 proc report data = work.index nowd
49 style(header)=[font_size=2]
50 style(column)=[font_size=2];
51 title1 "Index of Datasets";
52 run;
NOTE: There were 1 observations read from the data set WORK.INDEX.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.10 seconds
cpu time 0.04 seconds
NOTE: Table WORK.TMP1 created, with 33 rows and 40 columns.
53 proc report data = tmp1 nowd
54 style(header)=[font_size=2]
55 style(column)=[font_size=2];
56 title1 '--- Meta Data Database mylib.metadb ---
56 ! ';
57 title2 "Library name: MYLIB Member name= AE";
58 footnote1 height=2 "Generated on: 08/17/2005, 10:25:07 am, Nnguyen";
59 footnote2 height=2 "Located at: C:\WorkRoom\Metadata\test
59 ! Macro\testing\saspgm";
60 run;
NOTE: There were 33 observations read from the data set WORK.TMP1.
NOTE: PROCEDURE REPORT used (Total process time):
real time 0.10 seconds
cpu time 0.04 seconds
61 ods html3 close;
62 ods listing;
rc=0
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: PROCEDURE DISPLAY used (Total process time):
real time 2.42 seconds
cpu time 0.79 seconds
63
4 The SAS System 10:25 Wednesday, August 17, 2005
NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414
NOTE: The SAS System used:
real time 3.84 seconds
cpu time 1.67 seconds