Technical interviews including SAS interviews often have more in depth questions designed to test your expertise. SAS is highly capable of data triangulation, and what distinguishes SAS from other such languages is its simplicity to code.This blog is the first part of tricky SAS questions series.
The SAS data set SASUSER.HOUSES
contains a variable PRICE which has been assigned a
permanent label of “Asking Price”.
Which SAS program temporarily replaces the label “Asking
Price” with the label “Sale Price”
in the output?
A - proc print data =
sasuser.houses; label price = “Sale Price”; run;
B - proc print data = sasuser.houses
label; label price “Sale Price”; run;
C - proc print data = sasuser.houses
label; label price = “Sale Price”; run;
D - proc print data =
sasuser.houses; price = “Sale Price”; run;
Answer: C
Question: 2
The following GAS program is
submitted:
data work.empsalary;
set work.people (in = inemp)
work.money (in = insal);
if insal and inemp;
run;
The SAG data set WORKPEOPLE has 5
observations, and the data set WORKMONEY has 7
observations. How many observations
will the data set WORK.EMPSALARY contain?
A - 0
B - 5
C - 7
D - 12
Answer: A
Question: 3
The following SAS program is
submitted:
data work.accounting;
set work.dept1 work.dept2;
jobcode = ‘FA1’;
length jobcode $ 8;
run;
A character variable named JOBCODE
is contained in both the WORK.DEPT1 and
WORK.DEPT2 SAS data sets. The
variable JOBCODE has a length of 5 in the WORK.DEPT1
data set and a length of 7 in the
WORK.DEPT2 data set. What is the length of the variable
JOBCODE in the output data set?
A - 3
B - 5
C - 7
D - 8
Answer: B
Question: 4
Given the SAS data set SASDATA.TWO:
SASDATA.TWO
X Y
-- __
5 2
5 4
3 6
The following SAS program is
submitted:
data sasuser.one one sasdata.three;
set sasdata two;
if x = 5 then output sasuser.one;
else output sasdata three;
run;
What is the result?
A - The data set SASUSER.ONE has 0
observations, the data set ONE has 0 observations, and
the data set SASDATA.THREE has 0
observations.
B - The data set SASUSER.ONE has 2
observations, the data set ONE has 0 observations, and
the data set SASDATA.THREE has 1
observation.
C - The data set SASUSER.ONE has 2
observations, the data set ONE has 3 observations, and
the data set SASDATA.THREE has 1
observation.
D - No data sets are output. The
DATA step fails execution due to errors.
Answer: B
Question: 5
The following SAS program is
submitted:
footnote 1 ‘Sales Report for Last
Month’;
footnote2 ‘Selected Products Only’;
footnote3 ‘All Regions’;
footnote4 ‘All Figures in Thousands
of Dollars’;
proc print data = sasuser.shoes;
footnote2 ‘All Products’;
run;
Which footnote(s) is/are displayed
in the report?
A - All Products
B - Sales Report for Last Month All
Products
C - All Products All Regions All
Figures in Thousands of Dollars
D - Sales Report for Last Month All
Products All Regions All Figures in Thousands of Dollars
Answer: B
Question: 6
Given the raw data record DEPT:
----|----10---|----20---|----30
Printing 750
The following SAS program is
submitted:
data bonus;
infile ‘dept’;
inputdept$ 1-11 number 13- 15;
<insert statement here>
run;
Which SAS statement completes the
program and results in a value of ‘Printing750’ for the
DEPARTMENT variable?
A - department = dept II number;
B - department = left(dept) II
number;
C - department = trim(dept) number;
D - department = trim(dept)
put(number,3.);
Answer: D
Question: 7
The following SAS program is
submitted:
data one;
addressl = ‘214 London Way’;
run;
data one;
set one;
address = tranwrd(address1, ‘Way’,
‘Drive’); run;
What are the length and value of the
variable ADDRESS?
A - Length is 14; value is ‘214
London Dri’.
B - Length is 14; value is ‘214
London Way’.
C - Length is 16; value is ‘214
London Drive’.
D - Length is 200; value is ‘214
London Drive’.
Answer: D
Question: 8
The following SAS program is
submitted:
data work.sets;
do until (prod gt 6);
prod + 1;
end;
run;
What is the value of the variable
PROD in the output data set?
A - 6
B - 7
C - 8
D - (missing numeric)
Answer: B
Question: 9
Given the SAS data sets EMPLOYEE and
SALARY:
EMPLOYEE SALARY
Fname age name salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is
submitted:
data work.empdata;
<insert MERGE statement here>
by fname;
totsal + salary;
run;
Which MERGE statement correctly
completes the program?
A - merge employee
salary rename = fname = name;
B - merge employee
salary rename(name = fname);
C - merge employee
salary (rename = (fname = name));
D - merge employee
salary (rename = (name = fname));
Answer: D
Question: 10
Which program displays a listing of
all data sets in the SASUSER library?
A - proc contents lib = sasuser.all;
run;
B - proc contents data =
sasuser.all; run;
C - proc contents lib =
sasuser._alI_; run;
D - proc contents data =
sasuser._all_; run;
Answer: D
Contact
Details :
K.Naveen SAS Trainer
+91-9177856619 (INDIA)
001-214-347-4655 (USA)
For further details:
www.sasonlinetraining.training
No comments:
Post a Comment