DATA Step, Macro, Functions and more

why i cannot get rid of the second or third records of the same person

Accepted Solution Solved
Reply
Super Contributor
Posts: 345
Accepted Solution

why i cannot get rid of the second or third records of the same person

data ab2 dup;

set ab1;

by id date;

if first.date then output ab2;

else output dup;

run;

 

A patient has multiple visits and I only need to see the first vist. But with the above code, I cannot find any duplicate records.

ANy advice how to remove the same ID with later visits, that might be second, third or even more visits?

Thanks.


Accepted Solutions
Solution
‎06-14-2016 11:02 AM
Super User
Posts: 11,343

Re: why i cannot get rid of the second or third records of the same person

If you want one per ID then use

 

if first.id then output ab2;

else output dup;

View solution in original post


All Replies
Super User
Super User
Posts: 7,949

Re: why i cannot get rid of the second or third records of the same person

You haven't shown your data, but I assume from the code that each row of data has a different value in DATE variable.  Therefore when:

if first.date 

Is evaluated every row is different.  Do you not have a visit variable, i.e. VISIT 1, VISIT 2 etc. you could use that.  Or if the DATE variable is actually a datetime then use datepart() function to use only the date.  Without further information on your data I can't say.

Super Contributor
Posts: 345

Re: why i cannot get rid of the second or third records of the same person

yes each row of data has a different value in date variable

I do not have a visit variable, and date variable is a datetime,

can you provide a sas sample code as how to use datepart( )?

Thanks

Solution
‎06-14-2016 11:02 AM
Super User
Posts: 11,343

Re: why i cannot get rid of the second or third records of the same person

If you want one per ID then use

 

if first.id then output ab2;

else output dup;

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 219 views
  • 1 like
  • 3 in conversation