topic Re: Looking at removed group in New SAS User

Looking at removed group

Viktoreli — Thu, 28 Nov 2019 12:05:15 GMT

Hi!

I have a code where I remove all observations with the same variable A when variable B is not the same number for that same A.

data want(drop=flag);
do until (last. a);
set have;
by a notsorted;
if first. a then _iorc_=b;
if _iorc_ ne b then flag=1;
end;
do until (last. a);
set have;
by a notsorted;
if not flag then output;
end;
run;

Now I want to look at the data I removed.

I want to remove all observations of variable A where the variable B only has a unqiue number for that A.

A B

1 1 2

2 1 2

3 2 4

4 2 4

5 2 5

6 3 1

7 4 2

8 4 1

A B

1 2 4

2 2 4

3 2 5

4 4 2

5 4 1

Help would be much appreciated!!:)

Re: Looking at removed group

Kurt_Bremser — Wed, 27 Nov 2019 14:51:42 GMT

Please:

post data in readily usable form (data step with datalines)
test your code with this data before posting
copy/paste the code directly here

I post this because your code, as posted, can never run.

@Viktoreli wrote:

Hi!

I have a code where I remove all observations with the same variable A when variable B is not not the same number for that same A.
data want(drop=flag);
do until (last. a);
set have;
by a notsorted;
if first. a then _iorc_=ve;
if _iorc_ ne ve then flag=1;
end;
do until (last. a);
set have;
by a notsorted;
if not flag then output;
end;
run;
Now I want to look at the data I removed.

I want to remove all observations of variable A where the variable B only has a unqiue number for that A.

A B

1 1 2

2 1 2

3 2 4

4 2 4

5 2 5

6 3 1

7 4 2

8 4 1

to

A B

1 2 4

2 2 4

3 2 5

4 4 2

5 4 1

Help would be much appreciated!!:)

Re: Looking at removed group

Astounding — Wed, 27 Nov 2019 14:55:00 GMT

It's easiest if you do it while you are separating out the observations you want:

data want removed;
do until (last. a);
   set have;
   by a notsorted;
   if first. a then _iorc_=ve;
   if _iorc_ ne ve then flag=1;
end;
do until (last. a);
   set have;
   by a notsorted;
   if flag then output removed;
   else output want;
end;
drop flag;
run;

This assumes that your original code was working properly to get the observations you want.

Re: Looking at removed group

Viktoreli — Wed, 27 Nov 2019 15:03:44 GMT

Thanks for your reply! Looked at my code and noticed mistakes when changing the names of the variables. I will try to follow your pointers in the future:)!

Re: Looking at removed group

tomrvincent — Wed, 27 Nov 2019 15:37:15 GMT

What does 'is not not the same' mean?

Re: Looking at removed group

Viktoreli — Thu, 28 Nov 2019 12:05:29 GMT

Good question:)

Re: Looking at removed group

Viktoreli — Thu, 28 Nov 2019 12:05:52 GMT

Thank you so much:)