SAS Support Communities

Hello, I am trying to calculate the difference between the data observed in 2023 and 2024 by month.  I have a total of 84 observations and need to calculate the difference between all 12 months. Below is a sample of how the data is formatted.    data Have; input id 23Jan 23Feb 23Mar 24Jan 24Feb 24Mar; datalines; 1 0.54 0.54 0.52 0.62 0.61 0.60 2 0.48 0.45 0.48 0.71 0.68 0.67 3 0.59 0.61 0.59 0.57 0.54 0.58 4 0.61 0.62 0.59 0.62 0.61 0.54 ;  I want a dataset that contains the difference for each month for all 84 observations. Data Want; ID JanDiff FebDiff MarDiff 1 2 3 4 I know I can write out all 12 calculations but is their a more efficient coding strategy to calculate the differences? Thanks in advance ... View more

I have a long dataset of over a million records of people with their race category. Some people have more than one race assigned to their person id. What I want to do is select the best race for each person id. In the dataset some people will have an observation that says unknown or other and also actual race category, I want to get rid of the unknown/other observation and keep the more descriptive race category. Some people will also have different races listed. For example person A will have one observation that says black and one observation that says white. For those I want to be able to assign that person's race to be multiracial.  I was trying to do this using a Do Until statement but it is not outputting what I want.   proc sort data=race_check3; ; by child_id; run; Data race_check4; Do until (last.child_id); set race_check3; by child_id; if (race_eth NE 'Unknown') then race_eth2=race_eth; end; run;   Data have: Child_id Race_eth 16849918029 NH Asian/Native Hawaiian/Other Pacific Islands 16849918029 NH White 16850191831 NH White 16850191831 Unknown 16850404097 NH Asian/Native Hawaiian/Other Pacific Islands 16850404097 Unknown 16850502704 NH Asian/Native Hawaiian/Other Pacific Islands 16850502704 NH White 16850783900 Other 16850783900 Unknown 16850922663 NH Asian/Native Hawaiian/Other Pacific Islands 16850922663 Unknown 16851203403 NH Asian/Native Hawaiian/Other Pacific Islands 16851203403 NH White 16851234942 NH White 16851234942 Unknown   Data Want   Child_id Race_eth 16849918029 Multi Racial 16850191831 NH White 16850404097 NH Asian/Native Hawaiian/Other Pacific Islands 16850502704 Multi Racial 16850783900 Other 16850922663 NH Asian/Native Hawaiian/Other Pacific Islands 16851203403 Multi Racial 16851234942 NH White   ... View more