proc freq data=mbrtmp2 noprint;   weight mbrcnt;   tables modate*productid*mbrrsk*employerid*enrollinfo / out=mbrtmp01; run; ... View more

Could you please some one help me how to convert below SAS code in to SQL code data crmsaimler_f;   merge ipexcl_f(keep=claimno in=abc) crmsaimall_f(in=def);   by claimno;   if def and not abc; run; ... View more

%prvadit(2); %prvadit(3); %prvadit(4); %prvadit(5); %prvadit(9); proc sql;   create table prvadr as   select prpr_id, prad_state, prad_zip, min(datepart(prad_eff_dt)) as effdt,   max(datepart(prad_term_dt)) as trmdt   from prvadr2   group by prpr_id, prad_state, prad_zip; quit; ... View more

Hi , I am very new to sas code . is any body able to help me for convert sas code to sql code. Thanks, Raj ... View more