topic Subsetting data in SAS Enterprise Guide

Subsetting data

VarunD — Wed, 19 Dec 2018 21:14:55 GMT

Hello,

Please help me with the code for the following problem:

Data: MEMBER TABLE

MemberID Group County AddressType
A 111 Newman H
A 111 Fritz M
A 111 Damus I
B 114 Holler H
C 114 Boxing H
D 114 Dockers M

I want to select observations on the following basis:

1.) When MemberID is same under a particular Group then select/get the observation with AddressType 'H'
2.) When MemberID is different under a particular Group then select/get all the observations.

Here is what I am hoping to get:

MemberID Group County AddressType
A 111 Newman H
B 114 Holler H
C 114 Boxing H
D 114 Dockers M

Thanks,

Varun

Re: Subsetting data

novinosrin — Wed, 19 Dec 2018 21:19:07 GMT

data have;
input MemberID     $     Group        County    $       AddressType $;
cards;
      A                    111           Newman              H
      A                    111           Fritz                     M
      A                    111            Damus                 I
      B                    114           Holler                  H
      C                    114           Boxing                H
      D                    114           Dockers              M
	  ;

proc sql;
create table want(drop=t) as
select *,count(distinct memberid)>1 as t
from have
group by group
having (not t and AddressType='H') or t ;
quit;

Re: Subsetting data

VarunD — Wed, 19 Dec 2018 21:23:03 GMT

Sincerely appreciate your help with this. Thanks again!

Re: Subsetting data

novinosrin — Wed, 19 Dec 2018 21:25:53 GMT

You're very welcome. Thank you for your questions 🙂