topic Re: A question in SAS Procedures

A question

bncoxuk — Wed, 08 Jun 2011 09:37:31 GMT

I have a data with the format as:

Type PH SEQ
A Y 1
A N 2
A N 3
A N 4
B Y 2
B N 1
B N 3
B N 5

The data can be easily sorted based on Type, PH and SEQ as shown above. Now the question is to pick up:
1) all the records with PH=Y, and
2) the first two records in the sorted data where PH=N.

So the results should be like:
Type PH SEQ
A Y 1
A N 2
A N 3
B Y 2
B N 1
B N 3

How can I do that?

Re: A question

Ksharp — Wed, 08 Jun 2011 10:01:12 GMT

Easy.

[pre]

data temp;
input Type $ PH $ SEQ;
cards;
A Y 1
A N 2
A N 3
A N 4
B Y 2
B N 1
B N 3
B N 5
;
run;
data want;
set temp;
by type;
if first.type then count=0;
if ph='Y' then output;
else if ph='N' then count+1;
if count le 2 and ph='N' then output;
run;
[/pre]

Ksharp

Re: A question

bncoxuk — Wed, 08 Jun 2011 10:46:51 GMT

Thanks for your help, Ksharp.