topic Re: how to calculate low and high ranges of weeks in SAS Programming

how to calculate low and high ranges of weeks

vraj1 — Wed, 21 Jun 2017 10:14:28 GMT

I have a week variable and need to create lowrange and high range i.e duration of that week. Can anyone help me how to do it or hint on what function can be used. the below is a sample of result.

week Lrange Hrange

Week 0	1	27
Week 4	28	55
Week 8	56	83
Week 12	84	125
Week 18	126	167
Week 24	168	174

Re: how to calculate low and high ranges of weeks

RW9 — Wed, 21 Jun 2017 10:30:56 GMT

Once again, please follow the guidance by the post button. Post test data in the form of a datastep, show what the output should look like, and explain the logic between them. How can I can create an output based on data I cannot see? Probably something like:

select week,min(val) as lrange,max(val) as mrange from have group by week;

Re: how to calculate low and high ranges of weeks

ballardw — Wed, 21 Jun 2017 14:18:05 GMT

Proc means, summary or tabulate will do some form of this.

How ever you are looking for MIN and MAX of some variable within a time frame. Range = Max-min, so "low range" makes no sense in standard terminology.

Some thing like:

proc means data=your data min max;

class week;

var nameofvartoreport;

run;