Hello   I'm trying to keep a row that has a date closest to but after a test result date, Below is sample data. Is it possible to do this while the data is in long form?   Have: Patient      ComorbidityScore  Test Result Patient 1   Date 1                      Date X                  Date 2                       Date X                   Date 3                      Date X Patient 2    Date 1                     Date Y                   Date 2                     Date Y Want: Patient      ComorbidityScore   Test Result Patient 1   Date 3                      Date X                                    Patient 2    Date 1                      Date Y ... View more

Hello - I'm trying to get a proc freq output that contains 3 columns (all patients, COPD=0, COPD=1) instead of running 2 procedures and coping the answers over by hand. Can you help? proc freq order=freq; table race; run; proc freq order=freq; table race*COPD; run; Desired output:              All     COPD=0    COPD=1 race1 race2 race3   Also, is there a way to order by a certain column or will SAS always order by descending row sum? ... View more

Hello - I'm using SAS 9.4 and am simply trying to use proc sql to make a table that is grouped and in a certain order but am getting syntax errors that I can't figure out. Below is the code and attached is the screenshot of the errors.     PROC SQL; create table by_specialty as SELECT SumIndemnityCPI,PRIMARY_RESPONSIBLE_PROVIDER, from finalfinalfile, GROUP BY PRIMARY_RESPONSIBLE_PROVIDER, order by SumIndemnityCPI, QUIT;   ... View more

Hello,   I'm using SAS 9.4 and need to create a variable (mean payment) using information from two different arrays. The example data below will hopefully highlight what I mean. There are 2 arrays: Defendant and Payment. Payment 1 refers to payment on behalf of Defendant 1; Payment 2 refers to payment on behalf of Defendant 2, etc. I'm interested in the mean payment when one was specifically made on behalf of a Student. The correct answer in this example data would be ($100+$200)/2=$150. How do I write SAS code extracting this information?  Thanks for the help!   Example data Case  Defendant1 Defendant2 Defendant3  Payment1 Payment2 Payment3 1        Student        .                  .                    $100          .                . 2        Physician     Student       .                     0               $200        . 3        Physician     Nurse          Student        $100           $300        0       ... View more

Hello,   I'm using sas 9.4. I've been reading how to change the title of a survival plot and x-axis but don't understand how to use the following macro I found. Do I run proc template first, then run this macro?  How do I change this macro to get the title to be "Kaplan Meier Plot" and X-axis "Time (weeks)"?   %macro SurvivalTemplate; %local outside; proc template; %do outside = 0 %to 1; define statgraph Stat.Lifetest.Graphics.ProductLimitSurvival%scan(2,2-&outside); dynamic NStrata xName plotAtRisk %if %nrbquote(&censored) ne %then plotCensored; plotCL plotHW plotEP labelCL labelHW labelEP maxTime xtickVals xtickValFitPol rowWeights method StratumID classAtRisk plotBand plotTest GroupName yMin Transparency SecondTitle TestName pValue _byline_ _bytitle_ _byfootnote_; BeginGraph; if (NSTRATA=1) if (EXISTS(STRATUMID)) entrytitle &titletext1; else entrytitle &titletext0; endif; %if not &outside %then if (PLOTATRISK); entrytitle "With Number of Subjects at Risk" / textattrs=GRAPHVALUETEXT; %if not &outside %then %do; endif; %end; %AtRiskLatticeStart layout overlay / xaxisopts=(&xoptions) yaxisopts=(&yoptions); %singlestratum endlayout; %AtRiskLatticeEnd else entrytitle &titletext2; if (EXISTS(SECONDTITLE)) entrytitle SECONDTITLE / textattrs=GRAPHVALUETEXT; endif; %AtRiskLatticeStart layout overlay / xaxisopts=(&xoptions) yaxisopts=(&yoptions); %multiplestrata endlayout; %AtRiskLatticeEnd(%str(class=CLASSATRISK)) endif; if (_BYTITLE_) entrytitle _BYLINE_ / textattrs=GRAPHVALUETEXT; else if (_BYFOOTNOTE_) entryfootnote halign=left _BYLINE_; endif; endif; EndGraph; end; %end; run; %mend;   ... View more

Hello   I am trying to get the exponentiated ORs and CIs from proc genmod. Below is my code and the error message I'm getting. I'm using sas 9.4.     PROC GENMOD DATA=regression DESCENDING; CLASS age_new (param=ref ref='adult') claimant_gender (param=ref ref='FEMALE') new_state CLAIMANT_TYPE (param=ref ref='INPATIENT') RESPONSIBLE_SERVICE_CATEGORY (param=ref ref='SURGERY') bin_proc (param=ref ref='0'); MODEL MDTrainee=age_new claimant_gender JULY_LOSS WEEKEND_LOSS CLAIMANT_TYPE RESPONSIBLE_SERVICE_CATEGORY bin_proc / DIST = binomial LINK = logit; REPEATED subject=new_state / LOGOR=EXCH; lsmeans age_new claimant_gender CLAIMANT_TYPE RESPONSIBLE_SERVICE_CATEGORY / exp cl; OUTPUT OUT=predprobs P=pred; RUN; WARNING: The model does not have a GLM parameterization. This parameterization is required for the TEST, LSMEANS, LSMESTIMATE, and SLICE statement. These statements are ignored.   Also, will this only exponentiate the categorical variables in the class statement? Is there a way to exponentiate the estimates for binary variables?   Thanks Laura ... View more