topic Re: if then output number of observation in SAS Programming

if then output number of observation

Akter — Sat, 29 May 2021 12:39:55 GMT

Hello i have the below data & the program. How come the number of observation in work.test3 has 4 observations instead of 3.

data dbp;
input id sbp dbp;
datalines;
2001 145 92
2002 130 87
2003 117 78
2004 135 85
2005 145 79
;
run;

data
work.test1
work.test2
work.test3;
set dbp;
if sbp gt 140 and dbp gt 90 then output work.test1;
if sbp gt 120 and dbp lt 80 then output work.test2;
else output work.test3;
run;

Thank you in advance for your help.

Akter

Re: if then output number of observation

Sajid01 — Sat, 29 May 2021 14:37:45 GMT

Hello
Add an else as shown below. It will solve your issue

data
work.test1
work.test2
work.test3;
set dbp;
if sbp gt 140 and dbp gt 90 then output work.test1;
else
if sbp gt 120 and dbp lt 80 then output work.test2;
else output work.test3;
run;

Re: if then output number of observation

Akter — Sat, 29 May 2021 15:28:53 GMT

Thank you so much!