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

Question : The following SAS program is submitted:
(_insert_ods_code_)
proc means data=SASUSER.SHOES;
where Product in ('Sandal' , 'Slipper' , 'Boot');
The following SAS program is submitted:
(_insert_ods_code_)
proc means data=SASUSER.SHOES;
where Product in ('Sandal' , 'Slipper' , 'Boot');


1. ods html open='sales.html';
ods html close;
2. ods file='sales.html' / html;
ods file close;
3. Access Mostly Uused Products by 50000+ Subscribers
ods html close;
4. ods file html='sales.html';
ods file close;

Correct Answer : Get Lastest Questions and Answer :

Explanation:





Question : Which of the following choices is an unacceptable ODS destination for producing output that can be
viewed in Microsoft Excel?


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


Correct Answer : Get Lastest Questions and Answer :

Explanation:





Question : Which statement describes a characteristic of the SAS automatic variable _ERROR_?


1. The _ERROR_ variable maintains a count of the number of data errors in a DATA step.
2. The _ERROR_ variable is added to the program data vector and becomes part of the data set being created.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The _ERROR_ variable contains the number of the observation that caused the data error.

Correct Answer : Get Lastest Questions and Answer :

Explanation:

Related Questions

---

Question :

The descriptor and data portions of the Work.Salaries data set are shown below.

Variable Type Len Pos
---------------------
name Char 8 0
salary Char 8 16
status Char 8 8


name status salary
----------------------
Liz S 15,600
Herman S 26,700
Marty S 35,000

The following SAS program is submitted:

proc print data=work.salaries; where 20000 > salary;run;

What is displayed in the SAS log after the program is executed?



1. A NOTE indicating that 1 observation is read.
2. A NOTE indicating that 0 observations were read
3. Access Mostly Uused Products by 50000+ Subscribers
4. An ERROR indicating that the WHERE clause operator requires compatible variables.


Question :

Which of the following statements is true when SAS encounters a syntax error in a DATA step?


1. The SAS log contains an explanation of the error.
2. The DATA step continues to execute and the resulting data set is complete.
3. Access Mostly Uused Products by 50000+ Subscribers
4. A note appears in the SAS log indicating that the incorrect statement was saved to a SAS data set for further examination.



Question :

Which TITLE statement would display JANE'S DOG as the text of the title?



1. title "JANE"S DOG";
2. title 'JANE"S DOG';
3. Access Mostly Uused Products by 50000+ Subscribers
4. title 'JANE' ' 'S DOG';



Question : The following SAS program is submitted:

data test;
input animal1 $ animal2 $ mlgrams1 mlgrams2;
cards;
hummingbird ostrich 54000.39 90800000.87;
run;
Which one of the following represents the values of each variable in the output data set?

1. animal1 animal2 mlgrams1 mlgrams2
hummingb ostrich 54000.39 90800000
2. animal1 animal2 mlgrams1 mlgrams2
hummingb ostrich 54000.39 90800000.87
3. Access Mostly Uused Products by 50000+ Subscribers
hummingbird ostrich 54000.39 90800000
4. animal1 animal2 mlgrams1 mlgrams2
hummingbird ostrich 54000.39 90800000.87


Question :The SAS data sets Work.Employee and Work.Salary are shown below.

Work.Employee
fname age
Bruce 30
Dan 40

Work.Salary
fname salary
Bruce 25000
Bruce 35000
Dan 25000
The following merged SAS data set is generated:

Work.Empdata
fname age totsal
Bruce 30 60000
Dan 40 25000
Which one of the following SAS programs created the merged data set?
a. data work.empdata;
merge work.employee
work.salary; by fname; if first.fname then totsal=0;
totsal+salary; if last.fname then output; run;
b. data work.empdata(drop=salary);
merge work.employee
work.salary; by fname;
if first.fname then totsal=0; totsal+salary; if last.fname then output; run;
c. data work.empdata; merge work.employee
work.salary(drop=salary);
by fname; if first.fname then total=0; totsal+salary; if last.fname then output; run;
d. data work.empdata; merge work.employee
work.salary; by fname; if first.fname then total+salary; run;

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


Question :
name age
Janice 10
Henri 11
Michele 11
Susan 12
The following SAS program is submitted using the Sasdata.Group data set as input:

libname sasdata 'SAS-data-library';
data group;
set sasdata.group;
file 'file-specification';
put name $15. @5 age 2.;
run;

Which one of the following describes the output created?

1. a raw data file only
2. a SAS data set named Group only
3. Access Mostly Uused Products by 50000+ Subscribers
4. The program fails execution due to errors.