EZ Study

Actuarial Biology Chemistry Economics Calculators Confucius Engineer
Physics
C.S.

SAS Programing Certification Exam
Practice Questions & Answer set-42

Practice Question 199

The following SAS program is submitted:

data work.staff;
JobCategory = 'FA';     JobLevel = '1';

JobCategory = JobCategory || JobLevel;     run;

Which one of the following is the value of the variable JOBCATEGORY in the output data set?

A. FA     B. FA1     C. FA 1     D. ' ' (missing character value)


Answer: A

Practice Question 200

The following SAS SORT procedure step generates an output data set:

proc sort data = sasuser.houses out = report;
Click to Get Those Highly Recommended SAS Programmers' Books
by style; run;
In which library is the output data set stored?

A. WORK     B. REPORT     C. HOUSES     D. SASUSER

Answer: A

Practice Question 201

A raw data record is shown below:

07Jan2002

Which one of the following informats would read this value and store it as a SAS date value?

A. date9.
B. ddmonyy9.
C. ddMMMyy9.
D. ddmmmyyyy9.


Answer: A

Practice Question 202

The contents of two SAS data sets named EMPLOYEE and SALARY are listed below: The following SAS program is submitted:

data work.empsalary;
merge work.employee (in = inemp)
work.salary (in = insal);
by name;
if inemp and insal;
run;
Employee

name age
----------
Bruce  30
Dan     35

Salary

name salary
-------------
Bruce 40000
Bruce 35000
Dan     37000
Dan    

How many observations will the data set WORK.EMPSALARY contain?


A. 2
B. 4
C. 5
D. 6

Answer: B

Related links:

Continue to SAS Practice Exam Question Answer Set-43   SAS interview Questions Answers
Back to SAS Practice Exam Question Answer Set-41   SAS Tutorial   Statistics Tutorial