QRP
 
Loading...
Searching...
No Matches
macros Directory Reference

Files

 alphabetizevarutil.sas
 Alphabetizes variables in a data step.
 
 combo.sas
 This macro creates combination items and virtual claims.
 
 combo_processinputfiles.sas
 This macro imports the Combo and Combo Codes input files, processes them by assigning default values, and if executing as part of QRP combines codes to extract from combo and QRP.
 
 convert_inputfiles.sas
 This program determines if CSV input files exists, reads in JSON data dictionary, and creates SAS syntax for data step.
 
 convert_to_lowcase.sas
 Converts uppercase and mixed case variables to lower case value.
 
 create_comma_charlist.sas
 Converts space separate list into comma separated list in quotes.
 
 get_sas_format.sas
 This macro uses the format in the data dictionary to read in CSV file and apply variable lengths.
 
 getfromtovars_min_max_missing.sas
 Extracts the minimum &var.from and the maximum &var.to values from a dataset and counts the number of missing values in &var.from and &var.to.
 
 importfiles.sas
 This program will import any SAS transport inputfiles and render as sas7bdat for package use.
 
 isdata.sas
 This program determines whether a dataset is empty or not.
 
 mergetimeperiods.sas
 Collapses overlapping time periods.
 
 ms_agestrat.sas
 This macro creates an age group variable consisting of custom, user-specified groupings, with allowance for any mix of time units.
 
 ms_apply_pregnancywashout.sas
 This macro applies incidence washout based on pregnancy outcome.
 
 ms_assigncalmacrovars.sas
 This macro creates calendar based macro variables for reporting.
 
 ms_attrition.sas
 This macro creates the attrition table.
 
 ms_attrition_compute.sas
 Selects observations (patient/episodes) to exclude.
 
 ms_attrition_enrollment.sas
 This macro creates a dataset containing demographic and enrollment flags for attrition.
 
 ms_caresettingprincipal.sas
 This macro expands the input files aggregated caresettingprincipal variable such that it can be used to extract claims in the MSCDM and processes caresettingprincipal values containing wilcards.
 
 ms_check_path.sas
 This macros validates a user-entered path parameter as non-missing and verifies the path refers to an extant directory.
 
 ms_checkpoint.sas
 This macro records SAS session and preserves the ability to restart QRP at last completed checkpoint.
 
 ms_cidacov.sas
 Driver macro to compute characteristics and produce L1 baseline table.
 
 ms_cidacov_codeextraction.sas
 This macro extracts codes for covariate evaluation and risk scores computation.
 
 ms_cidadenom.sas
 This macro computes denominators.
 
 ms_cidanum.sas
 This macro computes the numerators for each cohort and calls many other macros.
 
 ms_cidatables.sas
 This macro creates the output tables for type 1 and type 2 cohorts.
 
 ms_cidatablest3.sas
 This macro creates the output tables for type 3 cohort.
 
 ms_cidatablest4.sas
 This macro creates characteristics and medication of interest tables for pregnancy analyses (type 4).
 
 ms_cidatablest5.sas
 This macro creates the output tables for type 5 cohort.
 
 ms_cidatablest6.sas
 
 ms_codedistribution.sas
 This macro enumerates exposure (EXP) and HOI defining codes.
 
 ms_computeriskscores.sas
 This macro computes and optionally categorizes requested risk scores.
 
 ms_computeutilization.sas
 This macro computes drug and medical utilization.
 
 ms_concomitantuse.sas
 This macro evaluates concomitant use, and identifies events.
 
 ms_concomitantusetables.sas
 This macro creates the output tables for concomitant episode cohorts.
 
 ms_create_enrollment_spans.sas
 This macro creates enrollment spans for each scenario in CIDA.
 
 ms_createcensortable.sas
 This macro creates censor and followup time tables.
 
 ms_createclaimepi.sas
 This macro creates episodes of claims with a given tolerance gap between two consecutive claims.
 
 ms_createclaimsfiles.sas
 This macro extracts and saves claims for identified cohort for HDPS/MFU.
 
 ms_createdistbaselinetable.sas
 This macro creates a baseline table, and an optional covariate profile table.
 
 ms_createmicohorts.sas
 This macro creates exposure and control (unexposed, comparator) cohorts, process according to MICOHORTFILE including additional inclusion/exclusion criteria, and evaluate outcomes.
 
 ms_createnopreggroup.sas
 This macro creates control groups.
 
 ms_createpov1.sas
 This macro finds all potential index dates and creates the POV1 dataset.
 
 ms_createpov1t4.sas
 This macro finds all potential index dates and create the _POV1 dataset for TYPE4 analysis (deliveries in pregnancy studies).
 
 ms_createpov2.sas
 This macro identifies all index dates with incidence claims in the washout period.
 
 ms_createpov3.sas
 This macro identifies all index dates meeting the inclusion/exclusion criteria.
 
 ms_createpov4.sas
 This macro creates the exposure episodes.
 
 ms_createpov56.sas
 This macro identifies events of interest.
 
 ms_createptsmasterlist.sas
 This macro creates the numerator dataset based on the first 4 POV datasets.
 
 ms_createt5episodes.sas
 This macro creates episodes that occur after a selected index date.
 
 ms_debugmacros.sas
 These are utility macros used to create dataset copies in a chosen folder for debugging purposes when QRP_DEBUG is set to Y.
 
 ms_delencounterids.sas
 This macro deletes encounterids from a file.
 
 ms_delpatients.sas
 This macro deletes PatId from a file.
 
 ms_dircheck.sas
 Checks for the existence of a directory. This macro is called by ms_check_path.
 
 ms_dose_denom.sas
 This macro identifies eligibility periods that meet a cumulative dose or daily dose criteria.
 
 ms_envelope.sas
 This macro uses data from the SDD to recode non-inpatient encounters to inpatient if they were determined to have occurred during an inpatient stay.
 
 ms_episoderec.sas
 This macro bridges member raw enrollment episodes into continuous periods, while allowing a maximum gap in enrollment.
 
 ms_episoderec2.sas
 This program bridges member raw enrollment episodes into continuous periods, while allowing a maximum gap between two consecutve enrollment periods.
 
 ms_evalsecondaryepi.sas
 This macro evaluates secondary episodes with relation to multiple events, overlap and adherence.
 
 ms_evalsecondarytables.sas
 
 ms_extractanniversarydate.sas
 This macro extracts enrollment and demographic claims based on either age or fixed calendar date, then creates claim based on valid date.
 
 ms_extractdeaths.sas
 This macro pre extracts deaths, death encounters and cause of death.
 
 ms_extractdrugs.sas
 This macro extracts dispensing claims.
 
 ms_extractencounters.sas
 This macro pre extracts raw encounter or procedure claims based on EncType match.
 
 ms_extractlabs.sas
 This macro will extract laboratory data from MSDD tables.
 
 ms_extractmeds.sas
 This macro pre extracts raw diagnosis or procedure claims based solely on code match.
 
 ms_extractmillinkage_po.sas
 This macro extracts pregnancy outcomes from the MIL table.
 
 ms_finalizemoiepisodes.sas
 This macro restricts MOI episodes and dispensings to only those during a valid pregnancy/control episode.
 
 ms_finalizeptsmasterlist.sas
 This macro finalizes the numerator dataset by doing final calculation and variables assessment.
 
 ms_findgap.sas
 This macro finds any first date that is the first after a user defined gap (or the very first).
 
 ms_freezedata.sas
 This macro creates a subset of a dataset containing patient level data.
 
 ms_initmacrovariables.sas
 This is a utility macro that is used to declare and initialize global macro variables.
 
 ms_logchecker.sas
 Reads in the SAS log and checks for concerning lines that may indicate an issue with program execution.
 
 ms_loopdth.sas
 This macro extracts death and cause of death records associated with the cohort of interest.
 
 ms_loopenc.sas
 This macro extracts encounters by looping through saved datasets that have already been partioned on EncType.
 
 ms_loopmeds.sas
 This macro will extract medical claims using code CodeType CodeCat EncType and Pdx.
 
 ms_mfu.sas
 This macro performs a Most Frequent Use (MFU) analysis.
 
 ms_moimetrics.sas
 This macro creates individual level medication of interest metrics for pregnancy analysis.
 
 ms_outputruntimes.sas
 This macro outputs the dataset &runid._runtimes.
 
 ms_partition_patients.sas
 This macros determines number of partitions and assigns each patID to a partition.
 
 ms_partition_splitdata.sas
 This macro splits a dataset based on partition number.
 
 ms_periodsoverlap.sas
 This macro creates combinations of variables for WHERE or IF condition.

 
 ms_pov1dose.sas
 This macro finds all index dates that meet a cumulative and/or current filled daily dose criteria.
 
 ms_process_pregnancyoutcomes.sas
 This macro extracts pregnancy outcomes (live or non-live birth deliveries) based on the pregnancy lookup file.
 
 ms_processinputfilechecks.sas
 This macro processes required integrity checks on QRP input files.
 
 ms_processinputfiles.sas
 This macro processes the program input files variables.
 
 ms_processwildcards.sas
 This macro expands codes that were supplied by the user using ranges (-) and/or wilcards (*).
 
 ms_setdatadrivenqueryperiod.sas
 This macro sets query period related dates for data driven queries.
 
 ms_setnumloopmacrovars.sas
 This utility macro is used to set macro variables related to a particular group during the numerators processing (ms_cidanum) based on the type of analysis being executed.
 
 ms_shaveinside.sas
 This macro identifies overlapping claims and trim exposure that is inside the reference period.
 
 ms_shaveoutside.sas
 This macro identifies overlapping claims and trim exposure that is outside of the reference period.
 
 ms_squaredtableshell.sas
 This macro creates a "squared" stratification table.
 
 ms_starttimer.sas
 This program starts a timer that captures execution time data.
 
 ms_stockpiling.sas
 This macro converts overlapping drug dispensings into non-overlapping dispensings.
 
 ms_stoptimer.sas
 This program stops a timer that captures execution time data..
 
 ms_surveillance.sas
 This macro will check for SDD changes in prior monitoring looking periods.
 
 ms_switching.sas
 This macro calculates switching episodes for Type 6 analysis.
 
 ms_util.sas
 This macro uses encounter dataset from the MSDD to count the number of distinct visits from a reference date and within a lookback period.
 
 nonrep.sas
 Removes repeated words in a macro variable.
 
 restrictclms.sas
 Restrict dataset to patIDs in &lookupdata dataset.
 
 runqrp.sas
 Macro to run QRP analytic code.
 
 soc_delete_dir.sas
 Deletes temporary subfolders.
 
 varexist.sas
 This program checks wheter an optional variable exists in an input file.
 
 varlength.sas
 Returns the length of a dataset variable.