XML Mapper Want filename as a variable

ismahero1 — Thu, 16 Jul 2020 15:20:58 GMT

Hi,

I am using XML Mapper engine xmlv2. I am using a map to load 2 or more XML files. I would like to modify the map to have the file name as one of the variables. Any knows how can I get the filenames as part of the variables in my dataset?

Re: XML Mapper Want filename as a variable

ChrisNZ — Sun, 19 Jul 2020 20:48:14 GMT

This is unclear. Please give an example of want you want.

Re: XML Mapper Want filename as a variable

Tom — Sun, 19 Jul 2020 22:01:45 GMT

Are you asking if there is a way in your map file to specify that when you use it to convert an XML file to a SAS dataset that the name of the XML being converted? I would be very surprised if that is possible as why would the map file know anything about the source of the file that it is being used to parse?

You could do that in separate logic. Let's setup an example by creating an XML file.

libname out xmlv2 'c:\downloads\class1.xml';
data out.class; set sashelp.class; run;
libname out clear;

Now let's read that back into a SAS dataset and use the PATHNAME() function to find the path that the libref being used.

libname in xmlv2 'c:\downloads\class1.xml';
data class;
  set in.class ;
  filename=pathname('in');
run;

Results:

Obs    Name            Sex         Age      Height      Weight           filename

  1    Alfred            M          14          69       112.5    c:\downloads\class1.xml
  2    Alice             F          13        56.5          84    c:\downloads\class1.xml
  3    Barbara           F          13        65.3          98    c:\downloads\class1.xml
  4    Carol             F          14        62.8       102.5    c:\downloads\class1.xml
  5    Henry             M          14        63.5       102.5    c:\downloads\class1.xml
  6    James             M          12        57.3          83    c:\downloads\class1.xml
  7    Jane              F          12        59.8        84.5    c:\downloads\class1.xml
  8    Janet             F          15        62.5       112.5    c:\downloads\class1.xml
  9    Jeffrey           M          13        62.5          84    c:\downloads\class1.xml
 10    John              M          12          59        99.5    c:\downloads\class1.xml
 11    Joyce             F          11        51.3        50.5    c:\downloads\class1.xml
 12    Judy              F          14        64.3          90    c:\downloads\class1.xml
 13    Louise            F          12        56.3          77    c:\downloads\class1.xml
 14    Mary              F          15        66.5         112    c:\downloads\class1.xml
 15    Philip            M          16          72         150    c:\downloads\class1.xml
 16    Robert            M          12        64.8         128    c:\downloads\class1.xml
 17    Ronald            M          15          67         133    c:\downloads\class1.xml
 18    Thomas            M          11        57.5          85    c:\downloads\class1.xml
 19    William           M          15        66.5         112    c:\downloads\class1.xml

topic Re: XML Mapper Want filename as a variable in SAS Programming

XML Mapper Want filename as a variable

Re: XML Mapper Want filename as a variable

Re: XML Mapper Want filename as a variable