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: 
skavyasindhu
‎06-01-2020
  • 7 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Predicted counts for negative binomial model

by Fluorite | Level 6 in Statistical Procedures
‎05-28-2020 01:59 PM
‎05-28-2020 01:59 PM
Hi everyone,   I am doing a negative binomial model and have a question predicted counts. Outcome = #events/person-years primary predictor - year (calender years from 2009 to 2018) model statement:  model outcome = year age gender race/ offset=log_personyears dist=nb link=log;   I am trying to calculate expected counts per 1000 person years. How can I change the offset to predict 1000 person years rather than 1 person year?   Thanks. ... View more

Counting subsequent visits after an index visit in an episode

by Fluorite | Level 6 in SAS Programming
‎09-24-2019 12:01 PM
‎09-24-2019 12:01 PM
  Hi everyone, I am trying to calculate the number of visits in a 14-day episode. All the visits within 14 days of an index visit count as an episode. The index visit is visit #0. The date is in mmddyy format. data have -  ID      date           index       episode_visits      episode_visits_total 1       1/1/2018      1                  0                       . 1       1/2/2018      0                  1                       . 1       1/3/2018      0                  2                       2 1       1/1/2019      1                  0                       . 1       1/18/2019    1                  0                       .   My question is, how do I populate the total episode visits when they are 0 (no subsequent visits). data want -  ID      date           index       episode_visits      episode_visits_total 1       1/1/2018      1                  0                       . 1       1/2/2018      0                  1                       . 1       1/3/2018      0                  2                       2 1       1/1/2019      1                  0                       0 1       1/18/2019    1                  0                       0   Thank you!! ... View more

Counting subsequent visits after an index visit in an episode

by Fluorite | Level 6 in SAS Programming
‎09-23-2019 02:05 PM
‎09-23-2019 02:05 PM
Hi everyone, I am trying to calculate the number of visits in a 14-day episode. All the visits within 14 days of an index visit count as an episode. The index visit is visit #0. The date is in mmddyy format. data have -  ID      date           index       episode_visits      episode_visits_total 1       1/1/2018      1                  0                       . 1       1/2/2018      0                  1                       . 1       1/3/2018      0                  2                       2 1       1/1/2019      1                  0                       . 1       1/18/2019    1                  0                       .   My question is, how do I populate the total episode visits when they are 0 (no subsequent visits). data want -  ID      date           index       episode_visits      episode_visits_total 1       1/1/2018      1                  0                       . 1       1/2/2018      0                  1                       . 1       1/3/2018      0                  2                       2 1       1/1/2019      1                  0                       0 1       1/18/2019    1                  0                       0   Thank you!! ... View more

Continuous enrollment from service date to 30 days after the service d...

by Fluorite | Level 6 in SAS Programming
‎06-28-2019 09:48 AM
‎06-28-2019 09:48 AM
Hi everyone,   I have a wide dataset like this: All dates are in YYYY-MM-DD format.   data have; input member_id $ service_date coverage_start1 coverage_end1 coverage_start2 coverage_end2; cards; 1 20150125 20130101 20131231 20150101 20150226 2 20150225 20150101 20150226 20170101 20170131 3 20161001 20160901 20161131 20161101 20161102 4 20180101 20171215 20180115 20180116 20180331 ; run;   I want only the members that have continuous enrollment from service date to 30 days after the service date Expected output 1 20150125 20130101 20131231 20150101 20150226 3 20161001 20160901 20161131 20161101 20161102 4 20180101 20171215 20180115 20180116 20180331   TIA ... View more

Re: select the date that is immediately 30 days after the first date

by Fluorite | Level 6 in SAS Programming
‎01-25-2019 10:30 AM
‎01-25-2019 10:30 AM
This worked!! Thank you so much, i really appreciate your help. ... View more

Re: select the date that is immediately 30 days after the first date

by Fluorite | Level 6 in SAS Programming
‎01-24-2019 05:37 PM
‎01-24-2019 05:37 PM
You are right. Sorry about that. I just edited. ... View more

select the date that is immediately 30 days after the first date

by Fluorite | Level 6 in SAS Programming
‎01-24-2019 05:03 PM
‎01-24-2019 05:03 PM
Hello, I need help with the claims data that i am working with. data have;       input person_sk service_dt:mmddyy.;       cards;      001 04/01/2014       001 01/01/2014       001 01/15/2014       001 03/01/2014       001 03/03/2014       001 04/15/2014       002 05/1/2014       002 10/1/2014       ; run;   I need to identify the service_dt that is immediately 30 days after the first service_dt. This will be my first trigger date. Then i need to count the number of days from first trigger date and identify the second trigger date that comes immediately 30 days after the first trigger date. I need the data set to be like      person_sk service_dt trigger_date      001 01/01/2014  1      001 01/15/2014  0      001 03/01/2014  1      001 03/03/2014  0      001 04/02/2014  1      001 04/15/2014  0      002 05/1/2014 1      002 10/1/2014  1   Can anyone help me?   Thank you!! ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-01-2020 02:28 PM
  • Contact User via AIM
Quick links