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

Question :
Given the raw data file AMOUNT:
----I---- 10---I----20---I----30
$1,234
The following SAS program is submitted:
data test;
infile `amount';
input@1 salary 6.;
if_error_then description = `Problems';
else description = `No Problems';
run;
What is the result?


1. The value of the DESCRIPTION variable is No Probl.
2. The value of the DESCRIPTION variable is Problems.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The value of the DESCRIPTION variable can not be determined.

Correct Answer : Get Lastest Questions and Answer :

Explanation:




Question :
The following SAS program is submitted:
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department
then payroll = 0;
payroll + wagerate;
if last.department
run;
The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for
each of 5 departments.
What is the result?


1. The WORK.TOTAL data set contains 5 observations.
2. The WORKTDTAL data set contains 100 observations.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The program fails to execute due to errors.

Correct Answer : Get Lastest Questions and Answer :

Explanation:




Question :
The following SAS program is submitted;
data combine;
country = `Italy, Russia, ireland';
found = find(country, `i');
run;
What is the value of the variable FOUND in the output data set?


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

Correct Answer : Get Lastest Questions and Answer :

Explanation:

Related Questions

---

Question :The SAS data set WORK.ONE contains a numeric variable named Num ana character variable named
Char:
WORK.ONE
Num Char
------ ------
1 23
3 23
1 77
The following SAS program is submitted:
proc print data=WORK.ONE;
where Num='1';
run;
What is output?

1. Num Char
--- ----
1 23
2. Num Char
--- ----
1 23
1 77
3. Access Mostly Uused Products by 50000+ Subscribers
Num Char
----
1 23
3 23
1 77
4. No output is generated


Question :The following output is created by the FREQUENCY procedure:
Which TABLES statement was used to completed the following program that produced the output?
proc freq data=sales;
(_insert_code_)
run;

1. tables region product;
2. tables region,product
3. Access Mostly Uused Products by 50000+ Subscribers
4. tables region*product;



Question :Given the following data step:
After data step execution, what will data set WORK.GEO contain?


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



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;


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



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.