I would like to find out if array (a1-a8) contains 1 or 0 using the date1-date8 array.  The check1 to check2 provides the dates that I need to look at.  For id=1, I need to look at if the dates are within check1<=dates{i}<=check2.  Therefore, date1 through date5 are within check1 and check2.  I need to check if a1 through a5 contains any 1.  If yes, then HAS=1.  If a1 through a5 are all zeros, then HAS=0.  If a1 through a5 are some zeros and some missing, then HAS is missing.    data z; input id a1-a8 date1-date8 check1 check2; datalines; 1 0 0 1 1 . . . . 15 15 16 16 17 18 18 20 11 17 2 . . 1 1 0 1 1 1 14 16 17 18 19 21 22 24 8 18 3 . . . 1 1 1 1 1 14 15 17 17 18 19 21 22 16 23 4 0 0 0 0 0 1 1 1 13 15 18 18 21 21 23 23 10 18 ; data want; input id a1-a8 b1-b8 check1 check2 HAS; datalines; 1 0 0 1 1 . . . . 15 15 16 16 17 18 18 20 11 17 1 2 . . 1 1 0 1 1 1 14 16 17 18 19 21 22 24 8 18 1 3 . . . 1 1 1 1 1 14 15 17 17 18 19 21 22 16 23 1 4 0 0 0 0 0 1 1 1 13 15 18 18 21 21 23 23 10 18 0 5 0 0 . . 1 1 1 1 10 11 11 13 13 17 17 18 9 11 . ;   I found jth dimension where dates is within check1 and check2.  I need to check if a1 through a jth contains any 0 or if a1 through a jth are all equal to 0.   data z1; set z; array a a1-a8; array date date1-date8; do i=1 to dim(a); if check1<=date{i}<=check2 then do;   j=i; end; end; run;   ... View more

I would like to check if the array "a" contains any 1s.  The check1, check2, and "b" array are used to determine the dimension number I need to check in array "a."   For id=1, check1=11 and check2=17.  I found that 11<=b{i}<=17 is at i=2 (b2=15).  Hence, I need to check if a1 through a2 contains any 1s.     data z; input id a1-a4 b1-b4 check1 check2; datalines;   1 1 . . 1 10 15 18 20 11 17 2 . . 1 1 17 18 19 21 16 18 3 . . . 1 18 19 21 22 16 23 ; data want; input id a1-a4 b1-b4 check1 check2 HAS; datalines;   1 1 . . 1 10 15 18 20 11 17 1 2 . . 1 1 17 18 19 21 16 18 0 3 . . . 1 18 19 21 22 23 23 1 ; data z1; set z; array a a1-a4; array b b1-b4; do i=1 to dim(a); if check1<=b{i}<=check2 then do;   j=i; end; end; run;   ... View more

I have longitudinal data of number of hospital visits for individuals from when they were ages 15 through 30.  I have counted the total number of visits at different age ranges (15-20, 21-25, 26-30, and 15-30).  Each individuals have different weights assigned at each age.  I would like to calculate the weighted average of visits at different age ranges.   Does it make sense to take the weights at age 30 (weight30) to take the weighted averages?  Or should I use weight20 to calculate the weighted average number visits 15-20 (visits1520), weight25 for visits2125, weight30 for visits2630, and weight30 for visits1530.      ... View more

I have multi dimensional array of numeric numbers.  I would like to create separate multi dimensional array that shows the first observed unique numbers.   data have1; input a1_1-a1_4 b1_1-b1_4 c1_1-c1_4; datalines; 2000 2001 2002 . 2001 2004 . . 2002 2004 2005 20006 2000 2002 2003 2004 2003 2004 . . 2002 2005 2006 . ; data want1; input fa1_1-fa1_4 fb1_1-fb1_4 fc1_1-fc1_4; datalines; 2000 2001 2002 . . 20004 . . . . 2005 2006 2000 2002 2003 2004 . . . . . 2005 2006 . ; ... View more

I have a data set which has account numbers and balances in 2018 and 2020.  I found the account numbers in 2019 which has some accounts from 2018 and 2020.  I would like to create an array of balances for 2019, where if the 2019 account number matches with either 2018 or 2020, then pick the balance 2018. (Data Want shows what I would like!) For example, the first observation has account number 101 in 2019.  This account was present in both 2018 and 2020.  Therefore, I would like the 2019 balance (bal2019_1) to equal (bal2018_1).     data have; input acct2018_1 acct2018_2 acct2018_3 acct2018_4 acct2018_5 bal2018_1 bal2018_2 bal2018_3 bal2018_4 bal2018_5   acct2020_1 acct2020_2 acct2020_3 acct2020_4 acct2020_5 bal2020_1 bal2020_2 bal2020_3 bal2020_4 bal2020_5; datalines;   101 407 103 . . 40 60 80 . . 101 604 505 . . 10 19 20 . . 303 203 . . . 70 80 . . . 507 205 406 907 . 14 19 89 99 . 901 602 801 . . 10 14 24 . . 404 901 505 802 . 20 90 99 87 . 301 501 904 905 . 84 90 20 95 . 808 . . . . 34 . . . . . ; run; data account_balance2019; input acct2019_1 acct2019_2 acct2019_3 acct2019_4 acct2019_5 ; datalines;   101 . . . . 907 203 . . . 801 505 901 . . 808 301 . . . ; run;   data want; input acct2018_1 acct2018_2 acct2018_3 acct2018_4 acct2018_5 bal2018_1 bal2018_2 bal2018_3 bal2018_4 bal2018_5   acct2019_1 acct2019_2 acct2019_3 acct2019_4 acct2019_5 bal2019_1 bal2019_2 bal2019_3 bal2019_4 bal2019_5 acct2020_1 acct2020_2 acct2020_3 acct2020_4 acct2020_5 bal2020_1 bal2020_2 bal2020_3 bal2020_4 bal2020_5; datalines;   101 407 103 . . 40 60 80 . . 101 . . . . 40 . . . . . 101 604 505 . . 10 19 20 . . 303 203 . . . 70 80 . . . 907 203 . . . 99 80 . . . 507 205 406 907 . 14 19 89 99 . 901 602 801 . . 10 14 24 . . 801 505 901 . . 24 99 10 . . 404 901 505 802 . 20 90 99 87 . 301 501 904 905 . 84 90 20 95 . 808 301 . . . 34 84 . . . 808 . . . . 34 . . . . . ; run;   ... View more

I'm trying to create a new array called (newtopic with 5 elements or variables) where it equals non-missing topic1-topic10.     data have; input begin end topic1 - topic10; datalines; 3 8 . . 1 0 1 0 1 . . . 2 6 . 0 0 1 1 1 . . . . 4 8 . . . 1 1 0 0 0 . . 1 5 1 1 1 1 0 . . . . . ; data want; input begin end newtopic1-newtopic5; datalines; 3 8 1 0 1 0 1 2 7 0 0 1 1 1 4 9 1 1 0 0 0 1 5 1 1 1 1 0 ; ... View more

I would like to check where a number is located in a multi-dimensional array.  Then, I would like to take the minimum of the entire column for that particular row.    For example, I have the following data sets. This is a 3-dminesional with 3 rows and 5 columns.  array temp{3,5}  a1_1-a1_5  a2_1-a2_5 a3_1-a3_5;   In the first observation, Check1= 111 is located at temp{2,3}.  For non-missing values, I would like to take the minimum.  So, min(a2_1-a2_5)=1. In the second observation, Check1=222 is located at temp{2,4} and min(a2_1-a2_5)=1.  Check2=223 is located at temp{3,2} and min(a3_1-a3_5)=3.   data k; input check1 check2 a1_1 -a1_5 a2_1-a2_5 a3_1-a3_5; datalines; 111 . 12 122 133 . . 1 11 111 13 . 777 2 . . . 222 223 5 555 232 . . 1 111 123 222 224 11 223 3 . . ; run;   Thank you ... View more