Hi,   I am using proc sgscatter  with the compare statement to get three paneled scatter plots with the Y same axis, by group, and with fitted regression line:   proc sgscatter data=mydata datacontrastcolors=(blue red) datasymbols=(Square CircleFilled); compare y=var1  x = (var2 var3 var4) / group=var5 reg ; run;   My questions: 1) When I run this code, all symbols are Squares, there are no filled circles. what should I do to customize symbols?  2) How do I customize axes?     2.1) Get one single label for an X axis for all three panels.     2.2) Change values on one axis (something like values=(1 to 5 by 1))  and    2.3)Fully replace values on the other axis (something like values = ("0" "1" "2")) - something I could easily do in proc gplot, but really struggle with in ods graphics.    Any help would be greatly appreciated!   Thank you.         ... View more

Hi SAS users,   Could you please help me simplify this code? I need to create a vector of 21 variables that take value of 1 if a subject dropped out of the study, and 0 otherwise. I currently use the code below, but it is silly and inefficient. The repetitive pattern suggests that I can use a loop.    data want;    set have;       cens_1 = 0;       if min(of cd4_2-cd4_21) < 0 then cens_2 = 1; /*If all values of cd4 from visit 2 to 21 are missing, thencens_2 takes a value of 1*/       else cens_2 = 0;       if min(of cd4_3-cd4_21) < 0 then cens_3 = 1;       else cens_3 = 0;       if min(of cd4_4-cd4_21) < 0 then cens_4 = 1;       else cens_4 = 0;       if min(of cd4_5-cd4_21) < 0 then cens_5 = 1;       else cens_5 = 0; etc... run;   I tried a do loop:   data want;    set have;    array cd4(21) cd4_1-cd4_21;    arrray cens(21) cens_1-cens_21;    do i = 1 to 21;    if min(of cd4(i) - cd4_21) < 0  then cens(i) = 1;    else cens(i) = 0; end; run;   The problem is in the expression (of cd4(i) - cd4_21). SAS says: ERROR: Missing numeric suffix on a numbered variable list (NAME-cd4_21).   I would appreciate any help!   Thanks!     ... View more

Hi SAS Users,   I have been trying to resolve this problem, but keep failing, therefore I would greatly appreciate any help.    The data are binomial (whether a  participant has a condition (1) or not(0)). There are 20 repeated measurements corresponding to 20 visits:   cond1 cond2 .... cond20 0   0   ...   0 0   1 ...     0 1   0 .... 0 0    0  ... 1    etc.   I need to create 20 variables based on cond1-cond20, so that if a person had a condition at visit 1 all visits after it would be marked as 1; if condition was present at visit 2, all visits after the second would be marked as 1, etc.    cond_new1 cond_new2 cond_new 3 .... cond_new20 0   0  0 ... 0 0   1  1... 1 1  1  1...  1 0  0  0 ... 1   My current code is:    data interim;    set old;    array old_cond(20) cond1 - cond20;    array new_cond(20) new_cond1 - new_cond20;     do i = 1 to 20;     new_cond(i) = old_cond(i); end; drop i; run;   data want; set have; array old_cond(19) cond1 - cond19; array new_cond(20) new_cond1 - new_cond20; do i = 1 to 19; do j = 1 to 19; if old_cond(i) = 1 then new_aids(i+j) = 1; end; end; run;   And the error message says that the array subscript is out of range.  I cannot find in any SAS resources how to update an indexing variable so that it moved from say visit 2 to visit 20 and changed the value from 0 to 1 until it reaches the last visit. I would be really grateful for any help.    Thanks!   ... View more

Dear SAS Programmers,   How do I generate an array and fill it with random binomial data?  Say, I need an array with 100 rows and 5 columns, and I want the probability to be equal in all columns, say p=0.1. My current code (sorry, if it's totally stupid) is:   data Table (keep=aids); call streaminit(4321); array p[5] _temporary_ (repeat(0.1, 5)); do i = 1 to 500; aids = rand("Table", of p[*]); output; end; end; run;   First of all, the repeat function in the array does not work (because it probably shouldn't be there). But when I replace it with (0.1, 0.1, 0.1, 0.1, 0.1) the code produces a single variable with 500 entries instead of arranging the results in an array.    Thank you! ... View more