Hi George S., Below is some very basic proc report code to do what you asked. data have; input x y; cards; 1         2 1         1 5         2 0         3 3         1 1         3 1         3 0         1 6         5 1        0 4        2 1        4 0        1 ; proc report data = have nowd out=want(drop=_:);  columns x y;  define x / display;  define y / analysis;  rbreak after / summarize; run; ... View more

Akber, a proc transpose should do it. data x; input total_text $ count; datalines; abcdef  1 adfgh    2 LAST    3 ; run; proc transpose data = x out=tx(drop=_name_) prefix=field;   by total_text notsorted;   id count;  var total_text; run; HTH, Rich ... View more

Ashwini, Modifying the above code gives a complete proc sql solution. data test; informat agreementdate datetime18.; format agreementdate datetime18.; input Agreementno $ serialno $ agreementdate amount interest; cards; ab10005 7456q9 10jan2012:00:00:00 150000 700 cd20006 6783q8 15feb2012:00:00:00 700000 . bv40007 7672q5 07mar2011:00:00:00 80000 . gu80005 7637q8 09mar2010:00:00:00 90000 300 ; run; proc sql;     create table want as         select agreementno, '' as col1, '' as col2, '' as col4, serialno, '' as col5,       'dh' as col6, agreementdate,                cats(agreementno,substr(serialno,5,2),substr(put(datepart(agreementdate),date9.),1,2),amount) as recieptno,                 amount, case when interest = . then 400                                    when interest > 700 then 300                                    else interest                             end as interest from test; quit; proc print;run; HTH, Rich ... View more

Hi AllanN, If you truly want to use data step logic for the counting and keeping it as simple as I can then the code below should get you started. You can use the where statement to look at specific id values or leave it out and get a running total for all id values. data id;   input id $; datalines; 1001 1002 1003 1002 1004 1001 1003 1004 1001 1002 ; run; proc sort data = id;  by id; run; data counts;   set id;   by id;  where id in('1001' '1003');  if first.id then do;   count=0;   end;   count+1;  if last.id then do;     total = count;   end;   add+total;  if total ne .; run; HTH, Rich ... View more

Hello Ruth, Try the code below. If you include both variables in the by statement they will tend to interleave and not just overwrite and then you can delete the extra b rows that are blank with the subsetting if statement. data data03;   merge data01 data02;   by a b;   if b; run; Hope this helps, Rich ... View more