A00-211 Exam Questions

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...

Given the SAS data set PRICES: PRICES prodid price K12S5.10producttype NETWORKsales 15returns B132S 2.34HARDWARE30010 R18KY21.29SOFTWARE255 3KL8BY 6.37HARDWARE12515 DY65DW 5.60HARD...

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...

Which ODS statement option terminates output being written to an HTML rile?

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...

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';...

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?

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...

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...

The value 110700 is stored in a numeric variable named SALARY. Which FORMAT statement displays the value as $110,700.00 in a report?

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...

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...

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...

What is the purpose or the MISSOVER option on the INFILE statement?

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...

What describes the SAS automatic _ERRDR_ variable?

Given the following raw data record: 07Jan20 05 Which INFOFRMAT reads this raw data and stores it as a SAS date value?

Which statement correctly computes the average of four numerical values?

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...

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$...

A user-defined format has been created using the FORMAT procedure. Where is it stored?

The following SAS program is submitted: data work.flights; destination = `cph'; select(destination); when('LHR') city = `London'; when('CPH') city = `Copenhagen'; otherwise city =...

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!!!';...

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...

The following SAS program is submitted: data work.retail; cost = `20000'; total= .10* cost run; What is the result?

The following SAS program is submitted: Data_null_; set old; put sales 1 sales2; run; Where is the output written?

The following SAS program is submitted: What will the data set WORK.TEST contain?

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?

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?

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?

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...

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...

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...

The following program is submitted: Why does the program fail?

Given the SAS data set WORK.PRODUCTS: How many observations does the WORK.OUTDOOR data set contain?

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?

Given the following raw data records in TEXTFILE.TXT: The following output is desired: Which SAS program correctly produces the desired output?

Given the SAS data set WORK.PRODUCTS: How many variables does the WORK.REVENUE data set contain?

The following SAS program is submitted: What is the initial value of the variable Total in the following program?

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...

Given the following raw data records: The following output is desired: Which SAS program correctly reads in the raw data?

Which of the following programs correctly invokes the DATA Step Debugger?

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?

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?

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....

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?

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...

Which step displays a listing of all the data sets in the WORK library?

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....

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...