Liveborn and stillborn average by parity

Top  Previous  Next

I would like to see the average number of liveborn and stillborn by parity, of females with a service date after August 1, 2001:

 

Use Breakdown report designer. The setup screen is shown below:

 

Tables:

PARITYEX

Variable:

PARITY

Variables to Analyze:

LIVEBORN, STILLBORN

Functions:

Arithmetic Mean

Filtering

SERVDATE>='2003-AUG-01'

 

The Breakdown report is shown below:

zoa-15

 

Another option is to use the Query report designer. The setup screen for the Query report is shown below:

 

Tables:

PARITYEX

Columns:

PARITY (Group=Yes), LIVEBORN (Function=Avg), STILLBORN (Function=Avg)

Criteria:

SERVDATE>='2003-AUG-01'

Sorting:

PARITY

 

Or you can use SQL directly:

SELECT PARITY, AVG ( CAST(LIVEBORN AS FLOAT)), AVG ( CAST(STILLBORN AS FLOAT))
FROM PARITYEX
WHERE SERVDATE>='2003-AUG-01'
GROUP BY PARITY ORDER BY PARITY

The Query report is shown below:

 

zoa-16