Our pass rate is high to 98.9% and the similarity percentage between our A00-212 study guide and real exam is 90% based on our seven-year educating experience. Do you want achievements in the SAS Institute A00-212 exam in just one try? I am currently studying for the SAS Institute A00-212 exam. Latest SAS Institute A00-212 Test exam practice questions and answers, Try SAS Institute A00-212 Brain Dumps First.

Q49. CORRECT TEXT 

The SAS data set WORK.TEMPDATA contains the variables FMTNAME, START and 

The following SAS program is submitted: 

Proc format cntlin=wor.tempdata; 

Run; 

What is the result of submitting the FORMAT procedure step? 

Answer: 

It uses the WORK.TEMPDATA SAS data set as input to create the format 

All formats created will be stored in two WORK.TEMPDATA SAS data set 

An ERROR message is written to the SAS log because the program is incomplete 

NO formats are created in this step A 


Q50. The following SAS FORMAT procedure is submitted: 

proc format lib = sasuser; 

value tempc low < 0 = 'BELOW FREEZING' 

0 < 5 = 'COLD' 

5 < 10 = 'MILD' 

10 < 15 = 'WARM' 

15 high = 'HOT' 

run; 

How is the value 10 displayed when the format TEMPC is applied? 

A. 10 

B. MILD 

C. WARM 

D. BELOW FREEZING 

Answer:


Q51. The following SAS program is submitted: 

%let lib=%upcase(sauser); proc sql; 

select nvar form dictionary.tables where libname='&lib"; quit; 

Several SAS data sets exist in the SAUSER library. 

What is generated as output? 

A. A report showing the names of the columns in each table in SASUSER 

B. A report showing the number of columns in each table in SASUSER 

C. A report showing the numeric columns in each table in SASUSER 

D. A report showing the number of numeric columns in each table in SASUSER 

Answer:


Q52. Given the SAS data set SAUSER.HIGWAY: 

SASUSER.HIGHWAY 

The following SAS program is submitted: 

%macro highway; 

proc sql nonprint; 

%let numgrp=6; 

select distinct status into:group1-:group&numgrp from sasuser.highway; 

quit; 

%do i=1 %to &numgrp; 

proc print data =sasuser.highway; 

where status ="&&group&I"; 

run; 

%end; 

%mend; 

%highway 

How many reports are produced? 

A. 2 

B. 6 

C. 0 

D. 5 

Answer:


Q53. The following SAS program is submitted: 

%let var = chicago, 1; 

data a; 

var = 'new york, 2' 

newvar = %scan(&var,2,%str()); 

run; 

Which one of the following explains why the program fails to execute? 

A. The %STR() is invalid syntax. 

B. The %SCAN function does not exist. 

C. The %SCAN function has too many arguments. 

D. The macro variable VAR does not get created properly. 

Answer:


Q54. The following SAS program is submitted: 

%macro execute; 

<insert statement here> 

proc print data = sasuser.houses; 

run; 

%end; 

%mend; 

Which of the following completes the above program so that it executes on Tuesday? 

A. %if &sysday = Tuesday %then %do; 

B. %if &sysday = 'Tuesday' %then %do; 

C. %if "&sysday" = Tuesday %then %do; 

D. %if '&sysday' = 'Tuesday' %then %do; 

Answer:


Q55. The following SAS program is submitted. 

filename sales ('external-file1' 'external-file2'); 

data new; 

infile sales; 

input date date9. company $ revenue; 

run; 

Which one of the following is the result of including the FILENAME statement in this program? 

A. The FILENAME statement produces an ERROR message in the SAS log. 

B. The FILENAME statement associates SALES with external-file2 followed by external-file1. 

C. The FILENAME statement associates SALES with external-file1 followed by external-file2. 

D. The FILENAME statement reads record 1 from external-file 1, reads record 1 from external-file 2, and combines them into one record. 

Answer:


Q56. Given the non-indexed SAS data set TEMP: 

TEMP 

X Y 

P 52 

P 45 

A 13 

A 56 

R 34 

R 12 

R 78 

The following SAS program is submitted: 

Proc print data=temp; 

<insert By statement here? 

Run; 

Which by statement completes the program, create a listing report that is grouped by X and 

completes without errors? 

A. X; 

B. By X groupd; 

C. By X notsorted; 

D. By descending X; 

Answer: