Hi,   Iam looking for check two tables and check all the columns and produce the reuslt     Example :   data table1; input col1 $ col2 $ col3 $ col4 $ col5 $; cards; value11 value12 value13 value14 value15 value21 value22 value23 value24 value25 value31 value32 value33 value34 value35 value41 value42 value43 value44 value45 value51 value52 value53 value54 value55 ; run;     data table2; input col1 $ col2 $ col3 $ col4 $ col5 $; cards; value11 value12 value13 value14 value15 value21 value22 value23 value24 value25 value31 value32 value33 value34 value35 value41 value42 value00 value44 value45 value51 value52 value53 value00 value55 ; run;     result iam expecting :   col1 col2 col3 col4 col5 result value11 value12 value13 value14 value15 All_columns_matched value21 value22 value23 value24 value25 All_columns_matched value31 value32 value33 value34 value35 All_columns_matched value41 value42 value00 value44 value45 All_columns_not_matched value51 value52 value53 value00 value55 All_columns_not_matched ... View more

Iam trying to connect to sql server from sas and iam able to connect with libname statement successfully but not from the proc sql.   what might be the wrong in the below code?   LIBNAME genis SQLSVR Datasrc=Genesis_ABC SCHEMA=dbo USER="XXXX" PASSWORD="XXXX";   Working Properly      proc sql; connect to odbc as mycon ( Datasrc=Genesis_ABC SCHEMA=dbo USER="XXXX" PASSWORD="XXXX"); create table work.TEST1 as select * from connection to mycon (select * from test1_table ); disconnect from mycon; quit;   proc sql getting below error   ERROR: The ODBC engine cannot be found. ERROR: A Connection to the odbc DBMS is not currently supported, or is not installed at your site. ... View more

data test; string='abc_234_knm_dfjkdhf_dfdkf'; run;   i want ouput like   output_col = knm_dfjkdhf_dfdkf   can some one help on this  ... View more