I am trying to create 3 groups with the code down below but SAS is only including numbers under the first group (<1). Why is this happening? DATA WORK.IMPORT1; SET WORK.IMPORT; /* Calculate the group category based on incidence rate ranges */ IF ARI_Guest_Incidence<1 THEN ARI_Guest_Group_Category = "<1"; IF 1<=ARI_Guest_Incidence<=1.99 THEN ARI_Guest_Group_Category = "1-1.99"; IF ARI_Guest_Incidence>=2 THEN ARI_Guest_Group_Category = "2 and above"; IF ARI_Crew_Incidence<1 THEN ARI_Crew_Group_Category = "<1"; IF 1<=ARI_Crew_Incidence<=1.99 THEN ARI_Crew_Group_Category = "1-1.99"; IF ARI_Crew_Incidence>=2 THEN ARI_Crew_Group_Category = "2 and above"; IF CLI_Guest_Incidence<1 THEN CLI_Guest_Group_Category = "<1"; IF 1<=CLI_Guest_Incidence<=1.99 THEN CLI_Guest_Group_Category = "1-1.99"; IF CLI_Guest_Incidence>=2 THEN CLI_Guest_Group_Category = "2 and above"; IF CLI_Crew_Incidence<1 THEN CLI_Crew_Group_Category = "<1"; IF 1<=CLI_Crew_Incidence<=1.99 THEN CLI_Crew_Group_Category = "1-1.99"; IF CLI_Crew_Incidence>=2 THEN CLI_Crew_Group_Category = "2 and above"; IF ILI_Guest_Incidence<1 THEN ILI_Guest_Group_Category = "<1"; IF 1<=ILI_Guest_Incidence<=1.99 THEN ILI_Guest_Group_Category = "1-1.99"; IF ILI_Guest_Incidence>=2 THEN ILI_Guest_Group_Category = "2 and above"; IF ILI_Crew_Incidence<1 THEN ILI_Crew_Group_Category = "<1"; IF 1<=ILI_Crew_Incidence<=1.99 THEN ILI_Crew_Group_Category = "1-1.99"; IF ILI_Crew_Incidence>=2 THEN ILI_Crew_Group_Category = "2 and above"; RUN; ... View more