https://communities.sas.com/t5/ODS-and-Base-Reporting/Is-it-possible-to-store-centralized-calcs/m-p/3648#M1558 Hi, Patrick,<BR /> In the BI platform you generally store this kind of calculation in an Information Map. However, in BASE SAS, you would accomplish this reusability of code or calculation with a SAS macro variable or a SAS macro program. In upcoming releases of SAS, you would be able to design your own functions.<BR /> <BR /> This however, is neither an ODS question or a reporting question -- but is more a SAS macro question. As such, your best bet for a complete response is SAS Tech Support.<BR /> <BR /> cynthia Thu, 28 Jun 2007 14:11:15 GMT Cynthia_sas 2007-06-28T14:11:15Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Is-it-possible-to-store-centralized-calcs/m-p/3647#M1557 Hello. In Crystal Reports, I have the ability to store commonly used calculation in a central repository. So for Example:<BR /> MyCalc = (a + b)/b<BR /> <BR /> In my report I put this field in one of my columns<BR /> Field_1 Field_2 MyCalc(Field_1, Field_Z) ........<BR /> <BR /> By doing this, I'm assured all my calcs throughout different reports are the same. If I need to change the calc, I change it in the repository and all the reports that use this calc are taken care of.<BR /> <BR /> Can I do the same thing for my Proc Reports maybe storing the calculations in Metadata some where?<BR /> Thank you Thu, 28 Jun 2007 14:04:30 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Is-it-possible-to-store-centralized-calcs/m-p/3647#M1557 deleted_user 2007-06-28T14:04:30Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Is-it-possible-to-store-centralized-calcs/m-p/3648#M1558 Hi, Patrick,<BR /> In the BI platform you generally store this kind of calculation in an Information Map. However, in BASE SAS, you would accomplish this reusability of code or calculation with a SAS macro variable or a SAS macro program. In upcoming releases of SAS, you would be able to design your own functions.<BR /> <BR /> This however, is neither an ODS question or a reporting question -- but is more a SAS macro question. As such, your best bet for a complete response is SAS Tech Support.<BR /> <BR /> cynthia Thu, 28 Jun 2007 14:11:15 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Is-it-possible-to-store-centralized-calcs/m-p/3648#M1558 Cynthia_sas 2007-06-28T14:11:15Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Is-it-possible-to-store-centralized-calcs/m-p/3649#M1559 Thanks Cynthia. Thu, 28 Jun 2007 17:49:09 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Is-it-possible-to-store-centralized-calcs/m-p/3649#M1559 deleted_user 2007-06-28T17:49:09Z