topic Re: Tertile in SAS mean in Statistical Procedures

topic Re: Tertile in SAS mean in Statistical Procedures https://communities.sas.com/t5/Statistical-Procedures/Tertile-in-SAS-mean/m-p/472399#M24589 <P>My table consist of patient informations such as their test results, measurements etc...</P><P> from that I just want to calculate the tertile mean and std for the given columns in the table</P><P>like </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sample.png" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/21324i55B5DB409B1AF378/image-size/large?v=v2&px=999" role="button" title="sample.png" alt="sample.png" /></span></P><P>Hope u understand now....</P><P> </P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Weight</TD><TD>follw1_weight</TD></TR><TR><TD>94.75</TD><TD>95.1</TD></TR><TR><TD>77.1</TD><TD>76.1</TD></TR><TR><TD>127</TD><TD>126.7</TD></TR><TR><TD>69.7</TD><TD>69.6</TD></TR><TR><TD>81.4</TD><TD>82.3</TD></TR><TR><TD>92.8</TD><TD>91</TD></TR><TR><TD>84.1</TD><TD>82.8</TD></TR><TR><TD>84.9</TD><TD>83</TD></TR><TR><TD>85.6</TD><TD>82.5</TD></TR><TR><TD>101.2</TD><TD>98.9</TD></TR><TR><TD>72.25</TD><TD>70.8</TD></TR><TR><TD>79.5</TD><TD>80.5</TD></TR><TR><TD>77</TD><TD>75.3</TD></TR><TR><TD>101.8</TD><TD>96.5</TD></TR><TR><TD>84</TD><TD>81.6</TD></TR><TR><TD>89.7</TD><TD>86</TD></TR><TR><TD>115.7</TD><TD>115.7</TD></TR><TR><TD>102.3</TD><TD>97.4</TD></TR><TR><TD>82.4</TD><TD>75.9</TD></TR><TR><TD>87.9</TD><TD>80.9</TD></TR><TR><TD>59.7</TD><TD>55</TD></TR><TR><TD>71.05</TD><TD>71.4</TD></TR><TR><TD>95.7</TD><TD>96</TD></TR><TR><TD>78.2</TD><TD>79.6</TD></TR><TR><TD>79.5</TD><TD>76.1</TD></TR><TR><TD>71.5</TD><TD>70.8</TD></TR><TR><TD>102</TD><TD>101.6</TD></TR><TR><TD>80</TD><TD>76.5</TD></TR><TR><TD>88.9</TD><TD>88.7</TD></TR><TR><TD>78.2</TD><TD>74.75</TD></TR><TR><TD>89.2</TD><TD>90</TD></TR><TR><TD>78.9</TD><TD>78.9</TD></TR><TR><TD>86.1</TD><TD>84.1</TD></TR><TR><TD>76.4</TD><TD>75</TD></TR><TR><TD>88.3</TD><TD>86</TD></TR><TR><TD>82.15</TD><TD>81.3</TD></TR><TR><TD>93.8</TD><TD>92.05</TD></TR><TR><TD>79.2</TD><TD>79.2</TD></TR><TR><TD>66</TD><TD>64.8</TD></TR><TR><TD>95.2</TD><TD>95.4</TD></TR><TR><TD>82.7</TD><TD>81.2</TD></TR><TR><TD>87.5</TD><TD>80.7</TD></TR><TR><TD>106.4</TD><TD>105.3</TD></TR><TR><TD>85.7</TD><TD>85.6</TD></TR><TR><TD>84.1</TD><TD>84.4</TD></TR><TR><TD>114.4</TD><TD>113.4</TD></TR><TR><TD>66.2</TD><TD>66.2</TD></TR><TR><TD>99.9</TD><TD>94.7</TD></TR><TR><TD>68.3</TD><TD>68</TD></TR><TR><TD>75.5</TD><TD>71.65</TD></TR><TR><TD>87</TD><TD>86.9</TD></TR><TR><TD>75.2</TD><TD>68.7</TD></TR><TR><TD>89.3</TD><TD>86.2</TD></TR><TR><TD>88</TD><TD>85.8</TD></TR><TR><TD>81.5</TD><TD>79.9</TD></TR><TR><TD>72.05</TD><TD>72.2</TD></TR><TR><TD>105.4</TD><TD>102.9</TD></TR><TR><TD>68.3</TD><TD>68.7</TD></TR><TR><TD>82.9</TD><TD>86.4</TD></TR><TR><TD>96.3</TD><TD>93.2</TD></TR><TR><TD>83.2</TD><TD>81.9</TD></TR><TR><TD>79.9</TD><TD>89.8</TD></TR><TR><TD>88.7</TD><TD>89.3</TD></TR><TR><TD>97.4</TD><TD>91.6</TD></TR><TR><TD>89.8</TD><TD>88</TD></TR><TR><TD>85</TD><TD>85.8</TD></TR><TR><TD>84.1</TD><TD>78.1</TD></TR><TR><TD>90</TD><TD>88.5</TD></TR><TR><TD>92.1</TD><TD>93.65</TD></TR><TR><TD>119.2</TD><TD>115.2</TD></TR><TR><TD>111.8</TD><TD>96</TD></TR><TR><TD>98.5</TD><TD>102.1</TD></TR><TR><TD>83.4</TD><TD>86.1</TD></TR><TR><TD>92.7</TD><TD>93.3</TD></TR><TR><TD>103.2</TD><TD>105.9</TD></TR><TR><TD>76.3</TD><TD>76.8</TD></TR><TR><TD>104.2</TD><TD>102.1</TD></TR><TR><TD>97.7</TD><TD>94.05</TD></TR><TR><TD>78.6</TD><TD>76.1</TD></TR><TR><TD>108</TD><TD>100.9</TD></TR><TR><TD>62.55</TD><TD>60.85</TD></TR><TR><TD>94</TD><TD>94</TD></TR><TR><TD>99.2</TD><TD>96.8</TD></TR><TR><TD>93.2</TD><TD>92.3</TD></TR><TR><TD>76.65</TD><TD>74.85</TD></TR><TR><TD>82.6</TD><TD>81.7</TD></TR><TR><TD>91.4</TD><TD>88.3</TD></TR><TR><TD>80.9</TD><TD>76.35</TD></TR><TR><TD>99.9</TD><TD>102</TD></TR><TR><TD>114</TD><TD>114.8</TD></TR><TR><TD>104.8</TD><TD>102.9</TD></TR><TR><TD>105.9</TD><TD>101.4</TD></TR><TR><TD>107.3</TD><TD>103.8</TD></TR><TR><TD>63.1</TD><TD>62.8</TD></TR><TR><TD>72.7</TD><TD>69</TD></TR><TR><TD>58.5</TD><TD>57.2</TD></TR><TR><TD>88.7</TD><TD>85.5</TD></TR><TR><TD>86.55</TD><TD>89.2</TD></TR><TR><TD>84.4</TD><TD>81</TD></TR><TR><TD>122.7</TD><TD>120.4</TD></TR><TR><TD>95.35</TD><TD>88.1</TD></TR><TR><TD>91.2</TD><TD>87.5</TD></TR><TR><TD>100</TD><TD>92.5</TD></TR><TR><TD>86.9</TD><TD>57.8</TD></TR><TR><TD>88</TD><TD>84.1</TD></TR><TR><TD>99.2</TD><TD>92.75</TD></TR><TR><TD>73.2</TD><TD>73.75</TD></TR><TR><TD>74.7</TD><TD>73.2</TD></TR><TR><TD>80.3</TD><TD>80.55</TD></TR><TR><TD>73.8</TD><TD>72.5</TD></TR><TR><TD>70.2</TD><TD>69.8</TD></TR><TR><TD>72.7</TD><TD>71.7</TD></TR><TR><TD>83.6</TD><TD>81.1</TD></TR><TR><TD>83.3</TD><TD>82</TD></TR><TR><TD>95.6</TD><TD>93.3</TD></TR><TR><TD>91.1</TD><TD>93</TD></TR><TR><TD>67.3</TD><TD>64.6</TD></TR><TR><TD>117.3</TD><TD>116.5</TD></TR><TR><TD>59.5</TD><TD>58</TD></TR><TR><TD>94.65</TD><TD>89.8</TD></TR><TR><TD>75</TD><TD>74.8</TD></TR><TR><TD>91.65</TD><TD>88.2</TD></TR><TR><TD>102.4</TD><TD>101.2</TD></TR><TR><TD>89.1</TD><TD>84.5</TD></TR><TR><TD>97.9</TD><TD>93.95</TD></TR><TR><TD>110.6</TD><TD>110.6</TD></TR><TR><TD>65.15</TD><TD>64.75</TD></TR><TR><TD>83.85</TD><TD>81.05</TD></TR><TR><TD>88.5</TD><TD>86.3</TD></TR><TR><TD>100.8</TD><TD>98</TD></TR><TR><TD>78.2</TD><TD>71.9</TD></TR><TR><TD>89.85</TD><TD>92.2</TD></TR><TR><TD>91.1</TD><TD>86.2</TD></TR><TR><TD>84.2</TD><TD>78.5</TD></TR><TR><TD>91.1</TD><TD>90.3</TD></TR><TR><TD>76.7</TD><TD>75.3</TD></TR><TR><TD>78.2</TD><TD>75.9</TD></TR><TR><TD>67.55</TD><TD>68</TD></TR><TR><TD>81.1</TD><TD>82.7</TD></TR><TR><TD>72.7</TD><TD>70.2</TD></TR><TR><TD>76.45</TD><TD>74</TD></TR><TR><TD>89.8</TD><TD>85.7</TD></TR><TR><TD>69.2</TD><TD>66.8</TD></TR><TR><TD>76.6</TD><TD>75.4</TD></TR><TR><TD>87.9</TD><TD>86.6</TD></TR><TR><TD>72.55</TD><TD>70.4</TD></TR><TR><TD>86.8</TD><TD>85.6</TD></TR><TR><TD>97</TD><TD>94.1</TD></TR><TR><TD>77.3</TD><TD>76.7</TD></TR><TR><TD>82.4</TD><TD>83.7</TD></TR><TR><TD>79.55</TD><TD>79.25</TD></TR><TR><TD>89.6</TD><TD>90</TD></TR><TR><TD>103.2</TD><TD>95.6</TD></TR><TR><TD>72.1</TD><TD>66.7</TD></TR><TR><TD>89.5</TD><TD>90.6</TD></TR><TR><TD>83.4</TD><TD>83.06</TD></TR><TR><TD>115.9</TD><TD>114.6</TD></TR><TR><TD>123.2</TD><TD>122.1</TD></TR><TR><TD>81.6</TD><TD>80.2</TD></TR><TR><TD>84.9</TD><TD>87.6</TD></TR><TR><TD>87.95</TD><TD>88.75</TD></TR><TR><TD>95.5</TD><TD>95.6</TD></TR><TR><TD>93.6</TD><TD>90.4</TD></TR><TR><TD>84.3</TD><TD>82.35</TD></TR><TR><TD>73.5</TD><TD>70.9</TD></TR><TR><TD>111.3</TD><TD>109</TD></TR><TR><TD>116.5</TD><TD>112.2</TD></TR><TR><TD>75.3</TD><TD>69.9</TD></TR><TR><TD>72.8</TD><TD>71.05</TD></TR><TR><TD>82.6</TD><TD>80.5</TD></TR><TR><TD>69.65</TD><TD>66.5</TD></TR><TR><TD>95.4</TD><TD>95.2</TD></TR><TR><TD>77.15</TD><TD>75.75</TD></TR><TR><TD>75.8</TD><TD>73.45</TD></TR><TR><TD>84.1</TD><TD>82.1</TD></TR><TR><TD>94</TD><TD>89.6</TD></TR><TR><TD>89.7</TD><TD>89.5</TD></TR><TR><TD>86.2</TD><TD>85</TD></TR><TR><TD>93.2</TD><TD>89.5</TD></TR><TR><TD>86.7</TD><TD>86.2</TD></TR><TR><TD>100.5</TD><TD>96.7</TD></TR><TR><TD>89.5</TD><TD>87.8</TD></TR><TR><TD>70.7</TD><TD>64.95</TD></TR></TBODY></TABLE><P> </P> Fri, 22 Jun 2018 08:06:35 GMT Sathish_jammy 2018-06-22T08:06:35Z Tertile in SAS mean https://communities.sas.com/t5/Statistical-Procedures/Tertile-in-SAS-mean/m-p/472386#M24587 <P>HI,</P><P> </P><P>I want to get a (Tertile) mean and STD of column(Weight) as</P><P>Example:</P><P> </P><P>(Weight)           Mean           STD</P><P>1st tertile            77.23           5.2</P><P>2nd tertile           86.52           7.7</P><P>3rd tertile            101.82        6.8</P><P><BR />Please post the accurate code/ method to complete further. </P><P>Thanks.</P><P> </P> Fri, 22 Jun 2018 07:06:28 GMT https://communities.sas.com/t5/Statistical-Procedures/Tertile-in-SAS-mean/m-p/472386#M24587 Sathish_jammy 2018-06-22T07:06:28Z Re: Tertile in SAS mean https://communities.sas.com/t5/Statistical-Procedures/Tertile-in-SAS-mean/m-p/472394#M24588 <P>Please provide some example data for calculation.</P> Fri, 22 Jun 2018 07:50:17 GMT https://communities.sas.com/t5/Statistical-Procedures/Tertile-in-SAS-mean/m-p/472394#M24588 PeterClemmensen 2018-06-22T07:50:17Z Re: Tertile in SAS mean https://communities.sas.com/t5/Statistical-Procedures/Tertile-in-SAS-mean/m-p/472399#M24589 <P>My table consist of patient informations such as their test results, measurements etc...</P><P> from that I just want to calculate the tertile mean and std for the given columns in the table</P><P>like </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sample.png" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/21324i55B5DB409B1AF378/image-size/large?v=v2&px=999" role="button" title="sample.png" alt="sample.png" /></span></P><P>Hope u understand now....</P><P> </P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Weight</TD><TD>follw1_weight</TD></TR><TR><TD>94.75</TD><TD>95.1</TD></TR><TR><TD>77.1</TD><TD>76.1</TD></TR><TR><TD>127</TD><TD>126.7</TD></TR><TR><TD>69.7</TD><TD>69.6</TD></TR><TR><TD>81.4</TD><TD>82.3</TD></TR><TR><TD>92.8</TD><TD>91</TD></TR><TR><TD>84.1</TD><TD>82.8</TD></TR><TR><TD>84.9</TD><TD>83</TD></TR><TR><TD>85.6</TD><TD>82.5</TD></TR><TR><TD>101.2</TD><TD>98.9</TD></TR><TR><TD>72.25</TD><TD>70.8</TD></TR><TR><TD>79.5</TD><TD>80.5</TD></TR><TR><TD>77</TD><TD>75.3</TD></TR><TR><TD>101.8</TD><TD>96.5</TD></TR><TR><TD>84</TD><TD>81.6</TD></TR><TR><TD>89.7</TD><TD>86</TD></TR><TR><TD>115.7</TD><TD>115.7</TD></TR><TR><TD>102.3</TD><TD>97.4</TD></TR><TR><TD>82.4</TD><TD>75.9</TD></TR><TR><TD>87.9</TD><TD>80.9</TD></TR><TR><TD>59.7</TD><TD>55</TD></TR><TR><TD>71.05</TD><TD>71.4</TD></TR><TR><TD>95.7</TD><TD>96</TD></TR><TR><TD>78.2</TD><TD>79.6</TD></TR><TR><TD>79.5</TD><TD>76.1</TD></TR><TR><TD>71.5</TD><TD>70.8</TD></TR><TR><TD>102</TD><TD>101.6</TD></TR><TR><TD>80</TD><TD>76.5</TD></TR><TR><TD>88.9</TD><TD>88.7</TD></TR><TR><TD>78.2</TD><TD>74.75</TD></TR><TR><TD>89.2</TD><TD>90</TD></TR><TR><TD>78.9</TD><TD>78.9</TD></TR><TR><TD>86.1</TD><TD>84.1</TD></TR><TR><TD>76.4</TD><TD>75</TD></TR><TR><TD>88.3</TD><TD>86</TD></TR><TR><TD>82.15</TD><TD>81.3</TD></TR><TR><TD>93.8</TD><TD>92.05</TD></TR><TR><TD>79.2</TD><TD>79.2</TD></TR><TR><TD>66</TD><TD>64.8</TD></TR><TR><TD>95.2</TD><TD>95.4</TD></TR><TR><TD>82.7</TD><TD>81.2</TD></TR><TR><TD>87.5</TD><TD>80.7</TD></TR><TR><TD>106.4</TD><TD>105.3</TD></TR><TR><TD>85.7</TD><TD>85.6</TD></TR><TR><TD>84.1</TD><TD>84.4</TD></TR><TR><TD>114.4</TD><TD>113.4</TD></TR><TR><TD>66.2</TD><TD>66.2</TD></TR><TR><TD>99.9</TD><TD>94.7</TD></TR><TR><TD>68.3</TD><TD>68</TD></TR><TR><TD>75.5</TD><TD>71.65</TD></TR><TR><TD>87</TD><TD>86.9</TD></TR><TR><TD>75.2</TD><TD>68.7</TD></TR><TR><TD>89.3</TD><TD>86.2</TD></TR><TR><TD>88</TD><TD>85.8</TD></TR><TR><TD>81.5</TD><TD>79.9</TD></TR><TR><TD>72.05</TD><TD>72.2</TD></TR><TR><TD>105.4</TD><TD>102.9</TD></TR><TR><TD>68.3</TD><TD>68.7</TD></TR><TR><TD>82.9</TD><TD>86.4</TD></TR><TR><TD>96.3</TD><TD>93.2</TD></TR><TR><TD>83.2</TD><TD>81.9</TD></TR><TR><TD>79.9</TD><TD>89.8</TD></TR><TR><TD>88.7</TD><TD>89.3</TD></TR><TR><TD>97.4</TD><TD>91.6</TD></TR><TR><TD>89.8</TD><TD>88</TD></TR><TR><TD>85</TD><TD>85.8</TD></TR><TR><TD>84.1</TD><TD>78.1</TD></TR><TR><TD>90</TD><TD>88.5</TD></TR><TR><TD>92.1</TD><TD>93.65</TD></TR><TR><TD>119.2</TD><TD>115.2</TD></TR><TR><TD>111.8</TD><TD>96</TD></TR><TR><TD>98.5</TD><TD>102.1</TD></TR><TR><TD>83.4</TD><TD>86.1</TD></TR><TR><TD>92.7</TD><TD>93.3</TD></TR><TR><TD>103.2</TD><TD>105.9</TD></TR><TR><TD>76.3</TD><TD>76.8</TD></TR><TR><TD>104.2</TD><TD>102.1</TD></TR><TR><TD>97.7</TD><TD>94.05</TD></TR><TR><TD>78.6</TD><TD>76.1</TD></TR><TR><TD>108</TD><TD>100.9</TD></TR><TR><TD>62.55</TD><TD>60.85</TD></TR><TR><TD>94</TD><TD>94</TD></TR><TR><TD>99.2</TD><TD>96.8</TD></TR><TR><TD>93.2</TD><TD>92.3</TD></TR><TR><TD>76.65</TD><TD>74.85</TD></TR><TR><TD>82.6</TD><TD>81.7</TD></TR><TR><TD>91.4</TD><TD>88.3</TD></TR><TR><TD>80.9</TD><TD>76.35</TD></TR><TR><TD>99.9</TD><TD>102</TD></TR><TR><TD>114</TD><TD>114.8</TD></TR><TR><TD>104.8</TD><TD>102.9</TD></TR><TR><TD>105.9</TD><TD>101.4</TD></TR><TR><TD>107.3</TD><TD>103.8</TD></TR><TR><TD>63.1</TD><TD>62.8</TD></TR><TR><TD>72.7</TD><TD>69</TD></TR><TR><TD>58.5</TD><TD>57.2</TD></TR><TR><TD>88.7</TD><TD>85.5</TD></TR><TR><TD>86.55</TD><TD>89.2</TD></TR><TR><TD>84.4</TD><TD>81</TD></TR><TR><TD>122.7</TD><TD>120.4</TD></TR><TR><TD>95.35</TD><TD>88.1</TD></TR><TR><TD>91.2</TD><TD>87.5</TD></TR><TR><TD>100</TD><TD>92.5</TD></TR><TR><TD>86.9</TD><TD>57.8</TD></TR><TR><TD>88</TD><TD>84.1</TD></TR><TR><TD>99.2</TD><TD>92.75</TD></TR><TR><TD>73.2</TD><TD>73.75</TD></TR><TR><TD>74.7</TD><TD>73.2</TD></TR><TR><TD>80.3</TD><TD>80.55</TD></TR><TR><TD>73.8</TD><TD>72.5</TD></TR><TR><TD>70.2</TD><TD>69.8</TD></TR><TR><TD>72.7</TD><TD>71.7</TD></TR><TR><TD>83.6</TD><TD>81.1</TD></TR><TR><TD>83.3</TD><TD>82</TD></TR><TR><TD>95.6</TD><TD>93.3</TD></TR><TR><TD>91.1</TD><TD>93</TD></TR><TR><TD>67.3</TD><TD>64.6</TD></TR><TR><TD>117.3</TD><TD>116.5</TD></TR><TR><TD>59.5</TD><TD>58</TD></TR><TR><TD>94.65</TD><TD>89.8</TD></TR><TR><TD>75</TD><TD>74.8</TD></TR><TR><TD>91.65</TD><TD>88.2</TD></TR><TR><TD>102.4</TD><TD>101.2</TD></TR><TR><TD>89.1</TD><TD>84.5</TD></TR><TR><TD>97.9</TD><TD>93.95</TD></TR><TR><TD>110.6</TD><TD>110.6</TD></TR><TR><TD>65.15</TD><TD>64.75</TD></TR><TR><TD>83.85</TD><TD>81.05</TD></TR><TR><TD>88.5</TD><TD>86.3</TD></TR><TR><TD>100.8</TD><TD>98</TD></TR><TR><TD>78.2</TD><TD>71.9</TD></TR><TR><TD>89.85</TD><TD>92.2</TD></TR><TR><TD>91.1</TD><TD>86.2</TD></TR><TR><TD>84.2</TD><TD>78.5</TD></TR><TR><TD>91.1</TD><TD>90.3</TD></TR><TR><TD>76.7</TD><TD>75.3</TD></TR><TR><TD>78.2</TD><TD>75.9</TD></TR><TR><TD>67.55</TD><TD>68</TD></TR><TR><TD>81.1</TD><TD>82.7</TD></TR><TR><TD>72.7</TD><TD>70.2</TD></TR><TR><TD>76.45</TD><TD>74</TD></TR><TR><TD>89.8</TD><TD>85.7</TD></TR><TR><TD>69.2</TD><TD>66.8</TD></TR><TR><TD>76.6</TD><TD>75.4</TD></TR><TR><TD>87.9</TD><TD>86.6</TD></TR><TR><TD>72.55</TD><TD>70.4</TD></TR><TR><TD>86.8</TD><TD>85.6</TD></TR><TR><TD>97</TD><TD>94.1</TD></TR><TR><TD>77.3</TD><TD>76.7</TD></TR><TR><TD>82.4</TD><TD>83.7</TD></TR><TR><TD>79.55</TD><TD>79.25</TD></TR><TR><TD>89.6</TD><TD>90</TD></TR><TR><TD>103.2</TD><TD>95.6</TD></TR><TR><TD>72.1</TD><TD>66.7</TD></TR><TR><TD>89.5</TD><TD>90.6</TD></TR><TR><TD>83.4</TD><TD>83.06</TD></TR><TR><TD>115.9</TD><TD>114.6</TD></TR><TR><TD>123.2</TD><TD>122.1</TD></TR><TR><TD>81.6</TD><TD>80.2</TD></TR><TR><TD>84.9</TD><TD>87.6</TD></TR><TR><TD>87.95</TD><TD>88.75</TD></TR><TR><TD>95.5</TD><TD>95.6</TD></TR><TR><TD>93.6</TD><TD>90.4</TD></TR><TR><TD>84.3</TD><TD>82.35</TD></TR><TR><TD>73.5</TD><TD>70.9</TD></TR><TR><TD>111.3</TD><TD>109</TD></TR><TR><TD>116.5</TD><TD>112.2</TD></TR><TR><TD>75.3</TD><TD>69.9</TD></TR><TR><TD>72.8</TD><TD>71.05</TD></TR><TR><TD>82.6</TD><TD>80.5</TD></TR><TR><TD>69.65</TD><TD>66.5</TD></TR><TR><TD>95.4</TD><TD>95.2</TD></TR><TR><TD>77.15</TD><TD>75.75</TD></TR><TR><TD>75.8</TD><TD>73.45</TD></TR><TR><TD>84.1</TD><TD>82.1</TD></TR><TR><TD>94</TD><TD>89.6</TD></TR><TR><TD>89.7</TD><TD>89.5</TD></TR><TR><TD>86.2</TD><TD>85</TD></TR><TR><TD>93.2</TD><TD>89.5</TD></TR><TR><TD>86.7</TD><TD>86.2</TD></TR><TR><TD>100.5</TD><TD>96.7</TD></TR><TR><TD>89.5</TD><TD>87.8</TD></TR><TR><TD>70.7</TD><TD>64.95</TD></TR></TBODY></TABLE><P> </P> Fri, 22 Jun 2018 08:06:35 GMT https://communities.sas.com/t5/Statistical-Procedures/Tertile-in-SAS-mean/m-p/472399#M24589 Sathish_jammy 2018-06-22T08:06:35Z Re: Tertile in SAS mean https://communities.sas.com/t5/Statistical-Procedures/Tertile-in-SAS-mean/m-p/472490#M24598 <P>Use PROC RANK GROUPS=3 to add a variable with tertile scores to your data. Then just use PROC MEANS; CLASS tertile; VAR weight; </P> Fri, 22 Jun 2018 14:09:57 GMT https://communities.sas.com/t5/Statistical-Procedures/Tertile-in-SAS-mean/m-p/472490#M24598 StatDave 2018-06-22T14:09:57Z Re: Tertile in SAS mean https://communities.sas.com/t5/Statistical-Procedures/Tertile-in-SAS-mean/m-p/472688#M24607 <P>Note for future readers: This thread was continued <A href="https://communities.sas.com/t5/Base-SAS-Programming/Percentile-using-mean/m-p/472431" target="_self">there</A>.</P> Sat, 23 Jun 2018 10:04:16 GMT https://communities.sas.com/t5/Statistical-Procedures/Tertile-in-SAS-mean/m-p/472688#M24607 FreelanceReinh 2018-06-23T10:04:16Z