topic Re: LOD Function in SAS in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/LOD-Function-in-SAS/m-p/543295#M12079 <P>This is posted to the SAS Visual Analytics community but it does not seem like a VA issue. Which SAS product are you using? For example, SAS Studio?&nbsp;</P> Thu, 14 Mar 2019 20:03:48 GMT Madelyn_SAS 2019-03-14T20:03:48Z LOD Function in SAS https://communities.sas.com/t5/SAS-Visual-Analytics/LOD-Function-in-SAS/m-p/543124#M12076 <P>Dear All,</P><P>&nbsp;</P><P>I want to implement a calculated item from aggregation of an aggregation. In Tableau I would use LOD function, example:</P><P>I want to flag those user with weighted average price over the Role_Bandmax to be 'too_expensive', otherwise just as same as Tier_Role column.</P><P>&nbsp;</P><P>In the table, for TOM, his average price is $174.29, it is over his Role_Bandmax&nbsp; 110, so TOM should be flagged as&nbsp; 'too_expensiv'</P><P>&nbsp;For JERRY, his&nbsp;&nbsp;average price is $108,27, it is lower than his Role_Bandmax, 130, so JERRY should be flagged as same as his Tier_Role, that is 'tier2'</P><TABLE><TBODY><TR><TD>Transaction_ID</TD><TD>User_ID</TD><TD>User_Role</TD><TD>Role_Bandmax</TD><TD>Tier_Role</TD><TD>price</TD><TD>amount</TD><TD>weighted avg price</TD><TD>new_Flag</TD></TR><TR><TD>1</TD><TD>TOM</TD><TD>developer</TD><TD>110</TD><TD>tier1</TD><TD>100</TD><TD>1</TD><TD>174,2857143</TD><TD>too_expensive</TD></TR><TR><TD>2</TD><TD>TOM</TD><TD>developer</TD><TD>110</TD><TD>tier1</TD><TD>90</TD><TD>2</TD><TD>174,2857143</TD><TD>too_expensive</TD></TR><TR><TD>3</TD><TD>TOM</TD><TD>developer</TD><TD>110</TD><TD>tier1</TD><TD>120</TD><TD>3</TD><TD>174,2857143</TD><TD>too_expensive</TD></TR><TR><TD>4</TD><TD>TOM</TD><TD>developer</TD><TD>110</TD><TD>tier1</TD><TD>300</TD><TD>2</TD><TD>174,2857143</TD><TD>too_expensive</TD></TR><TR><TD>5</TD><TD>TOM</TD><TD>developer</TD><TD>110</TD><TD>tier1</TD><TD>200</TD><TD>5</TD><TD>174,2857143</TD><TD>too_expensive</TD></TR><TR><TD>6</TD><TD>TOM</TD><TD>developer</TD><TD>110</TD><TD>tier1</TD><TD>200</TD><TD>1</TD><TD>174,2857143</TD><TD>too_expensive</TD></TR><TR><TD>7</TD><TD>JERRY</TD><TD>Admin</TD><TD>130</TD><TD>tier2</TD><TD>110</TD><TD>3</TD><TD>108,2666667</TD><TD>tier2</TD></TR><TR><TD>8</TD><TD>JERRY</TD><TD>Admin</TD><TD>130</TD><TD>tier2</TD><TD>120</TD><TD>4</TD><TD>108,2666667</TD><TD>tier2</TD></TR><TR><TD>9</TD><TD>JERRY</TD><TD>Admin</TD><TD>130</TD><TD>tier2</TD><TD>140</TD><TD>5</TD><TD>108,2666667</TD><TD>tier2</TD></TR><TR><TD>10</TD><TD>JERRY</TD><TD>Admin</TD><TD>130</TD><TD>tier2</TD><TD>120</TD><TD>6</TD><TD>108,2666667</TD><TD>tier2</TD></TR><TR><TD>11</TD><TD>JERRY</TD><TD>Admin</TD><TD>130</TD><TD>tier2</TD><TD>110</TD><TD>7</TD><TD>108,2666667</TD><TD>tier2</TD></TR><TR><TD>12</TD><TD>JERRY</TD><TD>Admin</TD><TD>130</TD><TD>tier2</TD><TD>130</TD><TD>8</TD><TD>108,2666667</TD><TD>tier2</TD></TR><TR><TD>13</TD><TD>JERRY</TD><TD>Admin</TD><TD>130</TD><TD>tier2</TD><TD>110</TD><TD>9</TD><TD>108,2666667</TD><TD>tier2</TD></TR><TR><TD>14</TD><TD>JERRY</TD><TD>Admin</TD><TD>130</TD><TD>tier2</TD><TD>90</TD><TD>10</TD><TD>108,2666667</TD><TD>tier2</TD></TR><TR><TD>15</TD><TD>JERRY</TD><TD>Admin</TD><TD>130</TD><TD>tier2</TD><TD>90</TD><TD>11</TD><TD>108,2666667</TD><TD>tier2</TD></TR><TR><TD>16</TD><TD>JERRY</TD><TD>Admin</TD><TD>130</TD><TD>tier2</TD><TD>100</TD><TD>12</TD><TD>108,2666667</TD><TD>tier2</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks in advance!</P><P>&nbsp;</P> Thu, 14 Mar 2019 12:38:39 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/LOD-Function-in-SAS/m-p/543124#M12076 emilyaaa 2019-03-14T12:38:39Z Re: LOD Function in SAS https://communities.sas.com/t5/SAS-Visual-Analytics/LOD-Function-in-SAS/m-p/543295#M12079 <P>This is posted to the SAS Visual Analytics community but it does not seem like a VA issue. Which SAS product are you using? For example, SAS Studio?&nbsp;</P> Thu, 14 Mar 2019 20:03:48 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/LOD-Function-in-SAS/m-p/543295#M12079 Madelyn_SAS 2019-03-14T20:03:48Z Re: LOD Function in SAS https://communities.sas.com/t5/SAS-Visual-Analytics/LOD-Function-in-SAS/m-p/543349#M12082 Hi,<BR /><BR />Thx for reply!<BR />I use SAS viya for visual Analytics<BR />As I can do such calculation in other visual Analytics tool, so i would ask how to implement it in SAS way<BR /> Thu, 14 Mar 2019 23:02:50 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/LOD-Function-in-SAS/m-p/543349#M12082 emilyaaa 2019-03-14T23:02:50Z