Hello,   I am looking to change values of observations that satisfy a specific condition to the values "above". My data looks somewhat like this: var1 var2 1 A 1 A 1 A 0 X 1 A 1 A 2 B 2 B 0 X 2 B 2 B 3 C 3 C 3 C 0 X   In this example I would like to change the value of var2 to the value of the observation above, only if the value of var1 is equal to 0. In the example above, the result would be: var1 var2 1 A 1 A 1 A 0 A 1 A 1 A 2 B 2 B 0 B 2 B 2 B 3 C 3 C 3 C 0 C   I hope someone can help me. Thanks alot! ... View more

Hello,   I have a data set for apartments with these variables: Building_id: ID for the building that the apartment is located in. Apartment_id: ID for the apartment itself.   I would like to generate a variable, Group_id, that groups the apartments together in groups. These groups have to include a minimum of 12 apartments and these apartments need the same building_id.   So, if there are 23 apartments with the same building_id they would simply be in one group, because there are not enough apartments for 2 groups of 12. If there are 24 apartments with the same building_id, they would be in two groups of 12. If there are 25 apartments with the same building_id, they would be in two groups of 12 and 13.   Another example: if there are 100 apartments in the same building (with the same building_id), I want the first 12 to be grouped with one Group_id, 13-24 to be grouped with another Group_id, 25-36 with a third Group_id,..., and then the last apartments from 84-100 to be grouped together with the same Group_id. The last group includes 16 apartments (larger than 12), but if we grouped 84-96 together, then the last 4 apartments would be too few to be in a group, because of the 12 minimum rule.   My data set include a lot of apartments with a lot of different building-id's, so I am hoping for a code that does this grouping automatically.   I hope this makes sense - please ask away if it doesn't. Hoping someone can help :-). ... View more

Hello fellow SAS users,   I have a data set that looks somewhat like this:                     Variable 1          Variable 2          Variable 3           Variable 4              Variable 5 Person 1          a                          a                        c                         a                              b Person 2          a                          b                        a                         b                              c Person 3          b                          c                        b                         a                              a   What I want is to make SAS find the most common variable value for each person. So in this case I would need a table like this:                        a                       b                      c Person 1         3                      1                      1 Person 2         2                      2                      1 Person 3         2                      2                      1   Can somebody help me in the right direction? ... View more

Hello fellow SAS users,   I have a question that might be pretty simply, but I can't find out how to do it. I have a lot of data sets, one for every year. Let's say they are called: data1990, data1991, data1992,...,data2019, data2020   I want to perform the same data step on each of these without writing out 30 data steps. I am thinking something like:   %macro mymacro(year);   data new_data_&year.; set data_&year.; SomedatastepthatIneed; run;   %do i=1990 %to 2020 %by 1; %mend;   %mymacro(i);   But this does not work. Can someone help me perform a macro that works? ... View more