@FreelanceReinhthanks for the reply, that was a great explanation, very helpful. I fixed everything you mentioned except the length statement bc I am not seeing any truncation. However something still isn't working correctly. Now it is printing out all 144 observations, but the absenses are not correct, it seems to be assigning the last value in the datalines to all the variables? not sure if i explained that correctly. here is what i updated options nonumber nodate; data example33; input x1 - x6; if _n_ in (1,2,3,4,5,6) then district = 'OKEECHOBEE'; else IF _N_ IN (7,8,9,10,11,12) THEN DISTRICT= 'SEMINOLE'; else IF _N_ IN (13,14,15,16,17,18) THEN DISTRICT= 'VOLUSIA'; ELSE DISTRICT= 'WALTON'; if _n_ in (1,2,7,8,13,14,19,20) then race= 'B'; else if _n_ in (3,4,9,10,15,16,21,22) then race= 'W'; else race= 'O'; if _n_ in (1,3,5,7,9,11,13,15,17,19,21,23) then gender= 'M'; else gender= 'F'; array pr2(6) x1-x6; do i= 1 to 6; if i < 4 then learntype= 'Passive'; else learntype= 'Active'; if i in (1,4) then level= 'Elementary'; else if i in (2,5) then level= 'Middle'; else level= 'High'; absenses= pr2(6); output; end; drop I;
... View more