SAS Institute A00-211 SAS Base Programming for SAS 9 Online Training
SAS Institute A00-211 Online Training
The questions for A00-211 were last updated at Nov 19,2024.
- Exam Code: A00-211
- Exam Name: SAS Base Programming for SAS 9
- Certification Provider: SAS Institute
- Latest update: Nov 19,2024
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?
- A . Num Char— —- 1 23
- B . Num Char— —- 1 231 77
- C . Num Char— —- 1 233 231 77
- D . No output is generated.
The following SAS program is submitted:
data temp.x;
set sasuser.y;
run;
What must be submitted prior to this SAS program for the program to execute successfully?
- A . A LIBNAME statement for the libref TEMP only must be submitted.
- B . A LIBNAME statement for the libref SASUSER only must be submitted.
- C . LIBNAME statements for the librefs TEMP and SASUSER must be submitted.
- D . No LIBNAME statement needs to be submitted.
The value 110700 is stored in a numeric variable named SALARY.
Which FORMAT statement displays the value as $110,700.00 in a report?
- A . format salary comma11.2;
- B . format salary dollar8.2;
- C . format salary dollar11.2;
- D . format salary comma8.2 dollar8.2;
The following SAS program is submitted:
proc format
value score 1 – 50 = ‘Fail’
51 – 100 = ‘Pass’;
run;
proc report data = work.courses nowd;
column exam;
define exam / display format = score.;
run;
The variable EXAM has a value of 50.5.
How will the EXAM variable value be displayed in the REPORT procedure output?
- A . Fail
- B . Pass
- C . 50.5
- D . . (missing numeric value)
The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department. The following SAS program is submitted:
Which statement is true?
- A . The by statement in the DATA step causes a syntax error.
- B . The statement Payroll+(MonthlyWageRate*12); in the data step causes a syntax error.
- C . The values of the variable Payroll represent the monthly total for each department in the WORK.SALARY data set.
- D . The values of the variable Payroll represent a monthly total for all values of WAGERATE in the WORK.SALARY data set.
Given the following raw data record:
07Jan2005
Which INFORMAT reads this raw data and stores it as a SAS date value?
- A . dmy9.
- B . date9.
- C . ddMMMyy9.
- D . ddmmmyyyy9.
The following SAS program is submitted:
data work.passengers;
if OrigPassengers = . then’
OrigPassengers = 100;
TransPassengers = 100;
OrigPassengers = .;
TotalPassengers = sum (OrigPassengers, TransPassengers) +0;
run;
What is the value of the TOTALPASSENGERS variable in the output data set?
- A . 0
- B . 100
- C . 200
- D . (missing numeric value)
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?
- A . 1
- B . 12
- C . Italy
- D . Russia
Given the SAS data set SASDATA TWO:
SASDATA TWO
XY
52
31
56
The following SAS program is submitted:
data sasuser.one two sasdata.three;
set sasdata two;
if x = 5 then output sasuser.one;
else output sasdata two;
run;
What is the result?
- A . data set SASUSER.ONE has 5 observationsdata set SASUSER.TWO has 5 observationsdata set WORK.OTHER has 3 observations
- B . data set SASUSER.ONE has 2 observationsdata set SASUSER.TWO has 2 observationsdata set WORK.OTHER has 1 observations
- C . data set SASUSER.ONE has 2 observationsdata set SASUSER.TWO has 2 observationsdata set WORK.OTHER has 5 observations
- D . No data sets are output.The DATA step fails execution due to syntax errors.
The following SAS program is submitted:
proc sort data = work.employee;
by descending fname;
proc sort data = work.salary;
by descending fname;
data work.empdata;
merge work.employee
work.salary;
by fname;
run;
Why does the program rail to execute?
- A . The SORT procedures contain invalid syntax.
- B . The merged data sets are not permanent SAS data sets.
- C . The RUN statement was omitted alter each or the SORT procedures.
- D . The data sets were not merged in the order by which they were sorted.
Latest A00-211 Dumps Valid Version with 270 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
