IDEAS home Printed from https://ideas.repec.org/p/pra/mprapa/77650.html
   My bibliography  Save this paper

SAS® Macros for Constraining Arrays of Numbers

Author

Listed:
  • Coleman, Charles

Abstract

Many applications require constraining arrays of numbers to controls in one or two dimensions. Example applications include survey estimates, disclosure avoidance, input-output tables, and population and other estimates and projections. If the results are allowed to take on any nonnegative values, raking (a.k.a. scaling) solves the problem in one dimension and two-way iterative raking solves it in two dimensions. Each of these raking macros has an option for the user to output a dataset containing the rakes. The problem is more complicated in one dimension if the data can be of any sign, the so-called “plus-minus” problem, as simple raking may produce unacceptable results. This problem is addressed by generalized raking, which preserves the structure of the data at the cost of a nonunique solution. Often, results are required to be rounded so as to preserve the original totals. The Cox-Ernst algorithm accomplishes an optimal controlled rounding in two dimensions. In one dimension, the Greatest Mantissa algorithm is a simplified version of the Cox-Ernst algorithm. Each macro contains error control code. The macro variable &errorcode is made available to the programmer to enable error trapping.

Suggested Citation

  • Coleman, Charles, 2015. "SAS® Macros for Constraining Arrays of Numbers," MPRA Paper 77650, University Library of Munich, Germany.
    • Handle: RePEc:pra:mprapa:77650
    as

    Download full text from publisher

    File URL: https://mpra.ub.uni-muenchen.de/77650/1/PO-131.pdf
    File Function: original version
    Download Restriction: no
    File URL: https://mpra.ub.uni-muenchen.de/77843/1/MPRA_paper_77843.pdf
    File Function: revised version
    Download Restriction: no
    ---><---

    References listed on IDEAS

    as
    1. Manfred Lenzen & Blanca Gallego & Richard Wood, 2009. "Matrix Balancing Under Conflicting Information," Economic Systems Research, Taylor & Francis Journals, vol. 21(1), pages 23-44.
    Full references (including those not matched with items on IDEAS)

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. V. Kumar & Alok R. Saboo & Amit Agarwal & Binay Kumar, 2020. "Generating Competitive Intelligence with Limited Information: A Case of the Multimedia Industry," Production and Operations Management, Production and Operations Management Society, vol. 29(1), pages 192-213, January.
    2. Ferreira, João-Pedro & Marques, João Lourenço & Moreno Pires, Sara & Iha, Katsunori & Galli, Alessandro, 2023. "Supporting national-level policies for sustainable consumption in Portugal: A socio-economic Ecological Footprint analysis," Ecological Economics, Elsevier, vol. 205(C).
    3. Umed Temursho & Manuel Alejandro Cardenete & Krzysztof Wojtowicz & Luis Rey & Matthias Weitzel & Toon Vandyck & Bert Saveyn, 2020. "Projecting input-output tables for model baselines," JRC Research Reports JRC120513, Joint Research Centre.
    4. Han-Shen Chen, 2015. "Using Water Footprints for Examining the Sustainable Development of Science Parks," Sustainability, MDPI, vol. 7(5), pages 1-21, May.
    5. Coleman, Charles, 2016. "A SAS® Macro for the Generalized RAS Algorithm," MPRA Paper 77651, University Library of Munich, Germany, revised 19 Mar 2017.
    6. Jakub Boratyński, 2016. "A Bayesian Approach to Matrix Balancing: Transformation of Industry-Level Data under NACE Revision," Central European Journal of Economic Modelling and Econometrics, Central European Journal of Economic Modelling and Econometrics, vol. 8(4), pages 219-239, December.
    7. Hiramatsu, Tomoru & Inoue, Hiroki & Kato, Yasuhiko, 2016. "Estimation of interregional input–output table using hybrid algorithm of the RAS method and real-coded genetic algorithm," Transportation Research Part E: Logistics and Transportation Review, Elsevier, vol. 95(C), pages 385-402.
    8. Hanspeter Wieland & Manfred Lenzen & Arne Geschke & Jacob Fry & Dominik Wiedenhofer & Nina Eisenmenger & Johannes Schenk & Stefan Giljum, 2022. "The PIOLab: Building global physical input–output tables in a virtual laboratory," Journal of Industrial Ecology, Yale University, vol. 26(3), pages 683-703, June.
    9. Tzu-Yu Lin & Sheng-Hsiung Chiu, 2018. "Sustainable Performance of Low-Carbon Energy Infrastructure Investment on Regional Development: Evidence from China," Sustainability, MDPI, vol. 10(12), pages 1-21, December.
    10. Dietzenbacher, Erik & Pei, Jiansuo & Yang, Cuihong, 2012. "Trade, production fragmentation, and China's carbon dioxide emissions," Journal of Environmental Economics and Management, Elsevier, vol. 64(1), pages 88-101.
    11. L. Oosterhout & E. Koks & P. Beukering & S. Schep & T. Tiggeloven & S. Manen & M. Knaap & C. Duinmeijer & S. L. Buijs, 2023. "An Integrated Assessment of Climate Change Impacts and Implications on Bonaire," Economics of Disasters and Climate Change, Springer, vol. 7(2), pages 147-178, July.
    12. Barbara Hutniczak, 2022. "Efficient updating of regional supply and use tables with the national-level statistics," Journal of Economic Structures, Springer;Pan-Pacific Association of Input-Output Studies (PAPAIOS), vol. 11(1), pages 1-11, December.
    13. Edward F. Baranov & Igor A. Kim & Dmitri I. Piontkovski & Elena A. Staritsyna, 2015. "Constructing Retrospective Time Series of Russian Input-Output Accounts Based on the Nace/Cpa Classifications," HSE Working papers WP BRP 108/EC/2015, National Research University Higher School of Economics.
    14. Thomas Wiedmann & John Barrett, 2010. "A Review of the Ecological Footprint Indicator—Perceptions and Methods," Sustainability, MDPI, vol. 2(6), pages 1-49, June.
    15. Chia‐Hao Liu & Manfred Lenzen & Joy Murray, 2012. "A disaggregated emissions inventory for Taiwan with uses in hybrid input‐output life cycle analysis (IO‐LCA)," Natural Resources Forum, Blackwell Publishing, vol. 36(2), pages 123-141, May.
    16. Wiedmann, Thomas, 2009. "A review of recent multi-region input-output models used for consumption-based emission and resource accounting," Ecological Economics, Elsevier, vol. 69(2), pages 211-222, December.
    17. Andrea Bacilieri & Pablo Austudillo-Estevez, 2023. "Reconstructing firm-level input-output networks from partial information," Papers 2304.00081, arXiv.org.
    18. Chen, Shaoqing & Zhu, Feiyao, 2019. "Unveiling key drivers of urban embodied and controlled carbon footprints," Applied Energy, Elsevier, vol. 235(C), pages 835-845.
    19. Britz, Wolfgang, 2020. "Comparing three penalty functions - Cross-Entropy approach, Quadratic and Linear Loss – in SAM balancing and splitting applications," Conference papers 333145, Purdue University, Center for Global Trade Analysis, Global Trade Analysis Project.
    20. Stefan Giljum & Hanspeter Wieland & Stephan Lutter & Martin Bruckner & Richard Wood & Arnold Tukker & Konstantin Stadler, 2016. "Identifying priority areas for European resource policies: a MRIO-based material footprint assessment," Journal of Economic Structures, Springer;Pan-Pacific Association of Input-Output Studies (PAPAIOS), vol. 5(1), pages 1-24, December.

    More about this item

    Keywords

    RAS. Range-RAS; RRAS; IPF; iterative proportionate fitting; raking; controlled rounding; Cox-Ernst algorithm;
    All these keywords.

    JEL classification:

    • C02 - Mathematical and Quantitative Methods - - General - - - Mathematical Economics
    • C67 - Mathematical and Quantitative Methods - - Mathematical Methods; Programming Models; Mathematical and Simulation Modeling - - - Input-Output Models
    • D57 - Microeconomics - - General Equilibrium and Disequilibrium - - - Input-Output Tables and Analysis
    • J10 - Labor and Demographic Economics - - Demographic Economics - - - General
    • R15 - Urban, Rural, Regional, Real Estate, and Transportation Economics - - General Regional Economics - - - Econometric and Input-Output Models; Other Methods

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:pra:mprapa:77650. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Joachim Winter (email available below). General contact details of provider: https://edirc.repec.org/data/vfmunde.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.