topic Re: how to get the consecutive elevations flagged in SAS Programming

how to get the consecutive elevations flagged

rams — Fri, 04 Jan 2013 09:44:44 GMT

hiii

i have a querry like this

i want to flag the consecutive elevations of the actual_values that are >= 3 times the high_range

by each subject test.

i want those obervation for which the actual values are >= 3 times the high_range by subject test

ataset being sorted by subject test visit.

Thanks.

Jagadishkatam — Fri, 04 Jan 2013 09:55:04 GMT

Hi Rams,

Hope this is what you wanted.

data have;

input subject test $ visit high_range actual_value;

cards;

101 A 1 30 100

101 A 2 30 90

101 A 3 30 80

101 A 4 30 60

101 A 5 30 55

101 A 6 30 65

101 A 7 30 102

101 A 8 30 95

101 B 1 40 130

101 B 2 40 150

101 B 3 40 65

101 B 4 40 85

101 B 5 40 120

101 B 6 40 135

;

data want;

set have;

if actual_value >= 3*high_range then flag=1;

else flag=0;

run;

Thanks,

Jag