ms_squaredtableshell.sas File Reference

This macro creates a "squared" stratification table. More...

Detailed Description

This macro creates a "squared" stratification table.

• Base dataset:
  • Square age group, sex, year, month.
    
    • Square either month/year, quarter/year, or year only variables.
      
• Type 3:
  • Specific stratifiers: TTC and TTE.
    
  • Determine min/max windows.
• Type 5:
  • Specific stratifiers: afdd_output_cat, cfdd_output_cat, cumdose_numdose_cat.
    
• Type 4:
  • Specific stratifiers: PrePostInd, PregDur Codes, MP::s.
    
• Additional potential stratifiers: race, hispanic, covar#, and geographic variables.
• Covariate stratifications.
  
  • Put covariates into macro variables.
• Gapnum:
  • Values of 1, 2, and 999.
    
• Episodenum:
  • Values of 1 and 2.
• Type 6:
  • Specific stratifiers: TTS (time to switch), and EpisodeLength.
• Square followup_cat, ADHERENCE, ADHERENCE_#, EPIGAP.
  

Program inputs

• dplocal.&RUNID._mstr_epigap (Dataset containing epigap.)
• infolder.&COHORTCODES. (Dataset with codes used to define exposures and outcomes of interest.)
• infolder.&TYPE5FILE. (Dataset required for medical product utilization cohort identification strategy.)
• infolder.&ZIPFILE. (Lookup table required if a request requires stratification of results by geographic location.)
• work._length_squared (Dataset containing episodeLength.)
• work._tts_squared (Dataset containing TTS (time to switch).)
• work.adherencefile (Dataset to determine overall adherence for a Type 2 multiple events analysis.)
• work.cohortfile (Dataset containing cohort group.)
• work.secondaryinputfile (Dataset for secondary episode analysis.)

Program outputs

• work._episodenum (Dataset containing squared values of episodenum.)
• work._gapnum (Dataset containing squared values of gapnum.)
• work._mastersquare (Dataset containing squared values of ageGroup, Sex, Year, Month.)
• work._mpssquared (Dataset containing unique values for group and indexcriteria.)

Usage

%ms_squaredtableshell(SQUAREVARS=&levelvars.,
                      ANALYSISVARS=AdjustedDisp RawDisp TotRxSup TotRxAmt NumEvents &followuptimevar. timetocensor,
                      GROUPS=&grouplist.,
                      ANALYSIS=N);

Parameters

[in]	SQUAREVARS	List of variables to square.
[in]	ANALYSISVARS	List of variables to keep.
[in]	GROUPS	List of analysis groups.
[in]	ANALYSIS	Indicates whether to perform tree extraction.

SAS Macros Dependencies

None.

Author

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