Hello team ,    i have a data in macro variable like    %let party_data = {"name":"as<br>df:asfd;asdf*asdfâsdf¨¨asdf*asdf'´´½!\"#¤%&/()=?@£$€{[]}\\~|<>_:;*^`","id":"121212-1212"};   how to store the content of name and id in two separate macro variables    am trying to use below code , but it is not working as expected   i would like to store as  party_name =as<br>df:asfd;asdf*asdfâsdf¨¨asdf*asdf'´´½!\"#¤%&/()=?@£$€{[]}\\~|<>_:;*^` party_id=121212-1212 %let party_data = {"name":"as<br>df:asfd;asdf*asdfâsdf¨¨asdf*asdf'´´½!\"#¤%&/()=?@£$€{[]}\\~|<>_:;*^`","id":"121212-1212"}; party=compress(tranwrd(party_data,'","','¤'),'"{}[]'); party_name=substr(kscan(party,1,'¤'),6); party_id=substr(kscan(party,2,'¤'),4); output : party = name:as<br>df:asfd;asdf*asdfâsdf¨¨asdf*asdf'´´½!\#¤%&/()=?@£$€\\~|<>_:;*^`¤id:121212-1212 party_name = as<br>df:asfd;asdf*asdfâsdf¨¨ party_id = ()=?@£$€\\~|<>_:;*^`   ... View more

Hello Team ,    Am looking for a generic macro , which exports data from table to CSV , with UTF8 encoding  and all data  (both numeric and character ) needs to be quoted in double quotes    Can somebody help with sample code.   ... View more