MANG2062 Sas Base Programming

C1. Use your analytic skills in problem solving;

C2. Communicate technical ideas to non-specialist managers.

This coursework consists of two parts. Part 1 is data analysis using SAS and Part 2 is a short report (marks in brackets). Please copy the syntax of your SAS program (Part 1) and paste it into a Word document including your report (Part 2) so that you submit your coursework as a single Word document to Blackboard.

 This coursework consists of two parts. Part 1 is data analysis using SAS and Part 2 is a short report (marks in brackets). Please copy the syntax of your SAS program (Part 1) and paste it into a Word document including your report (Part 2) so that you submit your coursework as a single Word document to Blackboard.

PART 1: DATA ANALYSIS USING SAS

For this coursework, you will analyse the customer loyalty data with 9 independent variables, and two dependent variables (i.e. “Response” and “Profit”) with the

Below there are guidelines that you will need to follow. Please read them carefully.

Guidelines

·Write a SAS program that performs the tasks listed below and, based on the obtained results, answer the related questions.

·Comment your program liberally so that it is clear what the aim of your program is, what each data step/ procedure does and which task it addresses.

·Answer the questions using comments in the program, directly after the procedures which have produced the relevant results.

·Only use the WORK library and do not use any other SAS libraries.

Tasks and questions (marks in brackets)

1) Import the data to SAS (3)

2) Produce the frequencies of “REGION” (from most frequent to least frequent) what is the most frequent region? (3)

3) Compute the descriptive statistics of the (a) “PROFIT”, (b) “PROFIT” by “REGION”, and (c) “PROFIT” by “CLASS” and print in proper tables, separately. Briefly explain the findings. (6)

 4) Using Edate (i.e. assume today is the Edate), “LCDATE” and “DOB”, create two variables: “AGE” and “Number of months since joining the loyalty club (MOL)“.(6)

5) Using suitable statistical test, examine the relationship (1) “PROFIT” versus “GENDER”, (2) “PROFIT” versus “AGE”, and analyse the results. (6)

6) Create a new data set (avg_profit_data) for those non-zero “RESPONSE” customers and calculate an average profit (“avg_profit”) for each class of each gender. Select the variables “CLASS”, “GENDER” and “avg_profit” and print the results (9)

7) Create a pdf report (loyalty.pdf) for new data set (avg_profit_data) that contains the list of those regions in which the profit was greater than 150. Use the Moonflower style and add a title ("Regions with high profit ") and return the region and profit.(6)

8) Create a binned variable with “MOL” into the following bins: “0-12 months”, “13-24 months”, “25-36 months”, “36-60 months” and “61months+”(6)

9)  Build a logistic regression model with “AGE”, “CLASS”, “GENDER”, “REGION, “MOL” with “RESPONSE” as the dependent variable (6)

10)  Select those “RESPONSE” customers, build a linear regression on profit. Use “GENDER”, “AGE”, “REGION” and “CLASS” as independent variables (9)

PART 2: SHORT REPORT

Explain the potential impact of using SAS for solving a real problem in business analytics. What is the problem components and how you can benefit from the ability of SAS in analysing the different aspects of the problem?  Provide arguments to support your discussion, but be brief and to the point, as your future employer may only have little time to read them.  The maximum permitted word length of this report is 500 words.

Assessment criteria for Part 1 and Part 2

Your work will be assessed according to the extent to which it demonstrates knowledge and understanding of key computer programming concepts for managing and analysing data, and SAS Base language, and how it is used to manage, analyse and report data, as well as an ability to read data stored in a popular format into SAS, store data in SAS libraries, manipulate, analyse, and report data using SAS, use your analytic skills in problem solving, and communicate technical ideas to non-specialists. In particular, you can get:

Part 1

·Up to 60 marks for performing the tasks and answering the questions correctly

·Up to 20 marks for comprehensive comments, and the structure and elegance of your program

Part 2

·Up to 20 marks for a comprehensible, well-structured and literate written report that would be understandable to non-specialists