s-news
[Top] [All Lists]

Data Extraction

To: <s-news@lists.biostat.wustl.edu>
Subject: Data Extraction
From: "Bruce Green" <brucegreen@verizon.net>
Date: Mon, 22 Nov 2004 18:40:17 -0500
Thread-index: AcTQ7J8zAPUCYbK8SXSijHaMKc7S6w==

Hi,

I have a large dataset of 20000 rows that contains 180 individuals identified by a unique identification number. There are 5 columns of data with health status data in each column, and a different number of rows for each individual i.e. 5 rows for individual 1 and 20 rows for individual no. 2. I wish to extract the data from the first 3 rows for each individual and then perform a data function for each individual....i.e. what is the average blood pressure for individual 1 in the first 3 rows of their data?

 

I cannot seem to do this easily...any suggestions?

 

Regards

Dr Bruce Green

 

<Prev in Thread] Current Thread [Next in Thread>