https://communities.sas.com/t5/SAS-Programming/How-to-get-a-single-line/m-p/41507#M8499 Your newness to SAS is not the main issue here. You need to specify what rule you want followed to collapse the nine obs you have shown to just one.<BR /> <BR /> I'll guess it is: for all obs with same ID, create one rec with first rec's start_dt and last rec's end_dt.<BR /> <BR /> Correct?<BR /> <BR /> Before you answer, note I did not say "first rec" by date or by current order in the data - I did not say either. You must include this and every other imaginable detail in your specs. Tue, 30 Nov 2010 18:58:53 GMT Phrzby_Phil 2010-11-30T18:58:53Z https://communities.sas.com/t5/SAS-Programming/How-to-get-a-single-line/m-p/41506#M8498 Hi,<BR /> <BR /> Im fairly new to SAS and learning it, I have a dataset like,<BR /> <BR /> obs ID start_dt end_dt<BR /> <BR /> 1 9000010130143072000000 20070801 20070831 <BR /> 2 9000010130143072000000 20070901 20070930 <BR /> 3 9000010130143072000000 20071001 20071031 <BR /> 4 9000010130143072000000 20071101 20071130 <BR /> 5 9000010130143072000000 20071201 20071231 <BR /> 6 9000010130143072000000 20080101 20080131 <BR /> 7 9000010130143072000000 20080201 20080229 <BR /> 8 9000010130143072000000 20080301 20080331 <BR /> 9 9000010130143072000000 20080401 20080430 <BR /> 10 9000010130143072000000 20080501 20080531 <BR /> <BR /> <BR /> <BR /> How can I convert it in a single record as below, <BR /> <BR /> obs ID start_dt end_dt<BR /> <BR /> 1 9000010130143072000000 20070801 20080531 <BR /> <BR /> <BR /> Thanks, Tue, 30 Nov 2010 18:27:56 GMT https://communities.sas.com/t5/SAS-Programming/How-to-get-a-single-line/m-p/41506#M8498 deleted_user 2010-11-30T18:27:56Z https://communities.sas.com/t5/SAS-Programming/How-to-get-a-single-line/m-p/41507#M8499 Your newness to SAS is not the main issue here. You need to specify what rule you want followed to collapse the nine obs you have shown to just one.<BR /> <BR /> I'll guess it is: for all obs with same ID, create one rec with first rec's start_dt and last rec's end_dt.<BR /> <BR /> Correct?<BR /> <BR /> Before you answer, note I did not say "first rec" by date or by current order in the data - I did not say either. You must include this and every other imaginable detail in your specs. Tue, 30 Nov 2010 18:58:53 GMT https://communities.sas.com/t5/SAS-Programming/How-to-get-a-single-line/m-p/41507#M8499 Phrzby_Phil 2010-11-30T18:58:53Z https://communities.sas.com/t5/SAS-Programming/How-to-get-a-single-line/m-p/41508#M8500 Are these data the whole content of your dataset?<BR /> If it is, it is much achieved.<BR /> [pre]<BR /> data op;<BR /> set yourdataset end=last;<BR /> retain _start _obs ;<BR /> if _n_ eq 1 then do; _start=start_dt; _obs=obs;end;<BR /> if last then do; _end=end_dt; output; end;<BR /> keep _obs id _start _end;<BR /> run;<BR /> [/pre]<BR /> <BR /> <BR /> If you have a couple of groups of id ,then using 'first.id' 'last.id' to get it.<BR /> <BR /> It somewhat looks like the previous post in this forum?? Weird!!<BR /> <BR /> Ksharp Wed, 01 Dec 2010 07:08:37 GMT https://communities.sas.com/t5/SAS-Programming/How-to-get-a-single-line/m-p/41508#M8500 Ksharp 2010-12-01T07:08:37Z https://communities.sas.com/t5/SAS-Programming/How-to-get-a-single-line/m-p/41509#M8501 this is what I like about discussion forums: discovering how many different ways there might be to interpret a question ( let alone the number of ways to program the assumed answer)<BR /> Here is it min(start) and max( end) or first.start and last.end <BR /> or something else??? Wed, 01 Dec 2010 14:55:39 GMT https://communities.sas.com/t5/SAS-Programming/How-to-get-a-single-line/m-p/41509#M8501 Peter_C 2010-12-01T14:55:39Z