Displaying 1 result from an estimated 1 matches for "sendoff".
2007 Jun 26
1
A really simple data manipulation example
....
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, they are merged by patient. The co...