topic Observations with Different Language in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Observations-with-Different-Language/m-p/29573#M6944 <HTML><HEAD></HEAD><BODY><P> Yup! Thats what I thought initially when I saw the first few observations in the Sample File (Which I thought was the Actual). I have now recieved the actual file with 2.3 Million Observations ?????? <img id="smileysad" class="emoticon emoticon-smileysad" src="https://communities.sas.com/i/smilies/16x16_smiley-sad.png" alt="Smiley Sad" title="Smiley Sad" /></P><P></P><P>I may have to sit a whole month just translating this....</P><P></P><P>Thanks,</P><P>Raghuraman Ramesh</P></BODY></HTML> Fri, 13 Jan 2012 08:53:24 GMT Raghs_Newbee 2012-01-13T08:53:24Z Observations with Different Language https://communities.sas.com/t5/SAS-Procedures/Observations-with-Different-Language/m-p/29571#M6942 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>I have recieved a Data today which has 55 Variables of which most of them in English but certain Key variables are in <STRONG>Chinese.</STRONG> One such value of the Variable is posted below. </P><P></P><P><STRONG>What I have done?</STRONG></P><P>Deleted all columns other than English. Imported Data Successfully into SAS.</P><P></P><P><STRONG>What I need?</STRONG></P><P>Is there a way to import the entire Data (Probably a SAS code / SAS Macro) that can convert these to English and Vice Versa as desired. </P><P></P><P><STRONG>Eg:</STRONG> 沃尔玛(中国)投资有限公司 </P><P></P><P><STRONG>Which in English Means:</STRONG></P><P></P><P><SPAN class="short_text" id="result_box" lang="en"><SPAN class="hps">Wal-Mart</SPAN> <SPAN class="hps">(China</SPAN><SPAN>) Investment</SPAN> <SPAN class="hps">Co., Ltd.</SPAN></SPAN></P><P></P><P><STRONG>This is another Column Data</STRONG></P><P></P><P><STRONG>Eg: </STRONG>Q:&nbsp; [agent name]: liyang [报修人]:王云富先生&nbsp; 电话：0578-5082067&nbsp; 其他电话： [产品]:X544&nbsp;&nbsp;&nbsp; SN:94F2DZV [故障现象]:打印出来会有空白，脱机测试页也是如此 A: [错误代码]:无 [推荐方案]: 请帮忙维修 [ALSC]: JH-HUAYUWEICHENG</P><P></P><P><STRONG>Which in English means : </STRONG></P><P><SPAN id="result_box" lang="en"><SPAN class="hps atn">Q: [agent name]: liyang [</SPAN><SPAN>Repair</SPAN> <SPAN class="hps">man</SPAN><SPAN>]</SPAN><SPAN>:</SPAN> <SPAN class="hps">Mr. Wang Yunfu</SPAN> <SPAN class="hps">Tel</SPAN> <SPAN class="hps">:0578</SPAN> <SPAN class="hps">-5,082,067</SPAN> <SPAN class="hps">Other</SPAN> <SPAN class="hps">Phone</SPAN><SPAN>:</SPAN> <SPAN class="hps atn">[</SPAN><SPAN>product</SPAN><SPAN class="atn">]: X544 SN: 94F2DZV [</SPAN><SPAN>symptoms</SPAN><SPAN>]</SPAN><SPAN>:</SPAN> <SPAN class="hps">print</SPAN> <SPAN class="hps">out</SPAN> <SPAN class="hps">will be</SPAN> <SPAN class="hps">blank</SPAN><SPAN>,</SPAN> <SPAN class="hps">off-line</SPAN> <SPAN class="hps">test page</SPAN> <SPAN class="hps">is also true</SPAN> <SPAN class="hps">A:</SPAN> <SPAN class="hps atn">[</SPAN><SPAN>error code</SPAN><SPAN>]</SPAN><SPAN>: no</SPAN> <SPAN class="hps atn">[</SPAN><SPAN>recommended</SPAN> <SPAN class="hps">options</SPAN><SPAN>]</SPAN><SPAN>: Please</SPAN> <SPAN class="hps">help repair</SPAN> <SPAN class="hps">[ALSC]: JH-HUAYUWEICHENG</SPAN></SPAN></P><P></P><P>Looking forward for your assistance.</P><P></P><P>Thanks,</P><P>Raghuraman Ramesh</P></BODY></HTML> Fri, 13 Jan 2012 08:21:57 GMT https://communities.sas.com/t5/SAS-Procedures/Observations-with-Different-Language/m-p/29571#M6942 Raghs_Newbee 2012-01-13T08:21:57Z Re: Observations with Different Language https://communities.sas.com/t5/SAS-Procedures/Observations-with-Different-Language/m-p/29572#M6943 <HTML><HEAD></HEAD><BODY><P>WOW. I am surprised that I can see these Chinese Words. It is amazing.</P><P></P><P></P><P>For your question, Maybe you can copy these chinese words out and use Google On-Line Translate Tool , then input them back in SAS.</P><P></P><P></P><P>Ksharp</P></BODY></HTML> Fri, 13 Jan 2012 08:44:50 GMT https://communities.sas.com/t5/SAS-Procedures/Observations-with-Different-Language/m-p/29572#M6943 Ksharp 2012-01-13T08:44:50Z Observations with Different Language https://communities.sas.com/t5/SAS-Procedures/Observations-with-Different-Language/m-p/29573#M6944 <HTML><HEAD></HEAD><BODY><P> Yup! Thats what I thought initially when I saw the first few observations in the Sample File (Which I thought was the Actual). I have now recieved the actual file with 2.3 Million Observations ?????? <img id="smileysad" class="emoticon emoticon-smileysad" src="https://communities.sas.com/i/smilies/16x16_smiley-sad.png" alt="Smiley Sad" title="Smiley Sad" /></P><P></P><P>I may have to sit a whole month just translating this....</P><P></P><P>Thanks,</P><P>Raghuraman Ramesh</P></BODY></HTML> Fri, 13 Jan 2012 08:53:24 GMT https://communities.sas.com/t5/SAS-Procedures/Observations-with-Different-Language/m-p/29573#M6944 Raghs_Newbee 2012-01-13T08:53:24Z Observations with Different Language https://communities.sas.com/t5/SAS-Procedures/Observations-with-Different-Language/m-p/29574#M6945 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>I do not know SAS has such a translate tool . If SAS has ,that will be perfect.</P><P>Or Contact SAS Technology Support to see whether they has a better way ?</P><P></P><P>Good Luck.</P><P></P><P>Ksharp</P></BODY></HTML> Fri, 13 Jan 2012 09:02:45 GMT https://communities.sas.com/t5/SAS-Procedures/Observations-with-Different-Language/m-p/29574#M6945 Ksharp 2012-01-13T09:02:45Z Observations with Different Language https://communities.sas.com/t5/SAS-Procedures/Observations-with-Different-Language/m-p/29575#M6946 <HTML><HEAD></HEAD><BODY><P>You could automate using the google translate restful services.&nbsp; However, you will need to license this functionality, of course.&nbsp; Here is a link to the pricing, it is quite reasonable, in my opinion.</P><P></P><P><A href="http://code.google.com/apis/language/translate/v2/pricing.html">http://code.google.com/apis/language/translate/v2/pricing.html</A></P></BODY></HTML> Fri, 13 Jan 2012 15:55:10 GMT https://communities.sas.com/t5/SAS-Procedures/Observations-with-Different-Language/m-p/29575#M6946 FriedEgg 2012-01-13T15:55:10Z