It is easy for SQL. If I understand your question. data have; infile cards expandtabs truncover; input CASE_ID     CLOSING_DT_1 : date9.     CLOSING_DT_2 : date9.     CLOSINGS_ID     ; format  CLOSING_DT_1 CLOSING_DT_2  date11.; cards; 111     .     7-Dec-11     1      111     7-Oct-11     .     2 111     .     .     3      111     .     .     4 ; run; proc sql; create table close as select *,coalesce(CLOSING_DT_1,CLOSING_DT_2) as CLOSE format date11.   from have; create table dropped as select *   from close    group by CASE_ID     having CLOSINGS_ID=max(CLOSINGS_ID) and CLOSE is missing; create table pick_up as select * from close   except select * from dropped ; quit; Ksharp ... View more

See the answer posted in the SAS Procedures forum. cynthia ... View more

Hi:   You may need to use the STARTPAGE=NOW command to issue an immediate "page break". Or, you may need to "pad" a TABULATE with a few blank lines using ODS TEXT= statements.   Just as I issued ** set ODS PDF STARTPAGE=NO; ods pdf startpage=no; run; you may want to try: ** set ODS PDF STARTPAGE=NOW; ods pdf startpage=now; run; before your sections. At this point, the way that pages are breaking are dependent on your data and how big your tables are, etc, etc. You might want to open a track with Tech Support because they can look at your exact data and if you are not running SAS 9.3, they can replicate your version of SAS to help you come to the right solution for your data and your version of SAS. cynthia ... View more

Exactly. I believe the required result is your "data want1" except that the OT needs the do loop to be "do i=1 to dim(a);" so that the array a can have a varying number of elements. ... View more