Base SAS Certified Associate: Programming Fundamentals Using SAS Questions and Answers (Dumps and Practice Questions)

Question :

The SAS data set Employee_info is listed below.

employee bonus
2542 100.00
3612 133.15
2198 234.34
2198 111.12
The following SAS program is submitted:

proc sort data=employee_info;
(insert BY statement here)
run;

Which one of the following BY statements completes the program and sorts the data in sequential order bydescending bonus values within ascending employee values?



1. by descending bonus employee;
2. by employee bonus descending;
3. Access Mostly Uused Products by 50000+ Subscribers
4. by descending employee bonus;

Correct Answer : Get Lastest Questions and Answer :

Explanation: You use the keyword DESCENDING in a BY statement to specify that data will be sorted by values in descending order. The DESCENDING keyword applies to the variable that is
listed immediately after it. To sort on values of bonus within sorted values of employee, you list employee first in the BY statement.






Question :

Assume the SAS data set Sasuser.Houses has four numeric variables.
The following SAS program is submitted:

proc means data=sasuser.houses mean;
(insert statement(s) here)run;
The following report is produced:
Which of the following statement(s) create(s) this report?

1. class style;
2. var bedrooms baths;
3. Access Mostly Uused Products by 50000+ Subscribers
var bedrooms baths;
4. . var style;
class bedrooms baths;

Correct Answer : Get Lastest Questions and Answer :

Explanation: The CLASS statement specifies the category variable(s) for group processing. The VAR
statement specifies the numeric variable(s) for which to calculate statistics.






Question :

The following SAS program is submitted:

data work.accounting; length jobcode $ 12; set work.department;run;

The Work.Department SAS data set contains a character variable named jobcode with a length of 5. Which of the following is the length of the variable jobcode in the output data set?

1. 5
2. 8
3. Access Mostly Uused Products by 50000+ Subscribers
4. The value cannot be determined because the program fails to execute due to syntax errors.

Correct Answer : Get Lastest Questions and Answer :

Explanation: The LENGTH statement enables you to specify the length of a character variable. Since the LENGTH statement appears before the SET statement, SAS will set the length of jobcode
to 12.

Related Questions

---

Question : The following SAS program is submitted:

data one;
date = '04juI2014'd;
format date weekdate.; run;
proc print data = one; run;

What output is generated?

1. Obs date
1 Monday, July 4, 2014
2. Obs date
1 July4, 2014
3. Access Mostly Uused Products by 50000+ Subscribers
1 04Jul2014
4. Obs date
1 Monday, 07/04/2014


Question : Given the SAS data set PERM.STUDENTS:

PERM.STUDENTS NAME AGE
----------------
Allen 14
Alina 13
Babita 13
Kavel 14

The following SAS program is submitted:

libname perm `SAS data library';
data students;
set perm.students;
file `file specification';
put name $ age;
(insert statement here)
run;

The following double-spaced file is desired as output
Allen 14
Alina 13
Babita 13
Kavel 14

Which statement completes the program and creates the desired file?

1. put
2. put/;
3. Access Mostly Uused Products by 50000+ Subscribers
4. put _null_;


Question : For the first observation, what is the value of diff{i}
at the end of the second iteration of the DO loop?

array wt{*} obs1-obs10;
array diff{9};
do i=1 to 9;
diff{i}=wt{i+1}-wt{i};
end;


1. 15
2. 10
3. Access Mostly Uused Products by 50000+ Subscribers
4. -7



Question : Finish the ARRAY statement below to create temporary array elements that have initial values of , , , and . array goal{} ... ;


1. _temporary_ (8000 8300 8600 8900)
2. temporary (8000 8300 8600 8900)
3. Access Mostly Uused Products by 50000+ Subscribers
4. (temporary) 8000 8300 8600 8900


Question : Based on the ARRAY statement below, select the array reference for the array element hadoop. array hadoopexam{,} hadoop-hadoop;

1. hadoopexam{hadoop50}
2. hadoopexam{1,50}
3. Access Mostly Uused Products by 50000+ Subscribers
4. hadoopexam{3,0}


Question :

Given the contents of the raw data file EMPLOYEE:
----|----10----|----20----|----30
Amit
19/2/2004
ACCT
Rohit
22/5/2004
MKTG
Manglesh
14/3/2004
EDUC
The following SAS program is submitted:

data emps;
infile 'employee';
input@1 name$
@15 date (insert INFORMAT here)
@25 department$;
run;

Which INFORMAT correctly completes the program?


1. date9
2. ddmmyyyy9
3. Access Mostly Uused Products by 50000+ Subscribers
4. ddmmyyyy10