NO. I mean a XML file.
I am curious that you can use PROC HTTP to download that XML file, Why can't you use FILENAME+URL ?
I can't attach the xml file. So I provided a screenshot instead
No. It is problem about encoding. You have to post a XML file if you want some help.
Did you try my another code ?
Yes I tried your another code but the same error.
I really appreciate your help. Thank you very much.
Attached is the XML file
I used Notepad++ open that XML , it shows it is UTF-8 encoding ,not UTF-16LE .
I ran my code again, No Error show up .
NOTE: I use University Edition(utf-8 encoding). Maybe you could use Notepad++ to transform the encoding , or change SAS session encoding.
filename xx temp;
libname xx xmlv2 '/folders/myfolders/ClientDetails.xml' automap=replace xmlmap=xx;
proc copy in=xx out=work;
run;
Here are three tables I got :
I don't know . If you are not able to get it by URL or PROC HTTP, maybe by your hand .
Or try this one :
FILENAME outfile "C:\Users\jgmanalo\Desktop\Sample1\From URL\OutXML.xml";
filename y url 'https://rbc-svr-pi/webacs/api/v1/data/ClientDetails?.full=true';
data _null_;
infile y encoding='UTF-16LE' lrecl=32767;
input;
file outfile encoding='UTF-8';
put _infile_;
run;
filename xx temp;
libname xx xmlv2 'C:\Users\jgmanalo\Desktop\Sample1\From URL\OutXML.xml' automap=replace xmlmap=xx;
proc copy in=xx out=work;
run;
Did you copy and paste? Sometimes the browsers add things. Try typing it out.
Do you need to log in to the site to generate the XML file?
filename xx temp;
libname xx xmlv2 '/folders/myfolders/LabReviewMicroSampleData.xml' automap=replace xmlmap=xx;
proc copy in=xx out=work;
run;
No. That is not going to genereate XML as you describe . I think you have to download XML file and import it into SAS .
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.