"DID" means *difference" in difference. Odds ratios, being ratios, are not differences. So, again, if you want to estimate the difference in differences of the means, then use the NLMeans macro in the note I referred to. If you truly want odds ratios, instead of differences, then use the LSMEANS statement with DIFF and ODDSRATIO options.  ... View more

I'm a big fan of by processing. Something like this:   data have; input ID $ initial mid1 final PCI; datalines; 100 0 . 1 . 100 . 0 . . 100 . . . 1 200 1 . 0 . 200 . . . 1 300 0 . . . 300 . . 1 . 300 . 0 . . 300 . . . 0 ; run;   data one(keep=ID var1 var2 var3 var4); retain var1 var2 var3 var4; set have; by ID; if first.id then do; var1=initial; var2=mid1; var3=final; var4=PCI; end; else do; if var1<initial then var1=initial; if var2<mid1 then var2=mid1; if var3<final then var3=final; if var4<PCI then var4=PCI; end; if last.ID then output; run; proc print data=one; run; ... View more

@lousam wrote: Hello, I need to graph the mean and SE of the variable COST for 2 groups of people (Age_group="Younger", "Older") in one plot. The plot is basically graphing the trend of cost over time. The two groups of people need to be next to each other so that their SE do not overlap and I need a line connecting each point for both groups. I know my code has to look something like what I listed below.    What can I add to the code below so that the mean & SE for the two groups will appear next to one-another for each year, and how can I customize the marker color and lineattrs for each group?   Title "Average cost per year"; proc sgplot data=final; scatter x=year y=cost/ yerrorlower=lowercost yerrorupper=uppercost markerattrs=(color=black symbol=SquareFilled)errorbarattrs=(color=black); series x=year y=cost/group= age_group lineattrs=(color=blue pattern=2); XAXIS label="Year" VALUES= (2001 TO 2007 BY 1); YAXIS label="Average Cost" VALUES= (0 TO 50 BY 10); run;   I appreciate any help you can offer. The STYLEATTRS statement can be used to set attributes or a DATTRMAP set can be used to associate specific Group values with a consistent set of line, marker and text attributes.   I'm not sure what you mean by "mean & SE for the two groups will appear next to one-another ". Perhaps you may be thinking of an XAXISTABLE to show the text values associated with the shown markers. That would be one way to show below the axis rows of values aligned with the axis ticks. From the documentation here is a brief example of XAXISTABLE showing two tables and using a data set you should have available. proc sgplot data=sashelp.class (where=(age < 13)); scatter x=name y=height; xaxistable age / class=age title="Student Age" location=inside valueattrs=(color=red) labelattrs=(color=red) titleattrs=(color=red); xaxistable weight height / valueattrs=(color=blue); run; ... View more

Here's a quick tutorial on turning working code into a macro, which is what you want to do here:   https://github.com/statgeek/SAS-Tutorials/blob/master/Turning%20a%20program%20into%20a%20macro.md ... View more

1) Who ever is designing the data entry/collection process needs a headspace and alignment check. If the data points are the same then the names should not change. 2) If the plan ahead of time was to analyze the data in SAS then the use of columns/variable names like "200" should have been avoided. 3) I would ask whoever set this up "What was wrong with using descriptive names like Results  in the first place?" ... View more

1) don't see a FORMAT statement in the Proc SGPLOT/ SGPANEL code. If the format is not permanently associated with the variable you need a statement such as   Format time <formatname.>;   2) We would likely need to see actual values of X and your format definition to diagnose anything further. ... View more

You may remember: Since your dependent variable, BMI, is computed using Height and Weight, the inclusion of the latter as independent variables, will be highly correlated. ... View more