topic Re: Failed to transcode data from UTF-16LE to wlatin1 in SAS Programming

Failed to transcode data from UTF-16LE to wlatin1

jei — Thu, 16 Jun 2016 03:43:35 GMT

Hi!

I'm trying ti import an XML file using this script

filename outfile "C:\Users\jgmanalo\Desktop\Sample1\From URL\OutXML.xml" encoding= 'UTF-8';
libname source xml "C:\Users\jgmanalo\Desktop\Sample1\From URL\OutXML.xml";
proc http
	out = outfile
	url = 'https://rbc-svr-pi/webacs/api/v1/data/ClientDetails?.full=true'
	method = 'get';
run;

But an error occured.

May I know how to solve the error? Thank you!

Re: Failed to transcode data from UTF-16LE to wlatin1

Ksharp — Thu, 16 Jun 2016 05:20:35 GMT

Can you change your SAS session's encoding into utf-16le? in sas configure file ?

Re: Failed to transcode data from UTF-16LE to wlatin1

ChrisNZ — Thu, 16 Jun 2016 05:39:30 GMT

The error point to bad characters in the program itself. This very web site embeds such characters in posted programs.

Admins, anything you can do to avoid this?

Try this cleaned version:

filename outfile 'C:\Users\jgmanalo\Desktop\Sample1\FromURL\OutXML.xml' encoding='UTF-8';

libname source xml 'C:\Users\jgmanalo\Desktop\Sample1\FromURL\OutXML.xml';

proc http out=outfile url='https://rbc-svr-pi/webacs/api/v1/data/ClientDetails?.full=true' method='get';run;

Re: Failed to transcode data from UTF-16LE to wlatin1

jei — Thu, 16 Jun 2016 05:55:09 GMT

The error is still the same.

Re: Failed to transcode data from UTF-16LE to wlatin1

ChrisNZ — Thu, 16 Jun 2016 06:04:15 GMT

Grrr. Yes the rogue characters have been inserted again.

Try the attached file.

Re: Failed to transcode data from UTF-16LE to wlatin1

jei — Thu, 16 Jun 2016 06:16:25 GMT

still the same.

Re: Failed to transcode data from UTF-16LE to wlatin1

ChrisNZ — Thu, 16 Jun 2016 06:22:44 GMT

Mmm don't know what to say except that this web site really screws characters sometimes (but not always).

I get the same message as you but after cleaning I can run the code and I get the expected proc http error

ERROR: Host name resolution failed

To clean, delete every space and end-of-line character and add them manually again.

Run each line separately to see which one still contains bad characters.

Re: Failed to transcode data from UTF-16LE to wlatin1

jei — Thu, 16 Jun 2016 06:36:06 GMT

Hi @ChrisNZ

I retyped all and no error occured. But no data on the resuletd XML file as seen on the image below

May I know if you have any idea about resful API on sas and how to code it? I think the step on the link should follow in order to get the data.

https://developer.cisco.com/media/prime-infrastructure-api-reference-v3-0/192.168.115.187/webacs/api/v1/index7733.html?id=tutorials

Re: Failed to transcode data from UTF-16LE to wlatin1

ChrisNZ — Thu, 16 Jun 2016 06:39:24 GMT

That's a a different issue. Now that this is solved and the code can run, best to open a new incident with the appropriate title so the right people can be involved.

Re: Failed to transcode data from UTF-16LE to wlatin1

jei — Thu, 16 Jun 2016 07:02:56 GMT

Alright. Thanks!

Re: Failed to transcode data from UTF-16LE to wlatin1

ChrisNZ — Thu, 16 Jun 2016 08:19:55 GMT

Please mark the thread as solved.

Re: Failed to transcode data from UTF-16LE to wlatin1

Ksharp — Thu, 16 Jun 2016 09:15:07 GMT

Can you run OS command at SAS side ?

x 'curl -k "https://user:password@my_server/webacs/api/v1/data/Devices?.full=true"  >  C:\Users\jgmanalo\Desktop\Sample1\FromURL\OutXML.xml ';

Then run my code .

Re: Failed to transcode data from UTF-16LE to wlatin1

ChrisNZ — Thu, 16 Jun 2016 21:11:50 GMT

@Ksharp Sorry I didn't see your answer when I asked for the solved flag to be set. I didn't mean to discount your post.

Re: Failed to transcode data from UTF-16LE to wlatin1

Ksharp — Fri, 17 Jun 2016 00:49:32 GMT

Chris,

That is OK. I really don't care about that.

You must are using IE ? Try Chrome .

Re: Failed to transcode data from UTF-16LE to wlatin1

jei — Fri, 17 Jun 2016 02:32:53 GMT

yes I'm trying this code

Re: Failed to transcode data from UTF-16LE to wlatin1

jei — Fri, 17 Jun 2016 08:10:51 GMT

Hi @Ksharp,

I tried this code

x 'curl -k "https://user:password@my_server/webacs/api/v1/data/Devices?.full=true"  >  C:\Users\jgmanalo\Desktop\Sample1\FromURL\OutXML.xml ';

It says that >C does not recognized.

and I tried only the

x 'curl -k "https://user:password@my_server/webacs/api/v1/data/Devices?.full=true" >OutXML.xml ';

and it was successful. But I don't know where local file it was saved and when I'm searching it it says that no result found.

Do you have any idea where i can found the file?

Thank you!

Re: Failed to transcode data from UTF-16LE to wlatin1

Ksharp — Fri, 17 Jun 2016 08:21:51 GMT

Maybe your SAS is not under WIN , is under Linux/AIX ?

Do you know any available fold you can use like /home/etc/out.xml

Or Can you talk to your Admin and let him tell where it should be ?

Re: Failed to transcode data from UTF-16LE to wlatin1

Diyarhan — Tue, 24 Jan 2017 06:52:07 GMT

Hi;

I Know it's an old topic but I have same problem and I don't know how can I solve it. I'm new at SAS, I try to learn it. When I try to list data like this then this error occures, thank you for your help.