Help using Base SAS procedures

A question

Reply
Frequent Contributor
Posts: 131

A question

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?
Super User
Posts: 9,681

Re: A question

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
Frequent Contributor
Posts: 131

Re: A question

Thanks for your help, Ksharp.
Ask a Question
Discussion stats
  • 2 replies
  • 119 views
  • 0 likes
  • 2 in conversation