topic Re: How do I encode åäö in json? in SAS Programming

How do I encode åäö in json?

Hundredaire — Tue, 07 Jun 2022 14:01:37 GMT

I download data through an api (GET method). I receive data in json. How do I decode åäö correctly in the column "member_title"? (Encoding=wlatin1).

My code:

filename test "C:\Users\......json";
proc http method="GET"
url="http://api.kolada.se/v2/kpi_groups?title=agenda 2030"
out=test;
run;

libname x json fileref=test;
proc copy in=x out=work ;
run;

The result:

ordinal_values	ordinal_members	member_id	member_title
1	1	N00209	Heltidsarbetande mÃ¥nadsavlÃ¶nade, kommun, andel (%)
1	2	N00401	UtslÃ¤pp till luft av vÃ¤xthusgaser totalt, ton CO2-ekv/inv.

Re: How do I encode åäö in json?

SASJedi — Tue, 07 Jun 2022 18:14:45 GMT

Looks like the JSON file is UTF8 encoded, and your SAS session is not. Try this:

filename test "C:\Users\......json" encoding=utf8;
proc http 
    url="http://api.kolada.se/v2/kpi_groups?title=agenda 2030"
    out=test
    method="GET"
;
run;

libname x json fileref=test;
proc copy in=x out=work ;
run;

Does that make it work better for you? For best results, you may want to ensure your SAS session uses UTF8 encoding, too...

Re: How do I encode åäö in json?

Hundredaire — Wed, 08 Jun 2022 06:25:08 GMT

Sorry, its not working 😞 Also changed so that SAS session uses utf8 encoding. Any other suggestions?

Re: How do I encode åäö in json?

Hundredaire — Wed, 08 Jun 2022 06:57:58 GMT

Or it worked! 😄 Just forgot to restart sas 🙂

Thanks!