A00-211 Exam Questions
255 real A00-211 exam questions with expert-verified answers and explanations. Page 2 of 6.
- Question #51
Consider the following data step: The computed variables City and State have their values assigned using two different methods, a RETAIN statement and an Assignment statement. Whic...
- Question #52
Given the SAS data set WORK.ONE: What value will SAS assign to Total?
- Question #53
A SAS program is submitted and the following SAS log is produced: 2 data gt100; 3 set ia.airplanes 4 if mpg gt 100 then output; 22 202 ERROR: File WORK.IF.DATA does not exist. ERRO...
- Question #54
The contents of the raw data file SIZE are listed below: --------10-------20-------30 72 95 The following SAS program is submitted: data test; infile 'size'; input @1 height 2. @4...
- Question #55
A SAS PRINT procedure output of the WORK.LEVELS data set is listed below: Obs name level 1 Frank 1 2 Joan 2 3 Sui 2 4 Jose 3 5 Burt 4 6 Kelly . 7 Juan 1 The following SAS program i...
- Question #56
The contents of the raw data file EMPLOYEE are listed below: --------10-------20-------30 Ruth 39 11 Jose 32 22 Sue 30 33 John 40 44 The following SAS program is submitted: data te...
- Question #57
The following SAS program is submitted: libname sasdata 'SAS-data-library'; data test; set sasdata.chemists; if jobcode = 'chem3' then description = 'Senior Chemist'; else descript...
- Question #58
The following SAS program is submitted: options pageno = 1; proc print data = sasuser.houses; run; proc means data = sasuser.shoes; run; The report created by the PRINT procedure s...
- Question #59
Which one of the following SAS system options displays the time on a report?
- Question #60
Which one of the following SAS system options prevents the page number from appearing on a report?
- Question #61
The following SAS program is submitted: data work.new; length word $7; amount = 7; if amount = 5 then word = 'CAT'; else if amount = 7 then word = 'DOG'; else word = 'NONE!!!'; amo...
- Question #62
The following SAS program is submitted: proc means data = sasuser.houses std mean max; var sqfeet; run; Which one of the following is needed to display the standard deviation with...
- Question #63
Unless specified, which variables and data values are used to calculate statistics in the MEANS procedure?
- Question #64
The following SAS program is submitted: proc sort data = sasuser.houses out = houses; by style; run; proc print data = houses; run; Click on the Exhibit button to view the report p...
- Question #65
A realtor has two customers. One customer wants to view a list of homes selling for less than $60,000. The other customer wants to view a list of homes selling for greater than $10...
- Question #66
The SAS data set BANKS is listed below: BANKS name rate FirstCapital 0.0718 DirectBank 0.0721 VirtualDirect 0.0728 The following SAS program is submitted: data newbank; do year = 1...
- Question #67
The following SAS program is submitted: data work.clients; calls = 6; do while (calls le 6); calls + 1; end; run; Which one of the following is the value of the variable CALLS in t...
- Question #68
The following SAS program is submitted: data work.pieces; do while (n lt 6); n + 1; end; run; Which one of the following is the value of the variable N in the output data set?
- Question #69
A raw data record is listed below: --------10-------20-------30 1999/10/25 The following SAS program is submitted: data projectduration; infile 'file-specification'; input date $ 1...
- Question #70
The following SAS program is submitted: data work.month; date = put('13mar2000'd,ddmmyy10.); run; Which one of the following represents the type and length of the variable DATE in...
- Question #71
The following SAS program is submitted: data work.month; date = input('13mar2000',date9.); run; Which one of the following represents the type and length of the variable DATE in th...
- Question #72
The following SAS program is submitted: data work.products; Product_Number = 5461; Item = '1001'; Item_Reference = Item'/'Product_Number; run; Which one of the following is the val...
- Question #73
The following SAS program is submitted: data work.retail; cost = '20000'; total = .10 * cost; run; Which one of the following is the value of the variable TOTAL in the output data...
- Question #74
The following SAS program is submitted: data work.test; Author = 'Agatha Christie'; First = substr(scan(author,1,' ,'),1,1); run; Which one of the following is the length of the va...
- Question #75
The following SAS program is submitted: data work.test; Author = 'Christie, Agatha'; First = substr(scan(author,2,' ,'),1,1); run; Which one of the following is the value of the va...
- Question #76
The following SAS program is submitted: data work.test; Title = 'A Tale of Two Cities, Charles J. Dickens'; Word = scan(title,3,' ,'); run; Which one of the following is the value...
- Question #77
The following SAS program is submitted: data work.test; First = 'Ipswich, England'; City_Country = substr(First,1,7)!!', '!!'England'; run; Which one of the following is the length...
- Question #78
The following SAS program is submitted: data work.test; First = 'Ipswich, England'; City = substr(First,1,7); City_Country = City!!', '!!'England'; run; Which one of the following...
- Question #79
Which one of the following is true of the RETAIN statement in a SAS DATA step program?
- Question #80
A raw data file is listed below: --------10-------20-------30 squash 1.10 apples 2.25 juice 1.69 The following SAS program is submitted using the raw data file above: data grocerie...
- Question #81
The following SAS program is submitted: libname sasdata 'SAS-data-library'; data test; set sasdata.chemists (keep = job_code); if job_code = 'chem3' then description = 'Senior Chem...
- Question #82
The following SAS DATA step is submitted: data work.accounting; set work.department; length jobcode $ 12; run; The WORK.DEPARTMENT SAS data set contains a character variable named...
- Question #83
Which one of the following SAS statements renames two variables?
- Question #84
The following SAS program is submitted: data work.company; set work.dept1(keep = jobcode) work.dept2(rename = (jcode = jobcode)); run; Which one of the following is the result?
- Question #85
The following SAS program is submitted: data work.staff; JobCategory = 'FA'; JobLevel = '1'; JobCategory = JobCategory || JobLevel; run; Which one of the following is the value of...
- Question #86
The following SAS program is submitted: data work.one; x = 3; y = 2; z = x ** y; run; Which one of the following is the value of the variable Z in the output data set?
- Question #87
The SAS data set named WORK.TEST is listed below: capacity airplanetype staff 150 Large 10 Which one of the following SAS programs created this data set?
- Question #88
The SAS data set EMPLOYEE_INFO is listed below: IDNumber Expenses 2542 100.00 3612 133.15 2198 234.34 2198 111.12 The following SAS program is submitted: proc sort data = employee_...
- Question #89
The following SAS program is submitted: libname company 'SAS-data-library'; proc sort data = company.payroll; by EmployeeIDNumber; run; Write access has been granted to the COMPANY...
- Question #90
The SAS data set WORK.AWARDS is listed below: fname points Amy 2 Amy 1 Gerard 3 Wang 3 Wang 1 Wang 2 The following SAS program is submitted: proc sort data = work.awards; by descen...
- Question #91
The observations in the SAS data set WORK.TEST are ordered by the values of the variable SALARY. The following SAS program is submitted: proc sort data = work.test out = work.tests...
- Question #92
Which one of the following statements is true regarding the name of a SAS array?
- Question #93
The following SAS DATA step is submitted: data sasdata.atlanta sasdata.boston work.portland work.phoenix; set company.prdsales; if region = 'NE' then output boston; if region = 'SE...
- Question #94
Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?
- Question #95
The following SAS DATA step is submitted: libname temp 'SAS-data-library'; data temp.report; set sasuser.houses; newvar = price * 1.04; run; Which one of the following statements i...
- Question #96
The following SAS SORT procedure step generates an output data set: proc sort data = sasuser.houses out = report; by style; run; In which library is the output data set stored?
- Question #97
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below: WORK.EMPLOYEE WORK.SALARY fname age fname salary Bruce 30 Bruce 25000 Dan 40 Bruce 35000 Dan 25000 The following S...
- Question #98
The contents of two SAS data sets named EMPLOYEE and SALARY are listed below: EMPLOYEE SALARY name age name salary Bruce 30 Bruce 40000 Dan 35 Bruce 35000 Dan 37000 Dan . The follo...
- Question #99
A raw data file is listed below: RANCH,1250,2,1,Sheppard Avenue,"$64,000" SPLIT,1190,1,1,Rand Street,"$65,850" CONDO,1400,2,1.5,Market Street,"80,050" TWOSTORY,1810,4,3,Garris Stre...
- Question #100
A raw data file is listed below: RANCH,1250,2,1,Sheppard Avenue,"$64,000" SPLIT,1190,1,1,Rand Street,"$65,850" CONDO,1400,2,1.5,Market Street,"80,050" TWOSTORY,1810,4,3,Garris Stre...