Hi, I have dataset that looks like: refper company placeholder_r0010 placeholder_r0020 placeholder_r0030 placeholder_r0040 201744 70912 . 71.889.742,2000000000 . 539.285,3600000000 26.431.317.719,6000000000 1.846.511.611,3300000000 201841 70912 . 85.787.103,2700000000 . 539.285,3600000000 26.066.828.054,7500000000 1.751.692.394,5900000000 201842 70912 . -43.904.340,3200000000 . 539.285,3600000000 26.937.620.831,9400000000 2.043.105.368,9100000000 201843 70912 . . . 537.775,2200000000 27.011.686.026,8700000000 1.215.625.799,2800000000 and another dataset which combines the placeholder column names with their actual names:   Goodwill R0010 Deferred acquisition costs R0020 Intangible assets R0030 Deferred tax assets R0040 How do I combine these two sets such that the column names in the first dataset changes to names given in the second data set? (such that: placeholder_r0010 == Goodwill, placeholder_r0020 == Deferred acquisition costs, ...)   ... View more

Hi,   I have two columns. One is a column of numerical variables identifying the category of the asset (first number is main category, second number is subcategory eg. 31 is 3 for equity and 1 for common equity) the other column consists of numerical variables describing the total amount invested in the asset. Example of dataset: Id    total value 31   10000 23   9930 37   2892 26   6833   Desired result: Category 2  Category 3 16763          12892   I need to sum every main category and present the data in a table. So far I have created subsets of the data using the data process as seen below:   data data (keep=asset rename=(asset=asset_category)); set original_dataset; if 71<=Assetnumber<=79 then; else delete;       I end up with 10 different data sets.   How do I sum + combine the data the smartest way?   Is there a more convienient way to handle the entire dataset?   regards, Thorius ... View more