topic Re: Converting WLATIN1 data to UTF-8 in SAS Programming

Converting WLATIN1 data to UTF-8

contactnishan — Fri, 19 Feb 2021 13:19:20 GMT

Hello SAS Geniuses,

I have some data encoded in WLATIN1 format, want to run some analyses in SAS University Edition that is natively running utf-8 encoding. I came across this link here https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.5&docsetId=viyadatamig&docsetTarget=p1eedruqfsgqqcn1pmjof4br5xvt.htm&locale=en .

I tried the steps mentioned in the link but it doesn't work.

Are there easy ways to convert a wlatin1 sas data to be read properly in utf-8?

Help would be much appreciated.

Thanks,

Nishan

Re: Converting WLATIN1 data to UTF-8

andreas_lds — Fri, 19 Feb 2021 13:59:39 GMT

Using the encoding-option in the infile statement should do it.

Re: Converting WLATIN1 data to UTF-8

LeonidBatkhan — Fri, 19 Feb 2021 14:07:00 GMT

Hi contactnishan,

You can try this:

libname inlib cvp 'c:\source_folder' inencoding='wlatin1';
libname outlib 'c:\target_folder' outencoding='UTF-8';
proc copy in=inlib out=outlib noclone;
   select dataset1 dataset2;
run;

For more information, see this blog post https://blogs.sas.com/content/sgf/2020/08/12/expanding-lengths-of-all-character-variables-in-sas-data-sets/ .

Hope this helps.

Re: Converting WLATIN1 data to UTF-8

contactnishan — Fri, 19 Feb 2021 15:16:10 GMT

It helped. Thank you so much 🙂

Re: Converting WLATIN1 data to UTF-8

Ksharp — Sat, 20 Feb 2021 12:23:15 GMT

data have;
 set sashelp.class;
run;




proc datasets library=work nolist nodetails;
modify have/correctencoding='utf8';
quit;
proc contents data=have varnum;
run;