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
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.
In addition to @PaigeMiller comments also consider
If you provide sample data (see Data2DataStep Maco instructions) and make an attempt at the code first, you'll get a faster response.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.