topic Re: How do I export / create a .xml file pr. customer in SAS Programming

How do I export / create a .xml file pr. customer

henrik_liebach — Thu, 01 Jun 2017 13:07:41 GMT

I'm a new in SAS, and got a challage to make a script where output is add at one .xml for each customer.

I don't know if it's possibel for SAS to create / export .xml file for each customer?

If yes, please add more than one expempel to me.

Thx in advance.

Regards

Henrik

Re: How do I export / create a .xml file pr. customer

Kurt_Bremser — Thu, 01 Jun 2017 13:15:18 GMT

Please provide example data (analytic source data, and how the list of customers is stored in SAS) to play around (use data steps as described here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712), show how the data is prepared for each customer, and give an example for the .xml file format in question.

Re: How do I export / create a .xml file pr. customer

RW9 — Thu, 01 Jun 2017 13:41:46 GMT

Without having anything to work with this is just an example:

data _null_;
  set subjects;
  by subject;
  if first.subject then call execute('data _null_; set have; file "subject'||strip(subject)||'.xml";');
  call execute('put "<subject>'||strip(subject)||'<subject>";');
  if last.subject then call execute('run;');
run;

Alll the above does is create a file per subject and put the text with subject in each.

Re: How do I export / create a .xml file pr. customer

henrik_liebach — Fri, 02 Jun 2017 12:34:31 GMT

Thanks for input 🙂

Re: How do I export / create a .xml file pr. customer

Ksharp — Fri, 02 Jun 2017 15:03:54 GMT

libname x xmlv2 '/folders/myfolders/class.xml' ;
proc copy in=sashelp out=x noclone;
 select class;
run;