How are you planning to display your table? PROC REPORT/TABULATE/MEANS can do this automatically.  And is it created from a summary procedure initially? If so, you can likely @epi_user wrote: I have a dataset that has many age categories by race and I am interested in combining all age categories in each race in each county to create a "total" variable for each county .    thank you!    I'd like the final data to look like this:   County Race Age _2020 x Asi 15-19 65 x Asi 20-24 34 x Asi 25-29 45 x Asi Total 144 y Asi 15-19 16 y Asi 20-24 9 y Asi 25-29 13 y Asi Total 38   the original data looks like this:  County Race Age _2020 x Asi 15-19 65 x Asi 20-24 34 x Asi 25-29 45 y Asi 15-19 16 y Asi 20-24 9 y Asi 25-29 13 add in the total calculation to that step.     ... View more

Double PROC TRANSPOSE.   data have; input subject ModA1_na ModA1_no ModA1_yes ModA2_na ModA2_no ModA2_yes; datalines; 1 1 0 0 0 0 1 2 0 1 0 1 0 0 3 0 0 1 1 0 0 4 0 1 0 0 0 1 ; run; proc transpose data=have out=temp(where=(col1=1)); by subject; run; data temp1; set temp; name=scan(_name_,1,'_'); value=scan(_name_,-1,'_'); run; proc transpose data=temp1 out=want; by subject; id name; var value; run; ... View more