Description
Assignment Solutions, Case study Answer sheets
Project Report and Thesis contact
[email protected]
www.mbacasestudyanswers.com
ARAVIND – 09901366442 – 09902787224
Business Analytics Using SAS
Multiple choice:
I. Which one of the following is the value of the variable data work? One; a = 2; b = 3; c = a ** b; run;
a. 6
b. 8
c. 9
d. None of the above
II. Which one of the following statement can’t be part of “PROC FREQ” (1)
a. Output
b. Weight
c. Set
d. Tables
III. Which one is not a data type in SAS.
a. Numeric
b. Date
c. Character
d. Boolean
IV. Which of the following statements are used to read delimited raw data file and create an SAS data set (1)
a. Data, Infile, Input
b. Data, Set, Input
c. Data, Set, Infile
d. Data & Set
V. Which of these is casual model technique
a. Moving average
b. Exponential Smoothing
c. Regression
d. Trend Model
VI. When variance between predicted and actual values is not same, it is called –
a. Multicolinearity
b. Heteroskedasticity
c. Homoscadesticity
d. Autocorrelation
VII. Is there a limitation of records in SAS? (1)
a. No
b. Ye
c. Can’t say
d. None of the above
IX. what is syntax used for assigning library in SAS (1)
a. LibSet
b. LibData
c. Data
d. Libname
VIII. Which one is not a window in SAS (1)
a. Editor
b. Log
c. drive
d. results
X. What is the syntax to print results in SAS (1)
a. Proc set
b. Proc print var
c. Proc Print
d. Proc Sql
Part Two
1. Write data step to assign work dataset, say ABC with limitation of 10 observations only? (5)
2. Write the role of PDV in SAS (5)
3. Explain lib name function with read-only access (5)
4. What is the starting date in SAS, how does SAS reads any given date (5)
Section B: Caselets (40 marks)
Caselet 1
1. Answer the question based on data given below. Name of the dataset is class-
Roll Number Class Age Gender Subject Sports
001 1 10 M Maths Cricket
002 1 11 M English Tennis
003 2 9 F Maths Football
004 4 7 F Science Football
005 3 7 M Maths Cricket
006 5 10 F Science Tennis
007 3 7 F Art Cricket
Questions
1. Write code to see frequency distribution by Gender & Subject? (10)
2. Write code to filter student age less than 10 and like football and Maths? (10)
3. Write code to sort the data by age? (10)
4. Which sport has the maximum demand, write code to see proportionate (10)
Section C: Applied Theory (30 marks)
1. Explain how SAS can replace excel, talk about 3 key features of SAS? (15)
2. What is the meaning of debugging in SAS, how can it help in code writing?
Assignment Solutions, Case study Answer sheets
Project Report and Thesis contact
[email protected]
www.mbacasestudyanswers.com
ARAVIND – 09901366442 – 09902787224
doc_950468401.doc
Assignment Solutions, Case study Answer sheets
Project Report and Thesis contact
[email protected]
www.mbacasestudyanswers.com
ARAVIND – 09901366442 – 09902787224
Business Analytics Using SAS
Multiple choice:
I. Which one of the following is the value of the variable data work? One; a = 2; b = 3; c = a ** b; run;
a. 6
b. 8
c. 9
d. None of the above
II. Which one of the following statement can’t be part of “PROC FREQ” (1)
a. Output
b. Weight
c. Set
d. Tables
III. Which one is not a data type in SAS.
a. Numeric
b. Date
c. Character
d. Boolean
IV. Which of the following statements are used to read delimited raw data file and create an SAS data set (1)
a. Data, Infile, Input
b. Data, Set, Input
c. Data, Set, Infile
d. Data & Set
V. Which of these is casual model technique
a. Moving average
b. Exponential Smoothing
c. Regression
d. Trend Model
VI. When variance between predicted and actual values is not same, it is called –
a. Multicolinearity
b. Heteroskedasticity
c. Homoscadesticity
d. Autocorrelation
VII. Is there a limitation of records in SAS? (1)
a. No
b. Ye
c. Can’t say
d. None of the above
IX. what is syntax used for assigning library in SAS (1)
a. LibSet
b. LibData
c. Data
d. Libname
VIII. Which one is not a window in SAS (1)
a. Editor
b. Log
c. drive
d. results
X. What is the syntax to print results in SAS (1)
a. Proc set
b. Proc print var
c. Proc Print
d. Proc Sql
Part Two
1. Write data step to assign work dataset, say ABC with limitation of 10 observations only? (5)
2. Write the role of PDV in SAS (5)
3. Explain lib name function with read-only access (5)
4. What is the starting date in SAS, how does SAS reads any given date (5)
Section B: Caselets (40 marks)
Caselet 1
1. Answer the question based on data given below. Name of the dataset is class-
Roll Number Class Age Gender Subject Sports
001 1 10 M Maths Cricket
002 1 11 M English Tennis
003 2 9 F Maths Football
004 4 7 F Science Football
005 3 7 M Maths Cricket
006 5 10 F Science Tennis
007 3 7 F Art Cricket
Questions
1. Write code to see frequency distribution by Gender & Subject? (10)
2. Write code to filter student age less than 10 and like football and Maths? (10)
3. Write code to sort the data by age? (10)
4. Which sport has the maximum demand, write code to see proportionate (10)
Section C: Applied Theory (30 marks)
1. Explain how SAS can replace excel, talk about 3 key features of SAS? (15)
2. What is the meaning of debugging in SAS, how can it help in code writing?
Assignment Solutions, Case study Answer sheets
Project Report and Thesis contact
[email protected]
www.mbacasestudyanswers.com
ARAVIND – 09901366442 – 09902787224
doc_950468401.doc