Hello! I have data that looks like this    id     HCCategory1 .... HCCategory10     HCCDescrip1.....HCCDescrip10 1               .                           18                          .                    Diabetes 2               57                         .                  Schizophrenia             .     and so on. I want instances like ID 1 to move the categories and their associated descriptions when there is a missing value  so the data looks like this:    id     HCCategory1 .... HCCategory10     HCCDescrip1.....HCCDescrip10 1              18                          .                    Diabetes                    . 2              57                          .                  Schizophrenia             .     Each category has 3 associated categories I need to move along with it- the description, the diagnosis code, the diagnosis description.    Here is what I've written:    data heirarchy2; set heirarchy1; Array HCC2 (60) HCCategory1-HCCategory60; Array HCCD1 (60) HCCDescrip1-HCCDescrip60; array DXa (60) dx1- dx60; array dxd1 (60) DXDescrip1-DXDescrip60; do i=1 to 59 ; if missing (HCC2[i]) then do j=max(j,i)+1 to dim(HCC2); if not missing (HCC2[j]) then do; HCC2[i]=HCC2[j]; call missing (HCC2[j]); leave; do k=1 to 59 ; if missing (HCCD1[k]) then do l=max(l,k)+1 to dim(HCCD1); if not missing (HCCD1[l]) then do; HCCD1[k]=HCCD1[l]; call missing (HCCD1[l]); leave; do m=1 to 59 ; if missing (DXa[m]) then do n=max(n,m)+1 to dim(DXa); if not missing (DXa[n]) then do; DXa[m]=DXa[n]; call missing (DXa[n]); leave; do o=1 to 59 ; if missing (dxd1[o]) then do p=max(p,o)+1 to dim(dxd1); if not missing (dxd1[p]) then do; dxd1[o]=dxd1[p]; call missing (dxd1[p]); leave; end; end; end; end; end; end; end; end; end; end; end; end; drop i j k l m n o p; run; What happens is the first variable,  HCCategories, is properly rolled left, but the 3 associated categories are not.    Any ideas what I should change?  ... View more

Hello all!  I have a list of coded conditions for patients , organized as such:   id dob    HCCategory 1 HCCategory2.. HCCategory60 1 1.6.92        1                       18                      116 2 2.1.88        3                       .                           .   3 3.8.95        8                       9                        120 3 1.5.00        11                     .                          90   I need to conditionally delete 'duplicates' wherein there is two codes for the came condition, but one is more severe. This is the case for ID 3, bolded above. 8 represents a more severe form of cancer than the cancer represented by 9.  I would like an array (or other method) to read down the HCCategory columns, and when it sees an 8, delete representatives  of less severe cancer (numbers 9, 10, 11 and 12) for the following columns, so data looks like this:    id dob    HCCategory 1 HCCategory2..... HCCategory60 1 1.6.92        1                       18                      116 2 2.1.88        3                       .                           .   3 3.8.95        8                       .                        120 3 1.5.00        11                     .                          90   Here is how I'm trying to accomplish this:   data test; set HCCListb; array hcc[60] HCCategory1-HCCategory60; do i= 1 to 60; if hcc[i]= '8' and hcc[i+1] in ('9', '10', '11', '12') then hcc[i+1]= . ; end; run;   When I run this, I get the following:  ERROR: Array subscript out of range at line 30 column 4.   Any ideas as to what I'm doing wrong?  ... View more