BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
veeru
Calcite | Level 5

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

Reeza
Super User

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
Super User

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 17 replies
  • 1427 views
  • 1 like
  • 6 in conversation