Hi all, It's my first time to use PSMATCH procedure and when I feed my data in proc PSMATCH, no matter how I change my region statement, SAS keeps giving me the error message: The support region does not exist.   I'm wondering what I should check/what might go wrong? Based on this message, from where should I start checking?    Below is the SAS code I am using: proc psmatch data=all1 region=allobs; class treatment; psmodel treatment(Treated='1')=apoegr age sexcd stage cdrsbbl mmsebl adacogbl eduyrs med sympdur reg plasmaptau; assess lps var=(apoegr age sexcd stage cdrsbbl mmsebl adacogbl eduyrs med sympdur reg plasmaptau) / weight=atewgt plots=(boxplot barchart); output out(obs=all)=out_iptw lps=_lps ps=_ps atewgt=_iptw; run; ... View more

Hi all, I'm just wondering if you have had such experience before: same exact data, fit into the "same" model (in my opinion, below two models are the same) but the convergence result is totally different (model one cannot converge, but model two can): (I know model 1 LSMEANS statement asks for diff, but model 2 asks for pdiff. But i don't think this is the reason). The only reason i can see and have tried it worked is to re-order the variables in class statement, i.e., to put pstudyid right after usubjid, just like the 2nd model. But Why? why does this matter?        model 1: proc mixed data=cdr0102_pool; class usubjid avisitn anfgr02n adcmblfl region1 apoegr3 pstudyid; *===<apparently the order in class impact the convergence (pstudyid); model chgtpt02 = anfgr02n avisitn avisitn*anfgr02n pstudyid pstudyid*avisitn tpt02 tpt02*avisitn mmsebl adcmblfl region1 apoegr3/ ddfm=kr residual; repeated avisitn / type=un subject=usubjid; lsmeans avisitn*anfgr02n/ diff cl; run;   model 2: proc mixed data=cdr0102_pool; class usubjid pstudyid avisitn anfgr02n adcmblfl region1 apoegr3; model chgtpt02 = anfgr02n avisitn avisitn*anfgr02n pstudyid pstudyid*avisitn tpt02 tpt02*avisitn mmsebl adcmblfl region1 apoegr3 / ddfm=kr residual; repeated avisitn / type=un subject=usubjid; lsmeans avisitn*anfgr02n / cl pdiff; run; ... View more

Hi all, I'm trying to write an iteration program and the main idea is that I want my program run multiple time and each time to use one value from a macro variable with a set of values.    The example code is as below: data critlist; input var1 var2; datalines; 1.12 1.19 1.12 1.29 1.12 1.36 1.12 1.41 1.22 1.19 1.22 1.29 1.22 1.36 1.22 1.41 1.32 1.19 1.32 1.29 1.32 1.36 1.32 1.41 1.42 1.19 1.42 1.29 1.42 1.36 1.42 1.41 ; proc sql noprint; select var1, var2 into :mvar1 separated by ' ', mvar2 separated by ' ' from critlist; quit;   So my question is i don't know how to write my data step so that i can put the value from the macro variable into use:    data output; set input; if ana_var > 1.12                        *Here i don't know what to so that SAS will know if the the 1st value from &mvar1; then ana_crit = "using 1.12";      *Here i don't know what to so that SAS will know if the the 1st value from &mvar1;   if ana_var > 1.19                        *Here i don't know what to so that SAS will know if the the 1st value from &mvar2; then ana_crit = "using 1.19";      *Here i don't know what to so that SAS will know if the the 1st value from &mvar2; run;   then run this data step multiple times to use ALL values from &mvar1 and &mvar2.   so basically, i want to run my data step multiple times using each of the values i assigned to &mvar1 and &mvar2. But i don't know how to write the step....   Thanks! Tina ... View more

Hi all, Would you mind let me know what your thoughts are if I want to count for below dataset: column id, order, and type are the dataset I currently have, and column count is the dataset I want to create. Basically, I want to count the type variable within each id following the order, i.e., if the one type got interrupted by another type, then the second part of the same type need to be re-counted for this id.  id order type count 1 1 Not_Applicable 1 1 2 Not_Applicable 2 1 3 Not_Applicable 3 1 4 Not_Applicable 4 1 5 Not_Applicable 5 1 6 Not_Applicable 6 1 7 Not_Applicable 7 1 8 Not_Applicable 8 1 9 Not_Applicable 9 1 10 Not_Applicable 10 1 11 Not_Applicable 11 1 12 Not_Applicable 12 1 13 Not_Applicable 13 1 14 Not_Applicable 14 1 15 Not_Applicable 15 1 16 Not_Applicable 16 1 17 Not_Applicable 17 1 18 Not_Applicable 18 1 19 intermittent 1 1 20 Not_Applicable 1 2 1 Not_Applicable 1 2 2 Not_Applicable 2 2 3 Not_Applicable 3 2 4 Not_Applicable 4 2 5 Not_Applicable 5 2 6 Not_Applicable 6 2 7 Not_Applicable 7 2 8 Not_Applicable 8 2 9 Not_Applicable 9 2 10 Not_Applicable 10 2 11 Not_Applicable 11 2 12 Not_Applicable 12 2 13 Not_Applicable 13 2 14 Discontinued 1 2 15 Discontinued 2 2 16 Discontinued 3 2 17 Discontinued 4 2 18 Discontinued 5 2 19 Discontinued 6 2 20 Discontinued 7 3 1 Not_Applicable 1 3 2 Not_Applicable 2 3 3 Not_Applicable 3 3 4 Not_Applicable 4 3 5 Not_Applicable 5 3 6 Not_Applicable 6 3 7 Not_Applicable 7 3 8 Not_Applicable 8 3 9 Not_Applicable 9 3 10 Not_Applicable 10 3 11 intermittent 1 3 12 intermittent 2 3 13 intermittent 3 3 14 intermittent 4 3 15 intermittent 5 3 16 Not_Applicable 1 3 17 Not_Applicable 2 3 18 Not_Applicable 3 3 19 Not_Applicable 4 3 20 Not_Applicable 5 ... View more

Hi all, I am new to proc MI procedure. I just want to ask when you see the following message, what direction are you going to consider in order to fix your code or if you can let me know, based on your experience, what can be wrong if you see the below message:   WARNING: The EM algorithm (MLE) fails to converge after 200 iterations. You can increase the number of iterations (MAXITER= option) or increase the value of the convergence criterion (CONVERGE= option). WARNING: The EM algorithm (posterior mode) fails to converge after 200 iterations. You can increase the number of iterations (MAXITER= option) or increase the value of the convergence criterion (CONVERGE= option). ERROR: Not enough observations to fit regression models in monotone-data posterior step.   Many thanks! Tina ... View more

Hi all, I'm trying to produce a month by month enrollment summary based on the subject's randomization date (Mainly: month and year) and April 2021. The results I want to produce is like below: random_date          first month      2nd month    ......        xx month May-2018                   xx                      xx                              xx Jun -2018                   xx                      xx                              xx   xx is the number of subjects   I can only get my current program go this far:   data intv; set enroll_data; enddate = '30APR2021'd; startdate = input(compress(date_randomized,'-'),date7.); nmonths = intck('month', startdate, enddate); run;   In order for me to achieve that goal, can you please suggest how I should build up my program? Many thanks! ... View more

Hi all, I'm having a question regarding to converting partial SAS date. I'm having some incomplete date like 'OCT 2018', this is a character variable and I want to convert it to '2018-10' also a character variable.    I'm thinking to change it to a numeric variable then convert that numeric to character variable. However since it is a partial date, I'm not sure how to do it.   Many thanks! ... View more

Hi all, I'm having a CDISC standard AE data and I want to compare the new and old AE data (different data cut date) to flag any new or changed AE records.    I also want to color code the new record (highlight in a different color for the whole row) and the changed record (only highlight the differences in the cell).   I assume this will involve using proc compare and proc report. However, about the color coding the record, I'm not quite sure how to do it. Can anyone help?   Many thanks! ... View more