I'm using SAS 94 EG on Linux, I use ODBC driver to connect to Microsoft SQL SERVER when I use proc sql to insert record the text variable [titolo_piano] appair in chinese !!! but no error on log : there are some others parameters i have to put on libname statement or some encoding reference? Thank's %let uid=xxx;
%let pwd=yyy;
libname libColl odbc noprompt="uid=&uid.;pwd=&pwd.;dsn=jjjjj;schema=dbo;" readbuff=100 sql_functions=all;
data test;
wave_corr=999999;
IDPiano="ID001";
fase=1;
titolo_piano="This is an example of text I wont to insert";
output;
run;
proc sql;
INSERT INTO libColl.Best_Practice (wave_corr, IDPiano, fase, titolo_piano) SELECT wave_corr, IDPiano, fase, titolo_piano from test;
quit; this is the result:
... View more