Skip to Content

CCRAT SAS Macro Readme

Date Created: 05/26/2010

Short instruction file on the use of the men's colorectal cancer (CRC) absolute risk projection SAS macro (Men_CRC_RAM)

The men's colorectal cancer absolute risk projection SAS macro, Men_CRC_RAM needs the following information as input to estimate absolute risk of colorectal cancer:
Race =1, white
=2, african-american
=3, hispanic
=4, asian-american

T1 T1, current age ranges from: 50 to 85
T2 T2, projection age ranges from: T2>T1 and T2

Sigmoid_Polyps =0, sigmoidoscopy and/or colonscopy last 10 years and no history of polyps
=1. no sigmoidoscopy and/or colonscopy last 10 years
=2, sigmoidoscopy and/or colonscopy last 10 years, and history of polyps
=3, unknown sigmoidoscopy and/or colonscopy last 10 years, unknown history of polyps

NoIBuprofin =0, regular user of Ibuprofin only
=1, non user of IBuprofin only

Vigorus_Xrcis =0, 0 hrs/wk
=1, > 0 and <_3d_2></_3d_2>
=2, >2 and <_3d_ 4=""></_3d_>
=3, >4 hrs/wk

Cig_Yrs =0, # yrs cigarette smoking = 0
=1, # yrs cigarette smoking > 0 and
=2, # yrs cigarette smoking >= 15 and
=3, # yrs cigarette smoking >= 35

Vegetable =0, >=5 servings of vegetables per day
=1, <5 servings="" of="" vegetables="" per=""></5>

Num_Cigs =0, # cigarettes smokes = 0
=1, # cigarettes smokes >= 1 and
=2, # cigarettes smokes >= 11 and <_3d_></_3d_>
=3, # cigarettes smokes >= 21

BMI_Trnd =0, BMI <_3d_></_3d_>
=1, BMI > 24.9 and BMI <_3d_></_3d_>
=2, BMI > 29.9

No_NSaids =0, regular user of asprin and/or Nsaids
=1, non user of asprin or Nsaids

Fam_Hist_CRC =0, 0 first degree relative with CRC (CRC=Colorectal Cancer)
=1, 1 first degree relative with CRC
=2, 2 or more first degree relatives with CRC

!!!!!!!!!!!! Warning Warning Warning Warning Warning Warning !!!!!!!!!!!!
!!!!!!!!!!!! Warning about an inadmissible error condition !!!!!!!!!!!!

Inadmissable condition of NoIBuprofin=0 and NoNSAIDS=1
i.e. individual uses IBuprofin but does not use NSaids. This is contradictory since IBuprofin is a NSaid drug projected absolute risk for records with this contradition will be missing

!!!!!!!!!!!! Warning about an inadmissible error condition !!!!!!!!!!!!
!!!!!!!!!!!! Warning Warning Warning Warning Warning Warning !!!!!!!!!!!!


A short SAS sample program, Men_CRC_Template.sas, which reads a covariate input dataset, Men_CRC_raw.in, are included to more clearly demonstrate the use of the SAS macro Men_CRC_RAM. User's can run the program Men_CRC_Template.sas for instructional and clarification purposes


Short instruction file on the use of the women's colorectal cancer (CRC) absolute risk projection SAS macro (Women_CRC_RAM)

The women's colorectal cancer absolute risk projection SAS macro, Women_CRC_RAM needs the following information as input to estimate absolute risk of colorectal cancer:

Race =1, white
=2, african-american
=3, hispanic
=4, asian-american

T1 T1, current age ranges from: 50 to 85

T2 T2, projection age ranges from: T2>T1 and T2

Sigmoid_Polyps =0, sigmoidoscopy and/or colonscopy last 10 years and no history of polyps
=1. no sigmoidoscopy and/or colonscopy last 10 years
=2, sigmoidoscopy and/or colonscopy last 10 years and history of polyps
=3, unknown sigmoidoscopy and/or colonscopy last 10 years, unknown history of polyps

Estrogen =0, estrogen positive (i.e. premenopausal or using hormone replacement therapy) in last 2 years
=1, estrogen negative in last 2 years

Fam_Hist_CRC =0, 0 first degree relative with CRC (CRC=Colorectal Cancer)
=1, 1 first degre relative with CRC
=2, 2 or more first degre relatives with CRC

NSaids =0, regular user of asprin and /or Nsaids
=1, non user of asprin or Nsaids

Vigorus_Xrcis =0, 0 hrs/wk
=1, > 0 and <_3d_ 2=""></_3d_>
=2, >2 and <_3d_4></_3d_4>
=3, greater than 4 hrs/wk

BMI =0, BMI less <_3d_></_3d_>
=1, BMI greater > 29.9

Vegetable =0, >=5 servings of vegetables per day
=1, <5 servings="" of="" vegetables="" per=""></5>


A short SAS sample program, Women_CRC_Template.sas, which reads a covariate input dataset, Women_CRC_raw.in, are included to more clearly demonstrate the use of the SAS macro Women_CRC_RAM. User's can run the program Women_CRC_Template.sas for instructional and clarification purposes
 

References:

  • Freedman AN, Slattery ML, Ballard-Barbash R, Willis G, Cann B, Pee D, Gail MH, Pfeiffer RM. A colorectal cancer risk prediction tool for white men and women without known susceptibility. J Clin Oncol 2009 Feb 10;27(5):686-93.
  • Park Y, Freedman AN, Gail MH, Pee D, Hollenbeck A, Schatzkin A, Pfeiffer RM. Validation of a colorectal cancer risk prediction model among whites 50 years old and over. J Clin Oncol 2009 Feb 10;27(5):694-8.