can we get below output with first. and last. or groupformat

[veeru · Accepted solution]

Thank so much.. I reviewed the code, found that there is a logic below which is removing these records. thanks thanks.. thanks.

[Reeza]

Glad you found your answer, but you really shouldn't mark yourself as providing the correct answer.

Several people provided the correct answer and hints.

[Kurt_Bremser]

That is exactly what Reeza's code will yield. Test it:

data have;

infile cards dlm=',';

length

  comp $5

  polno $9

  description $20

;

informat pol_date yymmdd8.;

input

  comp polno description pol_date

;

cards;

76536,005666666,Dep Basic AD&D,20050101

76536,005666666,Dep optnl AD&D,20050101

76536,005666666,Emp Basic AD&D,20050101

76536,005666666,Emp Optnl AD&D,20050101

;

run;

proc sort data=have;

by comp polNo description pol_date;

run;

data want;

set have;

by comp polno description;

if last.description;

run;

Result:

76536    005666666    Dep Basic AD&D    20050101

76536    005666666    Dep optnl AD&D    20050101

76536    005666666    Emp Basic AD&D    20050101

76536    005666666    Emp Optnl AD&D    20050101