ms_cidatablest6.sas File Reference

Detailed Description

• Segregate levels into each table:
  
  • Add DaySupp if not specified since that is an automatic stratification.
    
  • Add CumEpisodeLength if not specified since that is an automatic stratification.
    
  • Add EpisodeLength if not specified since that is an automatic stratification.
    
  • Add UptakeDays if not specified since that is an automatic stratification.
    
  • Trend analysis must be at least on the year level.
    
• Loop through groups
  
  • UtilCounts:
    
    • One record per patient for the class stratification.
      
    • Square stratifications variables.
      
    • Summarize data.
      
    • Save to msoc.
      
  • TrendCounts:
    
    • Alphabetize strata and determine output name and corresponding name to give to output dataset.
      
      • Count number of of stratifications.
    • Calculate year-month dispensings.
      
    • Calculate year-month users.
      
      • Calculate number of users based on total episode length.
        
      • Assign year/month for each month of followup.
    • Calculate sex, year, and month up front because _MSY is later used to calculate year and month data.
      
      • Sex/year
      • Sex/year/month
        
    • Loop through each stratifications to calculate both dispensings and user counts.
      
      • Square stratifications variables.
      • Calculate number of dispensings based on month of dispensing date (UtilDispStats uses month of episode index).
        
      • Summarize dispensing data.
        
      • Summarize user data.
        
        • Year/year month
        • Sex/AgeGroup
        • AgeGroup (age group does not vary by time)
        • Race
        • Hispanic
      • Stack levels
        
• UtilDispStats
  
  • Square stratifications variables.
    
  • Summarize data.
    
• UtilUptakeStats
  
  • Calculate uptake days, restrict to 1ast episode.
    
  • Square stratifications variables.
    
  • Summarize data.
    
• UtilEpisDurStats
  
  • Square stratifications variables.
    
  • Summarize data.
    
• UtilEpis_Censor
  
  • Square stratifications variables.
    
  • Summarize data.
    

Program inputs

• dplocal.&RUNID._dispensings (Dataset for Type 5 and Type 6 analyses containing one row per cohort, patient, and dispensing date and only contains valid claims that occur during valid enrollment spans and episodes.)
• dplocal.&RUNID._mstr (Dataset for Type 1 and Type 2 analyses with one record per individual per index date for every GROUP.)

Program outputs

• msoc.&RUNID._t6_trendcounts (Dataset for Type 6 analysis containing prevalent counts of users and are based on use during the entire episode.)
• msoc.&RUNID._t6_utilcounts (Dataset for Type 6 analysis containing number of incident users, all users, and dispensings.)
• msoc.&RUNID._t6_utildispstats (Dataset for Type 6 analysis including one row per each dispensing days supply value and a count of dispensings with that duration.)
• msoc.&RUNID._t6_utilepis_censor (Dataset for Type 6 analysis including number of treatment episodes and a count of episodes censored in the given category.)
• msoc.&RUNID._t6_utilepisdurstats (Dataset for Type 6 analysis including one row per each treatment episode duration and a count of unique patients in that treatment duration.)
• msoc.&RUNID._t6_utiluptakestats (Dataset for Type 6 analysis including one row per each product uptake duration and a count of the number of treatment episodes with that duration.)

Usage

%ms_cidatablest6();

Parameters

None.

SAS Macros Dependencies

• ms_periodsoverlap.sas
• ms_squaredtableshell.sas

Author

Sentinel Coordinating Center (info@.nosp@m.sent.nosp@m.inels.nosp@m.yste.nosp@m.m.org)