Thank you for your answer. Enclose is my program with the relevant Proc Template. ... View more

Thank you for the answers -- much appreciated. I had hoped that SAS 9.4 1M7 fixed this shortcoming. It's bizarre that this feature is not available. ... View more

Thank you! ... View more

There is no longer a need for translation. I can simply type in the Hebrew text into the %label statement. Many thanks for your help! ... View more

Eyal: This is the best "under your nose" line I have read for a while! It works like charm, as it should. Shmuel: Thank you for all the work, which is truly appreciated, regardless. Jonathan ... View more

1. I have sorted the encoding issue (with your help and SAS' customer support). The problem was that my SAS session was invoked with the Target: "C:\Program Files\SASHome\SASFoundation\9.4\sas.exe" -CONFIG "C:\Program Files\SASHome\SASFoundation\9.4\nls\en\sasv9.cfg" I changed the "en" to "u8", and I now have the needed "ENCODING=UTF-8".   2. As I indicated, there are so many postings now, that I find them hard to sort out. So let's start with your suggestion, Eyal: data _null_; win1255name = "אבג דהו"; put win1255name $hex20.; /* convert to Hebrew DOS */ pcoemname = kcvt(win1255name,"pcoem862"); put pcoemname $hex20.; /* convert to UTF8 */ utfname = kcvt(win1255name,"utf8"); put utfname $hex20.; /* convert to Unicode NCR */ utf8ncr = unicodec(win1255name,"NCR"); put utf8ncr ; /* convert to Unicode ESC */ utf8esc = unicodec(win1255name,"ESC"); put utf8esc ; /* convert back to Hebrew using unicode or kcvt */ win1255name2 = unicode(utfname,"utf8"); put win1255name2 $hex20.; run; Having run this code, I get the following Log. 5 6 data _null_; 7 win1255name = "אבג דהו"; 8 put win1255name $hex20.; 9 /* convert to Hebrew DOS */ 10 pcoemname = kcvt(win1255name,"pcoem862"); 11 put pcoemname $hex20.; 12 /* convert to UTF8 */ 13 utfname = kcvt(win1255name,"utf8"); 14 put utfname $hex20.; 15 /* convert to Unicode NCR */ 16 utf8ncr = unicodec(win1255name,"NCR"); 17 put utf8ncr ; 18 /* convert to Unicode ESC */ 19 utf8esc = unicodec(win1255name,"ESC"); 20 put utf8esc ; 21 /* convert back to Hebrew using unicode or kcvt */ 22 win1255name2 = unicode(utfname,"utf8"); 23 put win1255name2 $hex20.; 24 run; D790D791D79220D793D7 80818220838485202020 D790D791D79220D793D7 אבג דהו \u05D0\u05D1\u05D2 \u05D3\u05D4\u05D5 D790D791D79220D793D7 Of the 6 different options, the (almost) correct function is: utf8esc = unicodec(win1255name,"ESC"); Which produces: \u05D0\u05D1\u05D2 \u05D3\u05D4\u05D5 However, this function adds (1) "\" and "u" in front of the unicodes, additions that my %label statement doesn't understand; and (2) an actual space between the two Hebrew strings instead of the unicode "0020" for a space.   3. Is there a way to "clean" this resulting string so it produces only the only the necessary unicodes? I won't be surprised if Shmuel had already solved it in his posts, but I'd appreciate having a fresh summary instead of having to sort it out myself....   Thanks, Jonathan ... View more

1. I'm running a SAS session. I don't think I'm running SAS Enterprise Guide. This is my Log after starting SAS: NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M3) Licensed to YORK UNIVERSITY, Site 70084392. NOTE: This session is executing on the X64_8HOME platform. NOTE: Updated analytical products: SAS/STAT 14.1 SAS/ETS 14.1 SAS/OR 14.1 SAS/IML 14.1 SAS/QC 14.1 NOTE: Additional host information: X64_8HOME WIN 6.2.9200 Workstation NOTE: SAS initialization used: real time 1.82 seconds cpu time 1.51 seconds 2. This is the configuration file after editing: -config "C:\Program Files\SASHome\SASFoundation\9.4\nls\u8\sasv9.cfg" 3. This configuration file was created when SAS was closed. After restarting SAS, I got: 1 proc options option=encoding; run; SAS (r) Proprietary Software Release 9.4 TS1M3 ENCODING=WLATIN1 Specifies the default character-set encoding for the SAS session. ... View more

1. I've followed the instructions to change my SAS encoding  as indicated here: https://communities.sas.com/t5/SAS-Communities-Library/Change-Encoding-using-SAS-Enterprise-Guide-Windowing-Environment/ta-p/597621# 2. I've run proc options option=encoding;run; I still get WLATIN1 3. I'm using Windows 10. Jonathan ... View more

Thank you Eyal and Shmuel.   1. I think I've managed to lose track of all the different solutions, at least in part because my system does not recognize the Hebrew text I correctly typed in.   2. Following your recommendation, I ran the following code: proc options option=encoding;run; and got the following Log: 95 proc options option=encoding;run; SAS (r) Proprietary Software Release 9.4 TS1M3 ENCODING=WLATIN1 Specifies the default character-set encoding for the SAS session. So I get encoding=WLATIN1 instead of the desired encoding=Whebrew. I suspect this difference explains the ??? replacing the typed-in Hebrew text.   3. What should I do the change my encoding?   Thank you. ... View more

Regarding your questions, Shmuel: 1. SAS 9.4 TS Level 1M3, X64_8Home 2. I checked the test data set, and the variable string_out is empty for all values. Jonathan ... View more

Shmuel: This is the log I get from running your code (after retyping אחוזים and inserting a tab as needed). There must be something amiss in my system or in what I'm doing...   2101 data test; 2102 length strin: $80; 2103 infile datalines truncover dlm='09'x; /* use TAB as delimter betweem varname and string 2103! */ 2104 input varname $ string_in :$char80.; 2105 string_out = compress(unicodec(string_in), '\u'); 2106 call symput(varname,strip(string_out)); 2107 keep varname string_out; 2108 datalines; NOTE: The data set WORK.TEST has 9 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 2108! /*** use TAB between VARNAME and the string to translate ***/ 2118 ; 2119 run; 2120 %put Ahuzim=&ahuzim; Ahuzim= ... View more

Hi Eyal: I ran your code (after retyping the Hebrew letters) and this is the log I get: 2034 data _null_; 2035 win1255name = "??? ???"; 2036 put win1255name $hex20.; 2037 /* convert to Hebrew DOS */ 2038 pcoemname = kcvt(win1255name,"pcoem862"); 2039 put pcoemname $hex20.; 2040 /* convert to UTF8 */ 2041 utfname = kcvt(win1255name,"utf8"); 2042 put utfname $hex20.; 2043 /* convert to Unicode NCR */ 2044 utf8ncr = unicodec(win1255name,"NCR"); 2045 put utf8ncr ; 2046 /* convert to Unicode ESC */ 2047 utf8esc = unicodec(win1255name,"ESC"); 2048 put utf8esc ; 2049 /* convert back to Hebrew using unicode or kcvt */ 2050 win1255name2 = unicode(utfname,"utf8"); 2051 put win1255name2 $hex20.; 2052 run; 3F3F3F203F3F3F 3F3F3F203F3F3F202020 3F3F3F203F3F3F202020 ??? ??? ??? ??? 3F3F3F203F3F3F202020 NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ... View more

Shmuel:   1. For the two of us to be on the same page, I enclose here (1) the sas program file, (2) the sas dataset, and (3) the PDF version of the SVG output file (SVG format cannot be uploaded here). 2. Note that the enclosed program successfully uses your %let ahuzim macro. 3. Regarding the test_heb dataset below, I did type in the Hebrew letters as you asked, and the results are shown below.   Thank you, Jonathan data test_heb; length ch $2 cx $4; ch = "א"; cx = put(ch,$hex4.); put ch= cx=; ch = "ת"; cx = put(ch,$hex4.); put ch= cx=; run; 3735 data test_heb; 3736 length ch $2 cx $4; 3737 ch = "?"; 3738 cx = put(ch,$hex4.); 3739 put ch= cx=; 3740 3741 ch = "?"; 3742 cx = put(ch,$hex4.); 3743 put ch= cx=; 3744 run; ch=? cx=3F20 ch=? cx=3F20 NOTE: The data set WORK.TEST_HEB has 1 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds   ... View more