A00-211 Exam Questions
255 real A00-211 exam questions with expert-verified answers and explanations. Page 1 of 6.
- Question #1
Given the SAS data set AGES: AGES AGE --------- The variable AGE contains character values. The following SAS program is submitted: data subset; set ages; where age> 12; run; How m...
- Question #2
Given the SAS data set PRICES: PRICES prodid price K12S5.10producttype NETWORKsales 15returns B132S 2.34HARDWARE30010 R18KY21.29SOFTWARE255 3KL8BY 6.37HARDWARE12515 DY65DW 5.60HARD...
- Question #3
The following SAS program is submitted: data work.accounting; set work.department; length jobcode $ 12; jobcode='FAl'; run; The WORK.DEPARTMENT data set contains a character variab...
- Question #4
Which ODS statement option terminates output being written to an HTML rile?
- Question #5
Given the AIRPLANES data set AlRPLANES TYPE MPG -------- ------ F-18 105 C-130 25 Harrier 75 A-6 1 10 The following SAS program is submitted: data gt100; set airplanes(keep = type...
- Question #6
Given the raw data file EMPLOYEE: ----I----1 0---I----20---I----30 Ruth 39 11 Jose 32 22 Sue 30 33 John 40 44 The following SAS program is submitted: data test; infile `employee';...
- Question #7
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?
- Question #8
The data set RALESTATE has the variable LOCALFEE with a format or 9. and a variable COUNTRYFEE with a format or 7.; The following SAS program is submitted: data history; format loc...
- Question #9
The following SAS program is submitted: proc freq data = class; tables gender * age / <insert option here>; run; The following report is created: The FREQ Procedure Table of gender...
- Question #10
The value 110700 is stored in a numeric variable named SALARY. Which FORMAT statement displays the value as $110,700.00 in a report?
- Question #11
Given the raw data file YEARAMT: ----|---10---|---20---|----30 1901 2 1905 1 1910 6 1925 . 1941 1 The following SAS program is submitted: data coins; infile `yearamt'; input year q...
- Question #12
Given the SAS data set EMPLOYEE INFO: EMPLOYEE_INFO IDNumber Expenses 100.00 133.15 234.34 111.12 The following SAS program is submitted: proc sort data = employee_info; <insert BY...
- Question #13
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 for...
- Question #14
What is the purpose or the MISSOVER option on the INFILE statement?
- Question #15
The following SAS program is submitted: data work.test; set work.staff (keep = jansales febsales marsales); array diff_sales{3} difsales1 - difsales3; array monthly{3} jansales feb...
- Question #16
What describes the SAS automatic _ERRDR_ variable?
- Question #17
Given the following raw data record: 07Jan20 05 Which INFOFRMAT reads this raw data and stores it as a SAS date value?
- Question #18
Which statement correctly computes the average of four numerical values?
- Question #19
The following SAS program is submitted: libname temp `SAS data library'; data temp.sales; merge temp sales work.receipt; by names; run; The input data files are sorted by the NAMES...
- Question #20
Given the contents of the raw data file TYPECOLOR: ----I----10---I----20---I----30 Daisyyellow The following SAS program is submitted: data flowers; infile `typecolor'; input type$...
- Question #21
A user-defined format has been created using the FORMAT procedure. Where is it stored?
- Question #22
The following SAS program is submitted: data work.flights; destination = `cph'; select(destination); when('LHR') city = `London'; when('CPH') city = `Copenhagen'; otherwise city =...
- Question #23
The following SAS program is submitted: data work.new; length word $7; amount = 4; it amount = 4 then word = `FOUR'; else if amount = 7 then word = `SEVEN'; else word = `NONE!!!';...
- Question #24
The following SAS program is submitted, creating the SAS data set ONE: data one; infile `file specification'; input num chars$; run; ONE NUMCHAR ---------------- The following SAS...
- Question #25
The following SAS program is submitted: data work.retail; cost = `20000'; total= .10* cost run; What is the result?
- Question #26
The following SAS program is submitted: Data_null_; set old; put sales 1 sales2; run; Where is the output written?
- Question #27
The following SAS program is submitted: What will the data set WORK.TEST contain?
- Question #28
The following SAS program is submitted: data work.test; array items{3} _temporary_; run; What are the names of the variable(s) in the WORKTEST data set?
- Question #29
Given the SAS data set WORK.ONE: And the SAS data set WORK.TWO: The following program is submitted: What is the first observation in the SAS data set WORK.BOTH?
- Question #30
The following SAS program is submitted: data WORK.DATE_INFO; Day="01" ; Yr=1960 ; X=mdy(Day,01,Yr) ; run; What is the value of the variable X?
- Question #31
The following SAS program is submitted: data WORK.AUTHORS; array Favorites{3} $ 8 ('Shakespeare','Hemingway','McCaffrey'); run; What is the value of the second variable in the data...
- Question #32
The SAS data set Fed.Banks contains a variable Open_Date which has been assigned a permanent label of "Open Date". Which SAS program temporarily replaces the label "Open Date" with...
- Question #33
Consider the following data step: In filtering the values of the variable X in data set WORK.OLD, what value new value would be assigned to X if its original value was a missing va...
- Question #34
The following program is submitted: Why does the program fail?
- Question #35
Given the SAS data set WORK.PRODUCTS: How many observations does the WORK.OUTDOOR data set contain?
- Question #36
Consider the following data step: data WORK.NEW; set WORK.OLD; Count+1; run; The varaible Count is created using a sum statement. Which statement regarding this variable is true?
- Question #37
Given the following raw data records in TEXTFILE.TXT: The following output is desired: Which SAS program correctly produces the desired output?
- Question #38
Given the SAS data set WORK.PRODUCTS: How many variables does the WORK.REVENUE data set contain?
- Question #39
The following SAS program is submitted: What is the initial value of the variable Total in the following program?
- Question #40
The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.; The following SAS program is submitted: What are the forma...
- Question #41
Given the following raw data records: The following output is desired: Which SAS program correctly reads in the raw data?
- Question #42
Which of the following programs correctly invokes the DATA Step Debugger?
- Question #43
Which step sorts the observations of a permanent SAS data set by two variables and stores the sorted observations in a temporary SAS data set?
- Question #44
Consider the data step: Which of the following assignment statements for variable group are functionally equivalent to the original statement used in the above data step?
- Question #45
The following SAS program is submitted: data WORK.ACCOUNTING; set WORK.DEPARTMENT; length EmpId $6; CharEmpid=EmpId; run; If data set WORK.DEPARTMENT has a numeric variable EmpId....
- Question #46
The following SAS program is submitted: data WORK.OUTDS; do until(Prod GT 6); Prod + 1; end; run; What is the value of the variable Prod in the output data set?
- Question #47
The following SAS program is submitted: The SAS data set WORK.SALARY is currently ordered by Gender within Department. Which inserted code will accumulate subtotals for each Gender...
- Question #48
Which step displays a listing of all the data sets in the WORK library?
- Question #49
Given the SAS data set WORK.ORDERS: The variable order_id is numeric; customer is character; and shipped is numeric, contains a SAS date value, and is shown with the DATE9. format....
- Question #50
After a SAS program is submitted, the following is written to the SAS log: 105 data WORK.JANUARY; 106 set WORK.ALLYEAR(keep=Product Month Quantity Cost); 107 if Month='JAN' then ou...