Hi can anyone please guide me for how to write code using proc mixed for table "MMRM Result of Physical Functioning Score at Cycle 5 by Including Geographic Region and Visit Interaction in the Model " ... View more

Hello,   How to calculate or get odds ratio and relative risk for Overall response table. I have 2 treatment group. I tried with proc freq,    proc freq data=workorr; by trt01pn mainord; table ord / chisq relrisk; weight count; output chisq relrisk out=ratio; run; /****OR***/ ods listing close; ods output cmh = relrto; proc freq data=orr2 ; by mainord ; tables stratan*trt01pn*ord / cmh relrisk; run;   But I am not getting in output dataset. I am only getting chi sq. value for first code and p value for second code.   I got risk diff. (RD) with below code.   ods trace on; /*95% CI*/ proc freq data=workorr; by trt01pn mainord ; table ord / binomial ; exact binomial; weight count / zero ; /*add this for zero CI's*/ output binomial out=orr_ ; RUN; ods trace off;   please let me know if I am missing something or doing something wrong. Thanks you.   ... View more

I would like to transpose column sord only. here is the sample data below.   I tried using ID statement. but other columns are also getting transpose. ... View more

Hello, I was wondering what is difference between (. ne chg) and (chg ne .). as i am getting different results while i use this condition vise versa. ... View more

Hi,  I am running a report for proc compare. I check manually all the values are exactly matching but still proc compare is showing discrepancy for 0 (zero) value only. and I use compress, strip, left, all type of functions to remove extra spaces so that I will get 100% match for proc compare. But still there is leading blanks for record label. I am having same issue for other table also. compare dataset is generated by me and base is by production programmer can somebody help?     ... View more

Hi , There is a variable DAI with values WEEK 2, WEEK 4, WEEK 8, WEEK 12, .. If I transpose DAI variable then I get WEEK 2, WEEK 4,.. as variable how can I change variable name from WEEK 2 to WEEK_2 ,... As space is not accepted in variable name But If i do before transpose like if DAI="WEEK 2" then dai_ "WEEK_2; But it gives error when i transpose dai_ variable  ERROR: The ID value "WEEK_2" occurs twice in the same BY group can someone please give me solution? ... View more

Hi,  How can I get the output for values as like compare value. Because of the alignment in value my proc compare report is showing mismatch value. I want output like compare value can someone help me please?     ... View more

Hello, I have final dataset for adae treatment related which shows 0 as missing value . but when i create proc report then those 0s are just blank. I dont how it is happening? as final dataset looks all fine   ... View more

I would like to transpose dataset below to this for each treatment ;     ... View more