- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
hello,
I'm trying to find a solution how to apply multple conditions, or another code that can help me with this condition.
My outcome is "MetSind", and I have 5 condtions. At least there should be accomplished three of them to get MetSind=yes
1. waist>88
2. tg>=150 or hyplip_treat=yes
3. hdl_c<50
4. msbp>=130 or mdbp>=85 or hta_treat=yes
5. glu>=100 or dm_dx=yes
I was trying to use this code: if ((waist>88) or (tg>=150 or hyplip_treat=yes) or (hdl_c<50) or (msbp>=130 or mdbp>=85 or hta_treat=yes) and (glu>=100 or dm_dx=yes)) then MetS=1 ; else MetS=0. But, clearly it doesn't work.
I am beginner sas user so I would like some expert's help.
Thanks for replying.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Make use of the fact that boolean values in SAS are represented as 0 and 1:
if
(waist > 88) +
(tg >= 150 or b6_1_3 = 2) +
(hdl_c < 50) +
(msbp >= 130 or mdbp >= 85 or b6_1_2 = 2) +
(glu_0 >= 100 or dm_dx = 2)
>= 3
then MetS = 1;
else MetS = 0;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Make use of the fact that boolean values in SAS are represented as 0 and 1:
if
(waist > 88) +
(tg >= 150 or b6_1_3 = 2) +
(hdl_c < 50) +
(msbp >= 130 or mdbp >= 85 or b6_1_2 = 2) +
(glu_0 >= 100 or dm_dx = 2)
>= 3
then MetS = 1;
else MetS = 0;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much for your valious feedback. It worked perfect.