SAS 3: Inputting data manually for Odds Ratios and Relative Risk

Last week, you learned how to read an excel file into SAS. There are other ways to get data into SAS. For instance, if you already have your 2×2 table ready and you just want SAS to calculate either your Odds Ratio or your Relative Risk, you can input the data directly into SAS using a function called datelines. Here is an example of how data lines works. Note in the code below the data is called GORDIS, and the input are delineated by the $ telling the data what each column represents

DATA gordis ;

        INPUT exposed $ disease $ patients ;

DATALINES ;

        exposed disease 50

        exposed none    50

        not_exp disease 25

        not_exp none    75

;

PROC FREQ DATA = gordis ;

  TABLES exposed*disease / RELRISK RISKDIFF;

  WEIGHT patients ;

RUN ;

1. Run the above program and screenshot the results. You will now put that into a word document as part of your submission.

2. Now look up your own example of a 2×2 table. Create your own code and screenshot the code as well as the result. You want to change the labels of the graph to reflect your own data yet. You also should change the name of the data file.