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: 
paulusab
‎02-11-2019
  • 6 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

PROC Mixed WARNING: Stopped because of infinite likelihood

by Calcite | Level 5 in New SAS User
‎02-11-2019 02:38 PM
‎02-11-2019 02:38 PM
proc mixed data=DIS.THEFINAL noclprint; class provfs year wave georegion ARF_code; model srrexp = YEAR pctratio georegion ARF_code RNRatio TOTSTAS certdate cream hemom hgm mefavfm nephunkmissm nm / solution ddfm=kr; repeated wave / subject=provfs type=ar(1); lsmeans year georegion ARF_code/ adjust=tukey; run; I'm working with healthcare facility longitudinal data (2013-2016) to predict readmission performance considering a host of variables (captured above in the model statement).    I've run this model a number of times working my way backwards to significant p-values among variables. After several removals I got this error in the log " WARNING: Stopped because of infinite likelihood". I've read various Q&A's on this forum trying to identify how to move forward and overcome this problem but nothing seems to provide a clear direction of what to do next. It's not duplicate data because that is intended with the structure of this model (facilities with 4 data points over time). Thoughts? ... View more

Re: Counting # > 0 in observation across variables

by Calcite | Level 5 in SAS Procedures
‎01-17-2019 04:20 PM
‎01-17-2019 04:20 PM
Wow, rookie mistake. Thank you! ... View more

Re: Counting # > 0 in observation across variables

by Calcite | Level 5 in SAS Procedures
‎01-17-2019 04:15 PM
‎01-17-2019 04:15 PM
Data Want; set Have; array _dates(*) Oct2013--Sep2018; count=0; do i=1 to dim(_dates); if _dates(i)>0 then count+1; end; run;   The result of this code for observation #1 is 60. All months in the time period have a value greater than 0. I want to now use 60 as a denominator in a segment of code later in this program. But SAS doesn't see the result of the prior program as a permanent variable. It's listed as "count" when I look at the newly created dataset. When I use "count" in the code the log shows "variable count is uninitialized". I'm not sure how to recall the variable to use in the code. Does this make sense? ... View more

Re: Counting # > 0 in observation across variables

by Calcite | Level 5 in SAS Procedures
‎01-17-2019 04:03 PM
‎01-17-2019 04:03 PM
Thank you, that was very helpful. Now if I want to recall the product of that code in another section of the code how do i refer to it? In PROC print the variable looks like it is named "count" but SAS doesn't recognize that (variable is uninitialized).  ... View more

Counting # > 0 in observation across variables

by Calcite | Level 5 in SAS Procedures
‎01-17-2019 03:16 PM
‎01-17-2019 03:16 PM
  I have a dataset (example above) that has monthly counts over a 60 month period of time. I want to obtain a count of the number of times the monthly value is > zero across one observation. I don't care to sum variable by variable but to actually know within an observation how many times the reported value is greater than zero across the 60 month period of time. Suggestions? ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎02-11-2019 03:36 PM
Quick links