22 /* Assign filerefs and libref. */
23 filename query "&datapath.\results2.xml" lrecl=256;
24 filename rawdata "&datapath.\results3.xml" lrecl=256;
25 filename map temp;
26 libname myxml xml xmlfileref=rawdata xmlmap=map;
NOTE: Libref MYXML was successfully assigned as follows:
Engine: XML
Physical Name:
27
28 /* Create temporary query file. */
29 /* 2309 flag plus template gets table name, column name, */
30 /* engine, libref, and object IDs. The template specifies */
31 /* attributes of the nested objects. */
32
33 data _null_;
34 file query;
35 input;
36 put _infile_;
37 datalines;
NOTE: The file QUERY is:
Filename=\\SASVM\SAS-DATA\LEV1\DATA\USER SANDPITS\SMLL\CLH SAS FORUM\DATA\results2.xml,
RECFM=V,LRECL=256,File Size (bytes)=0,
Last Modified=07 May 2019 08:29:12,
Create Time=06 May 2019 13:50:53
NOTE: 14 records were written to the file QUERY.
The minimum record length was 80.
The maximum record length was 80.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
52 ;;
53 run;
2 The SAS System 08:26 Tuesday, May 7, 2019
54
55 proc metadata
56 in=query
57 out=rawdata;
58 run;
NOTE: PROCEDURE METADATA used (Total process time):
real time 2.68 seconds
cpu time 0.09 seconds
59
60
61 data _null_;
62 file map;
63 input;
64 put _infile_;
65 datalines;
NOTE: The file MAP is:
Filename=F:\SAS\Lev1\SASWORK\_TD10044_SASVM_\#LN00282,
RECFM=V,LRECL=32767,File Size (bytes)=0,
Last Modified=07 May 2019 08:29:14,
Create Time=07 May 2019 08:29:14
NOTE: 20 records were written to the file MAP.
The minimum record length was 80.
The maximum record length was 80.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
86 ;
87 Run;
88
@ballardw Log added as requested.
... View more