A00-211 Exam Questions

The contents of the raw data file FURNITURE are listed below: --------10-------20-------30 chair,,table chair,couch,table The following SAS program is submitted: data stock; infile...

The following SAS program is submitted and reads 100 records from a raw data file: data work.total; infile 'file-specification' end = eof; input name $ salary; totsal + salary; run...

The following SAS program is submitted: libname rawdata1 'location of SAS data library'; filename rawdata2 'location of raw data file'; data work.testdata; infile input sales1 sale...

The following SAS program is submitted: proc print data = sasuser.houses; run; proc means data = sasuser.shoes; run; Which one of the following OPTIONS statements resets the page n...

Which one of the following is true of the SUM statement in a SAS DATA step program?

When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations: libname sasdata 'SAS-data-library'; options obs = 500; proc print data = sasd...

The contents of the raw data file AMOUNT are listed below: --------10-------20-------30 $1,234 The following SAS program is submitted: data test; infile 'amount'; input @1 salary 6...

The contents of the raw data file NAMENUM are listed below: --------10-------20-------30 Joe xx The following SAS program is submitted: data test; infile 'namenum'; input name $ nu...

Which one of the following is true when SAS encounters a data error in a DATA step?

The following SAS program is submitted: data work.totalsales (keep = monthsales{12} ); set work.monthlysales (keep = year product sales); array monthsales {12} ; do i=1 to 12; mont...

The following SAS program is submitted: data work.totalsales; set work.monthlysales(keep = year product sales); retain monthsales {12} ; array monthsales {12} ; do i = 1 to 12; mon...

The following SAS program is submitted: data work.january; set work.allmonths (keep = product month num_sold cost); if month = 'Jan' then output work.january; sales = cost * num_so...

The contents of the raw data file CALENDAR are listed below: --------10-------20-------30 01012000 The following SAS program is submitted: data test; infile 'calendar'; input @1 da...

The following SAS program is submitted: If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?

Given the contents of the raw data file 'EMPLOYEE.TXT' Which SAS informat correctly completes the program?

Given the SAS data set WORK.P2000: And the SAS data set WORK.P2008: The following output is desired: Which SAS program correctly combines the data?

The following SAS program is submitted: What is the value of the second variable in the data set WORK.AUTHORS?

After a SAS program is submitted, the following is written to the SAS log: What changes should be made to the KEEP statement to correct the errors in the LOG?

The following SAS program is submitted: Which statement is true about the output data set?

The following SAS program is submitted: What is the value of the variable Prod in the output data set?

The following SAS program is submitted: What is the result?

The following SAS program is submitted: Which statement is true about the output data set?

The following SAS program is submitted: How many raw data records are read during each iteration of the DATA step?

Given the SAS data set WORK.ONE: The following SAS program is submitted: The data set WORK.TWO is created, where Day would be 1 for Sunday, 2 for Monday, 3 for Tuesday, ... : Which...

Given the SAS data set WORK.ORDERS: The variable Order_id is numeric; Customer is character; and Ship_date is a numeric containing a SAS date value. A programmer would like to crea...

The following program is submitted: proc contents data=_all_; Which statement best describes the output from the submitted program?

The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char: The following SAS program is submitted: What is output?

The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of "Asking Price". Which SAS program temporarily replaces the label "Asking Pric...

The following GAS program is submitted: data work.empsalary; set work.people (in = inemp) work.money (in = insal); if insal and inemp; run; The SAS data set WORKPEOPLE has 5 observ...

The following SAS program is submitted: data work.accounting; set work.dept1 work.dept2; jobcode = `FA1'; length jobcode $ 8; run; A character variable named JOBCODE is contained i...

Given the SAS data set SASDATA.TWO: SASDATA.TWO XY ---- The following SAS program is submitted: data sasuser.one two sasdata.three; set sasdata two; if x = 5 then output sasuser.on...

The following SAS program is submitted: footnote 1 `Sales Report for Last Month'; footnote2 `Selected Products Only'; footnote3 `All Regions'; footnote4 `All Figures in Thousands o...

Given the raw data record DEPT: ----|----10---|----20---|----30 Printing 750 The following SAS program is submitted: data bonus; infile `dept'; inputdept$ 1-11 number 13- 15; <inse...

The following SAS program is submitted: data one; addressl = `214 London Way'; run; data one; set one; address = tranwrd(address1, `Way', `Drive'); run; What are the length and val...

The following SAS program is submitted: data work.sets; do until (prod gt 6); prod + 1; end; run; What is the value of the variable PROD in the output data set?

The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below: WORK.EMPLOYEE WORK.SALARY fname age name salary Bruce 30 Bruce 25000 Dan 40 Bruce 35000 Dan 25000 The following SAS...

Which program displays a listing of all data sets in the SASUSER library?

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

The following SAS program is submittad: data work.sales; do year = 1 to 5; do month=1 to 12; x+1; output end; end; run; How many observations are written the WORK SALES data set?

Given the following raw data record: ----I----10---I----20---I----30 son Travis, The following output is desired: Obs relation firstname 1 son Travis Which SAS program correctly re...

Read the table. The following SAS program is submitted: proc freq data = sales; <insert TABLES statement here> run; The following output is created by the FREQUENCY procedure: Whic...

The following SAS program is submitted: data one; date = `04juI2005'd; format date weekdate.; run; proc print data = one; run; What output is generated?

The following SAS program is submitted: data test; set sasuser.employees; if 2 le years_service le 10 then amount = 1000; else amount = 0; amount_per_year = years_service / amount...

Given the SAS data set PERM.STUDENTS: PERM.STUDENTS NAMEAGE ---------------- Alfred14 Alice13 Barbara13 Carol14 The following SAS program is submitted: libname perm `SAS data libra...

The following SAS program is submitted: data work.total; set work.salary(keep = department wagerate); by department; if first.department then payroll = 0; payroll + wagerate; if la...

Given the contents of the raw data file EMPLOYEE: ----|----10----|----20----|----30 Alan 19/2/2004 ACCT Rob 22/5/2004 MKTG MaryJane 14/3/2004 EDUC The following SAS program is subm...

The following SAS program is submitted: data test; infile `file specification'; input name $ amount@@; run; Which of the following is true?

Given the SAS data set QTR 1_REVENUE: destinationrevenue YYZ53634 FRA62129 FRA75962 RDU76254 YYZ82174 The following SAS program is submitted: proc sort data = qtr1_revenue; by dest...

The following SAS program is submitted: data numrecords; infile `file specification'; input@1 patient $15. relative$ 16-26@; if relative = `children' then input @54 diagnosis $15....

Given the SAS data set WORK.ONE: The following SAS program is submitted: Which report is produced?