Hello all,    Instead of writing multiple lines on DATA population2 step, I am trying to use arrays. However, I receive message; "Missing numeric suffix on a numbered variable list"   Could you please help? Thank you in advance!   DATA population2; SET population; by state_2; if first.state_2 then cum_1990 = _1990; else cum_1990 + _1990; if last.state_2 then output; RUN; DATA population3; SET population; by State_2; array year_array {30} _1990 - _2019; array cum_array {30} _1990cum - _2019cum; do i = 1 to 30; if first.state_2 then cum_array {i} = year_array {i} ; else cum_array {i} + year_array{i}; if last.state_2 then output; end; RUN; ... View more

Dear all,   I have a 2020 product list, with detailed information. I vertically joined a 2020 list with older lists (2019,2018 etc.), so I have all the products ever produced, not just 2020 current products.   My goal is to get one observation for one ID, with all information.    2020 list file:   ID       detailed info1(have more)  _2020 (indicator variable to show the product is in 2020 list)  A101   Germany                               1 B101   China                                    1                older file : ex)2019 ID        2019 A101    1 C101    1   Combined list , sorted by ID (I have it to this step)   ID        detailed 1      2020 2019 2018  A101   Germany          1 A101                                     1 A101                                              1 B101    China             1 B101                                    1 C101                                    1 C101                                              1   PROBLEM:  I want to make it look like; (tried retain but failed)  ID        detailed 1 -10  2020 2019 2018  A101   Germany          1 A101   Germany          1        1 A101   Germany          1        1        1   Then For final dataset:  then using (last.ID ?) so I have one ID obs with most information    A101   Germany          1        1        1 B101   China                1       1 C101                                      1        1     data product_sort; set product; by ID; if first.ID then do; if detailed_info_1 ne . then temp_1 = detailed_info_1; else if detailed_info_1 = . then detailed_info_1 = temp1; retain temp1; end; /*keep only last symbol */ run;   Thank you so much for your help in advance!          ... View more