Here are the sample questions which will help you be familiar with SAS Certified Professional - Advanced Programming Using SAS 9.4 Delta (A00-234) exam style and structure. We encourage you to try our Demo SAS Advanced Programming Certification Practice Exam to measure your understanding of exam structure in an environment which simulates the SAS Advanced Programming Professional Delta Certification test environment.
To make your preparation more easy for SAS Advanced Programming Professional Delta (A00-234) exam, we strongly recommend you to use our Premium SAS Advanced Programming Certification Practice Exam. According to our survey with certified candidates, you can easily score 85% in your actual SAS Certification exam if you can score 100% in our premium SAS Advanced Programming Certification practice exams.
SAS A00-234 Sample Questions:
01. The following SAS program is submitted:
options __________;
%abc(work.look,Hello,There);
In the text box above, complete the options statement that will produce the following log messages:
M*****(ABC): title1 "Hello" ;
M*****(ABC): title2 "There" ;
M*****(ABC): proc print data=work.look ;
M*****(ABC): run ;
Solution: mprint
Determine whether the given solution is correct?
a) Correct
b) Incorrect
02. Open a new programming window to create ACT01.sas in c:\cert\programs.
Write a SAS program that will:
- Create output data set work.ACT01 using sashelp.pricedata as input.
- Use an array to increase the values of the price1 through price17 variables by 10%.
Run your program and troubleshoot as necessary. When you are finished with the project:
1. Ensure that you have saved your program as ACT01.sas in c:\cert\programs.
2. From the score.sas program, call the scoreit macro using ACT01 as the parameter: %scoreit(ACT01).
What is the value for Response in the SAS log?
Solution: All price values for all price1-through price17 will be increased by 10%. For example, price2 in observation 5 will now be 126.50. Arrays and do loops would be used in the program.
Determine whether the given solution is correct?
a) Correct
b) Incorrect
03. Given the following SAS data sets ONE and TWO:
The following SAS program is submitted creating the output table THREE:
data three;
merge one (in = in1) two (in = in2);
by num;
run;
Which one of the following SQL programs creates an equivalent SAS data set THREE?
a) proc sql; create table three as
select *
from one full join two
where one.num = two.num; quit;
b) proc sql; create table three as
select coalesce(one.num, two.num)
as NUM, char1, char2 from
one full join two where
one.num = two.num; quit;
c) proc sql; create table three as
select one.num, char1, char2
from one full join two on
one.num = two.num; quit;
d) proc sql; create table three as
select coalesce(one.num, two.num)
as NUM, char1, char2 from
one full join two on
one.num = two.num; quit;
04. Which statement correctly describes a SAS in-line view?
a) A SAS in-line view is a subquery in the HAVING clause.
b) A SAS in-line view is used to populate a SAS array from a SAS data set.
c) A SAS in-line view is a SAS data set that contains a compiled DATA step.
d) A SAS in-line view is a temporary table that exists only during the SQL procedure query execution.
05. Open a new programming window to create MAC01.sas in c:\cert\programs. Write a DATA step that reads only the first observation of the sashelp.cars data set and stores the value of the Make variable in a macro variable named CarMaker.
The macro variable must be defined from within the DATA Step. Run your program and troubleshoot as necessary. When you are finished with the project:
1. Ensure that you have saved your program as MAC01.sas in c:\cert\programs.
2. From the score.sas program, call the scoreit macro using MAC01 as the parameter: %scoreit(MAC01).
What is the value for Response in the SAS log?
Solution: The CarMaker macro variable will have a value of Acura. The program will include a symputx routine.
Determine whether the given solution is correct?
a) Correct
b) Incorrect
06. The SAS data set SASDATA.SALES has a simple index on the variable DATE and a variable named REVENUE with no index. In which one of the following SAS programs is the DATE index considered for use?
a) proc print data = sasdata.sales;
by date;
by date;
run;
b) proc print data = sasdata.sales;
where month(date) = 3;
run;
where month(date) = 3;
run;
c) data march;
set sasdata.sales;
set sasdata.sales;
if '01mar2002'd < date < '31mar2002'd;
run;
d) data march;
set sasdata.sales;
set sasdata.sales;
where date < '31mar2002'd or revenue > 50000;
run;
07. Open a new programming window to create SQL01.sas in c:\cert\programs.
Write an SQL query that will:
- Create output data set work.SQL01 using sashelp.cars as input.
- Compute the average MPG_City for each group of Make. Name the calculated variable AvgCityMPG.
- The output data should have 2 columns, Make and AvgCityMPG.
Run your program and troubleshoot as necessary. When you are finished with the project:
1. Ensure that you have saved your program as SQL01.sas in c:\cert\programs.
2. From the score.sas program, call the scoreit macro using SQL01 as the parameter: %scoreit(SQL01).
What is the value for Response in the SAS log?
Solution: An SQL query with a group by clause will be written. The AvgCityMPG for MAKE=MINI will be 26.5.
Determine whether the given solution is correct?
a) Correct
b) Incorrect
08. Which statement creates global macro variables and assigns null values to the variables?
a) %ADD
b) %GLOBAL
c) %LET
d) %NULL
09. A local permanent data set has the following characteristics:
- 80 character variables, length 200, storing 28 bytes of non-repeating characters
- 120 numeric variables, length 8, 14 digits
- 4000 observations
What is the best way to reduce the storage size of this data set?
a) Compress the data set with character compression
b) Reduce length of character variables to 28 bytes
c) Compress the data set with binary compression
d) Reduce length of character variables to 6 bytes
10. The following SAS program is submitted:
%macro mysum(n);
%if &n > 1 %then %eval(&n + %mysum(%eval(&n-1)));
%else &n;
%mend;
%put %mysum(4);
Which output is written to the log?
a) 7
b) 4+3+2+1
c) 10
d) A character operand was found in the %EVAL function or %IF condition where a numeric operand is required.
Answers:
| Question: 1 | Answer: a | Question: 2 | Answer: a |
| Question: 3 | Answer: d | Question: 4 | Answer: d |
| Question: 5 | Answer: a | Question: 6 | Answer: a |
| Question: 7 | Answer: a | Question: 8 | Answer: b |
| Question: 9 | Answer: b | Question: 10 | Answer: c |
Note: Please write us on feedback@analyticsexam.com if you find any data entry error in these SAS Advanced Programming Professional Delta (A00-234) sample questions.