topic Re: Help - how to identify overlap in different categories in SAS Programming

Help - how to identify overlap in different categories

Hani18 — Tue, 19 Oct 2021 02:04:30 GMT

hey friends, I've been stuck on the problem. can someone please help me with this

Information on presence or absence (yes or no) of two characteristics A and B is available for several individuals.

ID A B
217 no no
229 no yes
156 yes no
205 yes no
178 no yes
101 yes yes
112 no no
222 no yes
105 yes yes
144 no no
211 yes yes
244 no yes
139 yes yes
166 no no
109 yes yes
178 no yes
243 yes yes
219 no no
113 yes yes
194 no yes

Compute the number of individuals who have

(a) characteristic A

(b) characteristic B

(d) only characteristic B

(e) both characteristics

(f) neither characteristic

(g) either characteristic

Re: Help

japelin — Tue, 19 Oct 2021 00:44:45 GMT

Please include appropriate words in the title.

The sample code is given below.
For the rest, please think a little on your own.

data have;
length id 8 a $3 b $3;
input id a b;
datalines;
217 no no
229 no yes
156 yes no
205 yes no
178 no yes
101 yes yes
112 no no
222 no yes
105 yes yes
144 no no
211 yes yes
244 no yes
139 yes yes
166 no no
109 yes yes
178 no yes
243 yes yes
219 no no
113 yes yes
194 no yes
run;

data want_a;
  set have;
  where a='yes';
run;
data want_c;
  set have;
  where a='yes' and b='no';
run;

Re: Help

whymath — Tue, 19 Oct 2021 00:52:44 GMT

data have;
  input ID$ A$ B$;
  cards;
217 no no
229 no yes
156 yes no
205 yes no
178 no yes
101 yes yes
112 no no
222 no yes
105 yes yes
144 no no
211 yes yes
244 no yes
139 yes yes
166 no no
109 yes yes
178 no yes
243 yes yes
219 no no
113 yes yes
194 no yes
;
run;

data want;
  set have end = eof;
    
  _A + (A = 'yes');
  _B + (B = 'yes');
  _C + (A = 'yes' and B ^= 'yes');
  _D + (B = 'yes' and A ^= 'yes');
  _E + (A = 'yes' and B = 'yes');
  _F + (A ^= 'yes' and B ^= 'yes');
  _G + (A = 'yes' or B = 'yes');
  if eof;

  put (_A _B _C _D _E _F _G) (=);
run;
_A=9 _B=13 _C=2 _D=6 _E=7 _F=5 _G=15

It is a very basic question, I really recommend you to learn <The little SAS book> immediately.

Re: Help - how to identify overlap in different categories

Reeza — Tue, 19 Oct 2021 02:06:12 GMT

FYI - I've updated your subject line of the question to make it more related to your question otherwise every question on here would have the same title.

This question is testing your knowledge of AND/OR logic.
An IF/WHERE statement would be the most likely solution here.

@Hani18 wrote:

hey friends, I've been stuck on the problem. can someone please help me with this

Information on presence or absence (yes or no) of two characteristics A and B is available for several individuals.

ID A B
217 no no
229 no yes
156 yes no
205 yes no
178 no yes
101 yes yes
112 no no
222 no yes
105 yes yes
144 no no
211 yes yes
244 no yes
139 yes yes
166 no no
109 yes yes
178 no yes
243 yes yes
219 no no
113 yes yes
194 no yes

Compute the number of individuals who have

(a) characteristic A

(b) characteristic B

(c) only characteristic A

(d) only characteristic B

(e) both characteristics

(f) neither characteristic

(g) either characteristic