write my assignment 13140

4 Creating a SAS Data Set

a.  Retrieve and submit the starter program “ORG.SAS”.

b.  Add a DATA step before the PROC PRINT step to make new data set named work.youngadult. Use the data set orion.customer_dim as input. Include a WHERE statement to select only female customers.

Submit the program and confirm that work.youngadult was created with 30 observations and

11 variables.

c.  Modify the program to select female customers whose ages are between 18 and 36. Submit the program and confirm that work.youngadult was created with 15 observations and 11 variables.

d.  Modify the program to select 18- to 36-year-old female customers who have the word Gold in their Customer_Group values. Submit the program and confirm that work.youngadult was created with five observations and 11 variables.

e.  Add an assignment statement to the DATA step to make new variable, Discount, and assign it

a value of .25.

f.  Modify the PROC PRINT step to print the new data set as shown below. Use an ID statement to display Customer_ID instead of the Obs column. Results should contain five observations.