SASInstitute A00-202 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Data Access and Manipulation | - Data transformation and reshaping - Reading and combining SAS data sets - Data step processing and iterative processing |
| Advanced Data Handling Techniques | - Efficient data processing strategies - ARRAY processing - Hash objects and lookup tables |
| SQL Processing in SAS | - Joins and subqueries - SQL optimization basics - PROC SQL querying techniques |
| Macro Language Processing | - Dynamic code generation using macros - Macro variables and resolution - Macro programs and functions |
| Error Handling and Debugging | - Handling data errors and missing values - Log analysis and debugging techniques |
SASInstitute SAS advanced programming Sample Questions:
Question #1
The following SAS program is submitted:
%let a = cat;
%macro animal(a = frog);
%let a = bird; %mend; %animal(a = pig) %put a is &a; Which one of the following is written to the SAS log?
A. a is bird
B. a is cat
C. a is pig
D. a is &a
Question #2
The following SAS program is submitted:
data one;
do i = 1 to 10;
ptobs = ceil(ranuni(0) * totobs);
set temp point = ptobs
nobs = totobs;
output;
end;
stop;
run;
The SAS data set TEMP contains 2,500,000 observations. Which one of the following represents the possible values for PTOBS?
A. any integer between 1 and 10
B. any real number between 1 and 2,500,000
C. any integer between 1 and 2,500,000
D. any real number between 0 and 1
Question #3
Assume today is Tuesday, July 23, 2002. Which one of the following statements submitted at the beginning of a SAS session assigns the value Tuesday, July 23, 2002 to the macro variable START?
A. %let start = today(),weekdate.;
B. %let start = today(),format=weekdate.;
C. %let start = %sysfunc(%today(),weekdate.);
D. %let start = %sysfunc(today(),weekdate.);
Question #4
Given the following SAS data set ONE:
ONE DIVISION SALES
A 1234 A 3654 B 5678
The following SAS program is submitted:
data _null_; set one;
by division;
if first.division then
call symput('mfirst',sales);
if last.division then
call symput('mlast',sales);
run;
Which one of the following is the value of the macro variable MFIRST when the above program finishes execution?
A. 3654
B. 5678
C. 1234
D. null
Question #5
Which one of the following techniques concatenates data in SAS?
A. the INTERSECT operator in the SQL procedure
B. the DATA step with a COMBINE statement
C. the APPEND procedure
D. the DATA step with a MERGE statement
Solutions:
| Question #1 Correct Answer: B | Question #2 Correct Answer: C | Question #3 Correct Answer: D | Question #4 Correct Answer: B | Question #5 Correct Answer: C |
1056 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
