topic Re: How to get reference ranges in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/How-to-get-reference-ranges/m-p/106598#M29702 <HTML><HEAD></HEAD><BODY><P>Typically a 'reference range' is an external number that is not derived from the data.</P></BODY></HTML> Wed, 29 Aug 2012 01:25:05 GMT Doc_Duke 2012-08-29T01:25:05Z How to get reference ranges https://communities.sas.com/t5/SAS-Procedures/How-to-get-reference-ranges/m-p/106596#M29700 <HTML><HEAD></HEAD><BODY><P>Hi, is there a procedure of code in SAS where I can get reference ranges?<BR />For example I have 20 cities with home prices for each month for 2 years for each city.</P><P></P><P>I do have the standard Deviation and the Coefficient of Variation, but am looking to see if a range of the Prices are more in an optimal range then others.. almost like identifying outliers.&nbsp; So for example if the range of City-A is between 300,000 and 500,00, is optimal, anyhting outside of that range is considered an outlier, or whatever term you may call it.&nbsp;&nbsp; Thanks</P></BODY></HTML> Tue, 28 Aug 2012 20:25:34 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-get-reference-ranges/m-p/106596#M29700 podarum 2012-08-28T20:25:34Z Re: How to get reference ranges https://communities.sas.com/t5/SAS-Procedures/How-to-get-reference-ranges/m-p/106597#M29701 <HTML><HEAD></HEAD><BODY><P>Try the UNIVARIATE procedure. It identifies your lowest and highest values plus percentiles, means, medians etc. You could use a BY statement on your city variable to look at percentile variations between cities.</P></BODY></HTML> Tue, 28 Aug 2012 23:15:33 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-get-reference-ranges/m-p/106597#M29701 SASKiwi 2012-08-28T23:15:33Z Re: How to get reference ranges https://communities.sas.com/t5/SAS-Procedures/How-to-get-reference-ranges/m-p/106598#M29702 <HTML><HEAD></HEAD><BODY><P>Typically a 'reference range' is an external number that is not derived from the data.</P></BODY></HTML> Wed, 29 Aug 2012 01:25:05 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-get-reference-ranges/m-p/106598#M29702 Doc_Duke 2012-08-29T01:25:05Z Re: How to get reference ranges https://communities.sas.com/t5/SAS-Procedures/How-to-get-reference-ranges/m-p/106599#M29703 <HTML><HEAD></HEAD><BODY><P>Agreed, Doc.&nbsp; But how about generating that reference range for the 'first' time?&nbsp; Lately, I have been tasked with doing something like that with historical control data in tox studies.&nbsp; UNIVARIATE is my tool of choice--normality testing, percentiles, etc. Ultimately, I want to incorporate this info as a prior distribution for some Bayesian analyses.</P><P></P><P>Steve Denham</P></BODY></HTML> Wed, 29 Aug 2012 12:04:57 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-get-reference-ranges/m-p/106599#M29703 SteveDenham 2012-08-29T12:04:57Z Re: How to get reference ranges https://communities.sas.com/t5/SAS-Procedures/How-to-get-reference-ranges/m-p/106600#M29704 <HTML><HEAD></HEAD><BODY><P>Steve,</P><P></P><P>Often the "reference range' comes from historical controls.&nbsp; Sometimes from specific analysis of known normals (typical for clinical lab tests).&nbsp; I worry about podarum's approach of using the 'study data' to derive the ranges, particularly for housing prices (we know they have been problematic over the last several years).</P><P></P><P>Doc</P></BODY></HTML> Wed, 29 Aug 2012 13:18:23 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-get-reference-ranges/m-p/106600#M29704 Doc_Duke 2012-08-29T13:18:23Z Re: How to get reference ranges https://communities.sas.com/t5/SAS-Procedures/How-to-get-reference-ranges/m-p/106601#M29705 <HTML><HEAD></HEAD><BODY><P>Doc,</P><P></P><P>I agree about using 'study data' for ranges--it's like using EDA methods as confirmatory stats.&nbsp; Of course you find something, you just spent 15 hours digging around looking for anything shiny.</P><P></P><P>Steve Denham</P></BODY></HTML> Thu, 30 Aug 2012 12:01:56 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-get-reference-ranges/m-p/106601#M29705 SteveDenham 2012-08-30T12:01:56Z