SAS question:

The work sheet gender has column name sex. What is the data step to make a variable gender from variable sex. (Note that you are not allowed to use IF statement for this question. ) The values of gender be:

1: Male for M

2: Female for F

3: Transgender for TG

4: Other Gender for O

9: Unknown for all other types

Remarks: 1.You are allowed to use SET statement at the most once within the question to create only one data set. PROC IMPORT can be used to import data and is not a part of data step.

2. Save the EXCEL file gender.xls and import the worksheet of the file you need to create SAS data set for a question.

3. Submit only source code you create. No output or worksheets of data be included after the submission.