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
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;
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.
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
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.