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

Question :

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


Correct Answer : Get Lastest Questions and Answer :

Explanation:





Question :
The following SAS program is submitted:
data WORK.DATE_INFO;
Day="01" ;
Yr=1960 ;
X=mdy(Day,01,Yr) ;
run;
What is the value of the variable X?


1. the numeric value 0
2. the character value "01011960"
3. Access Mostly Uused Products by 50000+ Subscribers
4. the step will not compile because of the character argument in the mdy function.

Correct Answer : Get Lastest Questions and Answer :

Explanation:







Question :

The following SAS program is submitted:
data WORK.AUTHORS;
array Favorites{3} $ 8 ('Shakespeare','Hemingway','McCaffrey');
run;
What is the value of the second variable in the dataset WORK.AUTHORS?


1. Hemingway
2. Hemingwa
3. Access Mostly Uused Products by 50000+ Subscribers
4. The program contains errors. No variables are created.

Correct Answer : Get Lastest Questions and Answer :

Explanation:

Related Questions

---

Question :

The following SAS program is submitted:
data work.company;
set work.dept1(keep = jobcode)
work.dept2(rename = (jcode = jobcode));
run;
Which one of the following is the result?


1. The variable JCODE is written to the output data set.
2. The variable JOBCODE is written to the output data set.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The program fails to execute due to errors.


Question :

The following SAS program is submitted:
data work.passengers;
if OrigPassengers = . then
OrigPassengers = 100;
TransPassengers = 100;
OrigPassengers = .;
NonPaying = 10;
TotalPassengers = sum (OrigPassengers, TransPassengers);
run;
Which one of the following is the value of the TOTALPASSENGERS variable in the output data set?




1. 100
2. 110
3. Access Mostly Uused Products by 50000+ Subscribers
4. . (missing numeric value)




Question :

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?


1. FA
2. FA1
3. Access Mostly Uused Products by 50000+ Subscribers
4. ' ' (missing character value)


Question :

The following SAS program is submitted:
data work.one;
x = 3;
y = 2;
z = x ** y;
run;
Which one of the following is the value of the variable Z in the output data set?



1. 6
2. 9
3. Access Mostly Uused Products by 50000+ Subscribers
4. The program fails to execute due to errors.


Question : The SAS data set named WORK.TEST is listed below:
capacity airplanetype staff
150 Large 10

Which one of the following SAS programs created this data set?
A. data work.test;
capacity = 150;
if 100 le capacity le 200 then
airplanetype = 'Large' and staff = 10;
else airplanetype = 'Small' and staff = 5; run;

B. data work.test;
capacity = 150;
if 100 le capacity le 200 then
do;
airplanetype = 'Large';
staff = 10;
end;
else
do;
airplanetype = 'Small';
staff = 5; end; run;

C. data work.test;
capacity = 150;
if 100 le capacity le 200 then
do;
airplanetype = 'Large';
staff = 10;
else
do;
airplanetype = 'Small';
staff = 5; end; run;

D. data work.test;
capacity = 150;
if 100 le capacity le 200 then;
airplanetype = 'Small';
staff = 5;
else;
airplanetype = 'Large'; staff = 10; run;




1. a
2. b
3. Access Mostly Uused Products by 50000+ Subscribers
4. d



Question :

The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below:
WORK.EMPLOYEE WORK.SALARY
fname age fname salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
merge work.employee
work.salary;
by fname;
totsal + salary;
run;
How many variables are output to the WORK.EMPDATA data set?



1. 3
2. 4
3. Access Mostly Uused Products by 50000+ Subscribers
4. No variables are output to the data set as the program fails to execute due to errors.