topic Re: How to create two tables in SAS from one database after sum in New SAS User

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

aether — Sat, 20 Oct 2018 23:37:06 GMT

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)" ?

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

Reeza — Sat, 20 Oct 2018 21:05:08 GMT

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."

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

VDD — Sat, 20 Oct 2018 22:01:01 GMT

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

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

Reeza — Sun, 21 Oct 2018 01:12:34 GMT

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.

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

aether — Sun, 21 Oct 2018 01:17:33 GMT

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

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

Reeza — Sun, 21 Oct 2018 01:19:53 GMT

Show your code please.

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

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

aether — Sun, 21 Oct 2018 01:27:21 GMT

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;

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

Reeza — Sun, 21 Oct 2018 01:49:58 GMT

sum(<list of variables go here>)

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