Can someone help me to convert this code in proc sql  please?    data one; merge one two; by variable1 variable2 ; if sum_1=. then sum_1=0; balance=sum_2+sum_1; if balance > 5000 and date eq today() or date2 eq today()  ; run;   thanks in advance. ... View more

guys,             I am trying to create two datasets from one huge dataset. One I need to create last two weeks data and sum it and second data is to sum it for the entire month. I need to see the difference for the two weeks.  I am using following code to create two datasets. I was wondering if I can create one proc sql to create two datasets.   proc sql; create table two_weeks as  select a.*, sum (rec_amount) as two_sum  from walgreen.history a where date >= today()-15; quit;   proc sql; create table month as  select a.*, sum (rec_amount) as month_sum, (calculated month_sum-b.two_sum ) as balance  from walgreen.history a, two_weeks b  where date >= today()-30; quit;                        since i am using the same dataset to create two datasets as two different datasets, Is there a way to create a single proc sql code to accomplish the task I am trying to do?    thanks in advance  ... View more