https://communities.sas.com/t5/SAS-Procedures/Redusing-to-two-decimals-for-salary-variable/m-p/74843#M21721 It works fine....<BR /> <BR /> thanks cynthia... Mon, 23 Feb 2009 05:58:23 GMT venkatesh 2009-02-23T05:58:23Z https://communities.sas.com/t5/SAS-Procedures/Redusing-to-two-decimals-for-salary-variable/m-p/74841#M21719 Hi.,<BR /> <BR /> want to reduce the salary variable after two decimal points in DI studio<BR /> <BR /> for example salary---------2500.0025314<BR /> required salary----------2500.00<BR /> <BR /> it has to be in DI studio only....<BR /> Thanks a lot Fri, 20 Feb 2009 12:19:59 GMT https://communities.sas.com/t5/SAS-Procedures/Redusing-to-two-decimals-for-salary-variable/m-p/74841#M21719 venkatesh 2009-02-20T12:19:59Z https://communities.sas.com/t5/SAS-Procedures/Redusing-to-two-decimals-for-salary-variable/m-p/74842#M21720 Hi:<BR /> You either need to use the ROUND function when you create the salary variable (or in your table loading program code):<BR /> salary = round(xxx,.01);<BR /> <BR /> or<BR /> you can apply a format to reduce the DISPLAYED decimal places to 2 places. <BR /> format salary 10.2; <BR /> <BR /> The format method means that the number would still be stored with more than 2 decimal places. The users would never see more than 2 as long as the format was permanently assigned and they did not change it.<BR /> <BR /> cynthia Fri, 20 Feb 2009 14:37:08 GMT https://communities.sas.com/t5/SAS-Procedures/Redusing-to-two-decimals-for-salary-variable/m-p/74842#M21720 Cynthia_sas 2009-02-20T14:37:08Z https://communities.sas.com/t5/SAS-Procedures/Redusing-to-two-decimals-for-salary-variable/m-p/74843#M21721 It works fine....<BR /> <BR /> thanks cynthia... Mon, 23 Feb 2009 05:58:23 GMT https://communities.sas.com/t5/SAS-Procedures/Redusing-to-two-decimals-for-salary-variable/m-p/74843#M21721 venkatesh 2009-02-23T05:58:23Z