cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sliaousa
‎06-14-2023
  • 4 Posts
  • 2 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: LSMEANS/ESTIMATES in PROC MIXED with both class and continuous cov...

by Fluorite | Level 6 in Statistical Procedures
‎06-14-2023 02:32 PM
‎06-14-2023 02:32 PM
The trtp*week is the usual MMRM model we ran and we are trying this "constrained longitudinal data analysis (cLDA)" model as comparison and cLDA, we will need to use these dummy variables before running in PROC MIXED. Noticed in this PROC MIXED, trtpn is not included anymore.   Just to clarify the LSmeans we would like to obtain is for trtpn=1 at each of the weeks and the coefficients for the continuous variables will follow SAS LSMEANS defaul:    I am struggling to write the statements (either using LSMEANS or ESTIMATE) to get the LSmeans we want... ... View more

LSMEANS/ESTIMATES in PROC MIXED with both class and continuous covaria...

by Fluorite | Level 6 in Statistical Procedures
‎06-14-2023 01:08 PM
‎06-14-2023 01:08 PM
Hi,    I am running a "Constrained Longitudinal Data Analysis" using PROC MIXED model with repeated measurements and a list of covariates (including both class and continuous ones) and am having problem writing the LSMEANS statement to output the lsmeans with specific condition for the covariates.  The objective is to obtain the LS means for trtpn=1 at week2, at week 4, at week 8,..  and just use the means for the other covariates. Also want to obtain the LS means for trtpn=2 at week2, week4...., etc.   Here is my data look like: *** For cLDA, need to create dummy trt variables for each week, only when trtpn=1 then these trt variables will be assigned as 1;  data A; set A; if (trtpn=1 and week=2) then trtwk2=1; else trtwk2=0; if (trtpn=1 and week=4) then trtwk4=1; else trtwk4=0; if (trtpn=1 and week=8) then trtwk8=1; else trtwk8=0; if (trtpn=1 and week=12) then trtwk12=1;else trtwk12=0; if (trtpn=1 and week=16) then trtwk16=1;else trtwk16=0; if (trtpn=1 and week=20) then trtwk20=1;else trtwk20=0; run;     I tried several codes in PROC MIXED and none worked yet. Below is one with no error message but the output is all missing: PROC MIXED DATA=A;         CLASS subjid WEEK(ref=first) trtwk2 trtwk4 trtwk8 trtwk12 trtwk16 trtwk20 SOO UOR; by category2 category biomarker;         MODEL LOG_VALUE_N = WEEK trtwk2 trtwk4 trtwk8 trtwk12 trtwk16 trtwk20 BALSFRS BASESLOPE TSS SOO UOR/SOLUTION DDFM=KENWARDROGER;         REPEATED WEEK/SUBJECT=SUBJID TYPE=UN;   estimate 'trt1 for week=2' trtwk2 1 week 1 0 0 0 0 0 ; estimate 'trt2 for week=2' trtwk2 0 week 1 0 0 0 0 0 ;         ODS OUTPUT    estimates=estimates;  run;       Here is another with error message:  PROC MIXED DATA=adalsencals;         CLASS subjid WEEK(ref=first) trtwk2 trtwk4 trtwk8 trtwk12 trtwk16 trtwk20 SOO UOR; by category2 category biomarker;         MODEL LOG_VALUE_N = WEEK trtwk2 trtwk4 trtwk8 trtwk12 trtwk16 trtwk20 BALSFRS BASESLOPE TSS SOO UOR/SOLUTION DDFM=KENWARDROGER;         REPEATED WEEK/SUBJECT=SUBJID TYPE=UN; LSMEANS WEEK*TRTWK2; RUN;             ODS OUTPUT    lsmeans=lsmeans;  run;   Please let me know how to write the statements in PROC MIXED to get the desired lsmeans?   Thanks, Aurora ... View more

Check multiple variables with non-missing values and create new variab...

by Fluorite | Level 6 in SAS Programming
‎05-02-2023 11:35 AM
‎05-02-2023 11:35 AM
Hi,  I have a dataset with multiple score variables (var7 - var14 where 7 represents visit 7) and I am using array to check which variables had non-missing value and I want to create a new variable vislst to store these visit numbers in (e.g. 7,9,10). Below codes can only store the last non-missing visit number and not the list of visits. I tried first. and retain but not worked yet. Please help.   data Score_trans_new; set Score_trans; length vislst $100.; array values[1:8] var7 var8 var9 var10 var11 var12 var13 var14; do i=1 to dim(values); if not missing(values[i]) then do; vislst=substr(vname(values[i]),7,2); end; end; run;   Thanks! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-14-2023 07:18 PM
Likes given to
View All
Quick links