Displaying 1 result from an estimated 1 matches for "average_sodium".
2007 Jun 26
1
A really simple data manipulation example
...ne row per patient, with demographic data.
It has columns: PATIENT_ID, GENDER.
Here's a simple example, the following paragraph of code is a
data processing function (dpf) :
inlist LABRESULTS DEMO ;
mergeby PATIENT_ID ;
if (SODIUM == -9) SODIUM = NULL ;
if (VISIT_NUM != 2) deleterow ;
select AVERAGE_SODIUM = avg(SODIUM) by GENDER ;
sendoff(RESULTS_DATASET) GENDER AVERAGE_SODIUM ;
turnoff; // just means end-of-paragraph , version 1.0 won't need this.
Can you guess what it does? The lab result rows are merged with the
demographic rows, just to get the gender information merged in.
Obviously,...