correctencoding for entire library.

[data_null__]

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. 🙂

[yabwon · Accepted solution]

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

[quickbluefish]

...never seen that dlcreatedir option!

[yabwon]

it's pretty handy one 🙂

[ChrisHemedinger]

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

[quickbluefish]

love the SEP concept!

[data_null__]

---

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

---

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

[data_null__]

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

[Ksharp]

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)