DMS IIBM ANSWER SHEETS Which of the following statements a

For answersheets contact
[email protected]
+91 95030-94040

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?
For answersheets contact
[email protected]
+91 95030-94040