sas

[Saleem]

data dataset name;

merge &lib_1..bd_mis_CH_ACCT_MAST 
(in=a keep= cod_acct_no cod_cust nam_cust_shrt
cod_cc_brn cod_prod bal_book
cod_ccy cod_acct_stat DAT_ACCT_OPEN )
&lib_1..BD_BA_CUST_ACCT_AO_LOB_XREF (in=d keep= cod_lob COD_AO_BUSINESS cod_acct_no );
by cod_acct_no; if a and cod_acct_stat not in ('1','5','11') and COD_LOB in (22,31);
run;

How To write same code in proc sql.

Thanks in Advance

[PaigeMiller]

@Saleem 

Please go back and edit your original post to provide a meaningful title that describes your problem. A title of SAS is not meaningful because all questions here are about SAS. This will help you get a faster and better answer, and will help everyone find posts of interest.

[AMSAS]

In addition to @PaigeMiller comments also consider

1. Supply sample data, both what you have (input) and what you want (output)
2. Format your code so it is easier to read 
3. What have you tried already

If you provide sample data (see Data2DataStep Maco instructions) and make an attempt at the code first, you'll get a faster response.