Sorry - am fairly new when it comes to working with SAS. Essentially I want the frequency of 0 to 5 year olds to equal 55249.5, this would be derived from adding the number of 0 to 4 year olds (45815) with half of the number of 5 to 6 year olds (18869/2). So far, this is a code that is getting me part way there. data children; set folder.census2006; if AGEGRP = 1 then oldcount04 = 1; if AGEGRP ^= 1 then oldcount04 = 0; if AGEGRP = 2 then oldcount56 = 1; if AGEGRP ^= 2 then oldcount56 = 0; run; data children; set children; newcount05= oldcount04+round(oldcount56/2); run; PROC FREQ DATA=CHILDREN; TABLES AGEGRP oldcount04 oldcount56 newcount05; RUN; However- seems that the 'oldcount56' variable is not dividing by 2 successfully. As a result, I'm seeing 0 to 4 year olds just adding together with the entire 5 to 6 year old category.
... View more