How to create two tables in SAS from one database after sum

[aether]

How to create two tables in SAS from one database. Thanks in advance.

The question goes like this: "Create a set that contains all incident variables (non-cumulative cases): ANGINA, HOSPMI, HYPERTEN, MI_FCHD, STROKE. Create a sum that includes incidents. Conditionally output the data to two different SAS tables: one that has subjects with 1 or more incidents and one with subjects with no incidents." 

What is the principle to summarize the data in order to derive two tables from them: "without incidents" and "1 or more inc."

UPD. How to summarize this data horizontally to get the second table "No incidents (0)" ?

[Reeza]

This depends a lot on your data structure and how you can identify records. 

You can direct output to two different data sets relatively easily.

data females males other; * list of data sets that will be created;

set sashelp.class; *input data;

*conditionally assign to different output data sets;
if sex = 'F' then output females;
else if sex = 'M' then output males;
else output Other;

run;

---

@aether wrote:

How to create two tables in SAS from one database. Thanks in advance.

The question goes like this: "Create a set that contains all incident variables (non-cumulative cases): ANGINA, HOSPMI, HYPERTEN, MI_FCHD, STROKE. Create a sum that includes incidents. Conditionally output the data to two different SAS tables: one that has subjects with 1 or more incidents and one with subjects with no incidents." 

What is the principle to summarize the data in order to derive two tables from them: "without incidents" and "1 or more inc."

---

[VDD]

Please post 2 sets of sample data showing what you have and what you want.

[Reeza]

1. How do you define "no incidents"? What is the logic?
2. Have you tried to modify my code to implement the logic from #1.

[aether]

1. "No incidents" = 0 in whole line. 2. Yes.

[Reeza]

Show your code please.

---

@aether wrote:
1. "No incidents" = 0 in whole line. 2. Yes.

---

[aether]

data dataset;
      infile '\path\dataset.dat' FIRSTOBS = 2 DSD;
      input /*other variables*/ RANDID ANGINA HOSPMI MI_FCHD STROKE HYPERTEN;
 	  keep RANDID ANGINA HOSPMI MI_FCHD HYPERTEN STROKE;
run;
ods html close;
ods html file = "\path\output.html";

/*here, it seems to me, there should be a horizontal summation by RANDID*/

data NOINC INC;
	set work.dataset;
	if /*sum*/ = 0 then output NOINC;
	else if /*sum*/ = >1 then output INC;
run;

[Reeza]

sum(<list of variables go here>)

You're pretty close, just add in your list of variables then.