SAS Support Communities

Hi All,   I apologize if this has been asked before, this question is tricky to formulate, let alone find an answer in the forum.    I have a table like this:         data have;     input theta1 theta3 sigma11 sigma13;     datalines;         . . . .         0.22 . . .         . . . .         . 0.29 . .         . . . .         . . 0.02 -0.02         . . . .     ;     run;   And I need to get a table like this: all values in one row:       data want;     input theta1 theta3 sigma11 sigma13 ;     datalines;         0.22 0.29 0.02 -0.02     ;     run;   I am curious if this can be done in few steps. I would appreciate any help!     ... View more

Hi SAS programmers, Could you please help me with this problem? I don't even know where to start learning how to do this and not sure whether it is possible. This is the data:     data a;     input id time therapy;     cards;         1 1 0         1 2 0         1 3 1         1 4 1         2 1 2         2 2 2         2 3 2         2 4 0         3 1 1         3 2 1         3 3 0         3 4 1         4 1 1         4  2 1         4 3 1         4 4 1         ;     run;   I need to create a time-independent indicator variable that takes the value of 1 if subject's therapy became 0 after being 1, or 2; and 0 otherwise. So, suppose therapy=0 means no therapy, while therapies 1 and 2 are types of therapy. If 0 precedes 1 or 2, it is considered it to be normal, while if it follows 1 or 2, it means discontinuation of therapy, which required attention. I ultimately need to know how many people discontinued therapy. Is it at all possible to do in SAS?   Thank you! ... View more

Hi SAS Programmers,   Could you please help me with this problem. Here is my data:     data mydata;         input id time var1 var2 @@;         cards;         1 1 3 1         1 2 3 1         1 3 3 1         1 4 2 1         1 5 . .         2 1 3 1         2 2 . .         2 3 . .         2 4 2 0         2 5 . .         3 1 2 0         3 2 2 0         3 3 2 1         3 4 . .         3 5 . .         ;     run; I need to create a variable for censoring, so that it takes a value of 1 if a person dropped out of the study, i.e. if persons variables 1 and 2 are both missing from now on. Here is what I need to get:    id   time   var1  var2 cens  1 1 3 1 0 1 2 3 1 0 1 3 3 1 0 1 4 2 1 0 1 5 . . 1 2 1 3 1 0 2 2 . . 0 2 3 . . 0 2 4 2 0 0 2 5 . . 1 3 1 2 0 0 3 2 2 0 0 3 3 2 1 0 3 4 . . 1 3 5 . . 1   I cannot base the calculation of "cens" on missing values, because there is intermittent missingness, so the the code: "if var1=. and var2=. then cens=1" will produce positive censoring indicator for id 2 at times 2 and 3, which is not correct. I feel like the right code will need some sorting and retain statement, but can't figure it out by myself.     I would appreciate any tips or advice! Thank you! ... View more

Hi SAS programmers,   Could you please help me with the following problem? My data is:     data have;     input id visit cvd;     datalines;     1   1    0     1   3    0     1   5    1     1   9    0     2   3    .     2  4    1     2  5    0     2   9    .     ; If a subject had cardiovascular even (CVD=1), I need them to retain CVD=1 in all subsequent visits. Data are unbalanced, measurements are taken for participants at different visits, and there are missing values. So I need to preserve missingness and zeros, unless subjects hits CVD=1, then “1” needs to be carried on until the last visit per id.    Any help/tips will be highly appreciated!    ... View more

Hi,    I have been trying to output a dataset from proc genmod that would contain parameter estimates and their associated standard errors. I need to further use them to get pooled estimates from 5 imputed datasets. Here is my code:       proc genmod data=mydata;         weight stweight;         class id var1 var2 var3 var4;         model y = var1 var2 var3 var4 / dist=N link=id type3;         repeated subject=id / type=ind;        ods output parameterestimates=parms parminfo=info;   run;   When I run it, SAS almost crashes and then tells me that the output dataset has not been created. Could anyone please tell me what I am doing wrong?    Thanks! ... View more