Hi, I sorted in the following table the type of data I have: - yellow is alphanumeric - blue is numeric - from Marktregion_BT until Filbez_bt, it's a cascade of entities, each one being a substructure of the previous one - Stufe is a generic variable to select the accurate level of data, and also give the last level : AG (being the summary of all Marktregion_BT). It means that when 'MBR' is selected, all FILBEZ_BT values are empty, as the FIL are the level below MBR. When NL is selected, the MBRBEZ_BT and FILBEZ_BT values are empty etc. - the yellow columns give the 'type' of data I find, not the dependencies between the columns. I need to: - calculate the sum of each variable VAR1, VAR2... for each level Filbez_bt till Marktregion_bt AND each STUFE, for each year ('JAHR), and each month ('MONAT'), and with additional selections like: all Plattform values / Plattform = O / Plattform = F AND AMPEL = OFFEN or GRUEN or AMPEL = all values. Each new variable (= result variable) has to be named in a customized way - calculate the evolutions 2019/2018 for each result variable. My original program works but is very heavy and obviously can be optimized, as I'm new to SAS I'm learning by doing, quite slowly. I'd appreciate any suggestion to solve the many problems mentioned above. Thanks a lot, PY
... View more