topic Re: GetMetata - How to filter response XML in SAS Data Management

GetMetata - How to filter response XML

Patrick — Sat, 16 Nov 2019 10:25:42 GMT

Hi all,

I've got a working Metadata query (code below) but I can't manage to define a filter so that the respond XML contains less information.

The working query is here.

filename myinput temp lrecl=256;
filename myoutput '~/test.xml' lrecl=256;
/*filename myoutput temp lrecl=256;*/

data _null_;
   file myinput;
   input;
   put _infile_ ' ';
   datalines;
<GetMetadata>
 <Metadata>
   <Job Id="A5LSNX1U.BU0001H8"/>
 </Metadata>
 <NS>SAS</NS>
 <!--OMI Flags 1 + 2 + 2048 -->
 <Flags>2051</Flags>
 <Options/>
</GetMetadata>

;
run;

proc metadata
   in=myinput
   out=myoutput;
run;

The only information I really need per Job:

All TextStore objects with attributes ID and StoreText.

Example: <TextStore Id="A5LSNX1U.AG0007ZF" StoredText="%inc 'path user written';" />

Context

I'm working on a large migration project with lots of DIS jobs who use a lot of user written code with fully hard coded paths (don't ask!).

Some of the paths will have to change in the target environment (and no, we can't keep them the same using symlinks).

Environment is Rhel both source and target. SAS version is from source 9.4 to target 9.4 (latest maintenance release).

What I'm trying to do:

1. Pull out all the user written hard coded paths from the source metadata environment

2. Manually create a mapping sheet source path to target path (where paths change)

3. Write code which uses this mapping sheet and changes the user written paths in target Metadata after .spk's have been imported into the target environment.

I'm currently working on step 1. I could make things work with what I have already but it would help if I could reduce the size of the response XML.

Here the same query using the SMC XML Metadata Interface

Re: GetMetata - How to filter response XML

Andy547 — Mon, 18 Nov 2019 14:01:24 GMT

Patrick,

There are several ways to do this. You could try an XMLMap and map the data. You could change the Get metadata to only get the fields you want. like

proc metadata
   in=myinput
   out=myoutput (keep=xxxxx, yyyyy); 
run;

You could read the XML back into a SAS dataset and then do what you want to it:

libname jobs xml '/data/jobs.xml';

proc datasets library=jobs;
run;
proc .....

There are some nice examples here: https://go.documentation.sas.com/api/docsets/lrmeta/9.4/content/lrmeta.pdf

Andy

Re: GetMetata - How to filter response XML

Patrick — Mon, 18 Nov 2019 18:50:37 GMT

@Andy547

What you propose is what I'm currently doing. I use an XML map and read the response XML into SAS tables, I then select the tables with the info I need (TextStore, TextStore1, TextStore<n>).

What I'm after is a request XML that returns a smaller response XML/less data. I've also consulted the docu you've posted but I didn't manage to define such a request XML.