topic Re: correctencoding for entire library. in SAS Programming

correctencoding for entire library.

data_null__ — Wed, 08 Oct 2025 14:09:12 GMT

I want to correct the encoding for all members of a data library.

proc datasets lib=orig;
   modify ae / correctencoding=wlatin1;   /* or windows-1252 */
   quit;

I know I can use codegen to do this task. Is there a way this can be done using COPY perhaps? Modify _ALL_ does not work. 🙂

Re: correctencoding for entire library.

yabwon — Wed, 08 Oct 2025 15:05:39 GMT

John, how about:

options dlcreatedir;
libname in "R:\in";
libname out "R:\out" outencoding=wlatin1;

data in.a in.b in.c;
set sashelp.class;
run;

proc copy NOCLONE in=in out=out;
run;

proc contents data=out.b;
run;

Bart

Re: correctencoding for entire library.

quickbluefish — Wed, 08 Oct 2025 15:38:36 GMT

...never seen that dlcreatedir option!

Re: correctencoding for entire library.

yabwon — Wed, 08 Oct 2025 15:40:04 GMT

it's pretty handy one 🙂

Re: correctencoding for entire library.

ChrisHemedinger — Wed, 08 Oct 2025 16:41:36 GMT

It's an oldie-but-a-goodie, and you can even go deep with it. See when I first wrote about it here.

Re: correctencoding for entire library.

quickbluefish — Wed, 08 Oct 2025 17:12:51 GMT

love the SEP concept!

Re: correctencoding for entire library.

data_null__ — Wed, 08 Oct 2025 20:21:39 GMT

@yabwon thanks so much this worked great. I did have to use INENCODING=wlatin1 on the IN= library.

Re: correctencoding for entire library.

data_null__ — Wed, 08 Oct 2025 20:26:15 GMT

@quickbluefish wrote:
...never seen that dlcreatedir option!

That is a great feature. I can never remember how to spell it. DataLibraryCreateDirectory

Re: correctencoding for entire library.

Ksharp — Thu, 09 Oct 2025 01:42:09 GMT

John.King ,

There is a built-in sas macro to make it happen. This built-in macro can change any encoding into other encoding:

https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/nlsref/p1g1d26os4w0von1cdfh827foo3r.htm

For example:

Change EUC-CN(your sas session is EUC-CN encoding) into UTF-8:

%let path= C:\temp\原始的SAS数据集\  ;

options validvarname=any;
libname x v9 "&path.";

/*
%COPY_TO_NEW_ENCODING(from_dsname, to_dsname, new_encoding)
*/
%copy_to_new_encoding(x.have, outdata, utf8)