A00-211 Exam Questions
255 real A00-211 exam questions with expert-verified answers and explanations. Page 4 of 6.
- Question #151
After a SAS program is submitted, the following is written to the SAS log: 105 data january; 106 set allmonths(keep = product month num_sold cost); 107 if month = `Jan' then output...
- Question #152
The following SAS program is submitted: data combine; prefix='505'; middle='6465 `; end='09090'; <insert statement here>; run; Which statement successfully completes the program so...
- Question #153
The following SAS program is submitted: <insert ODS statement here> proc means data = sasuser.shoes; where product in (`Sandal' , `Slipper' , `Boot'); run; <insert ODS statement he...
- Question #154
Given the raw data file AMOUNT: ----I---- 10---I----20---I----30 $1,234 The following SAS program is submitted: data test; infile `amount'; input@1 salary 6.; if_error_then descrip...
- Question #155
Given the SAS data set PEPM.STUDENTS: PERM.STUDENTS NAME AGE --------- ------ Alfred 14 Alice13 Barbara13 Carol14 The following SAS program is submitted: libname perm `SAS data lib...
- Question #156
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...
- Question #157
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 dat...
- Question #158
Given the following code: proc print data=SASHELP.CLASS(firstobs=5 obs=15); where Sex='M'; run; How many observations will be displayed?
- Question #159
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...
- Question #160
Given the contents of the raw data file TYPECOLOR.DAT: The following SAS program is submitted: What are the values of the variables Type and Color?
- Question #161
The following SAS program is submitted: What new variables are created?
- Question #162
Given the raw data record in the file phone.txt: Which SAS statement completes the program and results in a value of "James Stevens" for the variableFullName?
- Question #163
Which statement specifies that records 1 through 10 are to be read from the raw data file customer.txt?
- Question #164
The following SAS program is submitted: What value will SAS assign to Pos?
- Question #165
Given the following raw data records in DATAFILE.TXT: Which output is correct based on the submitted program?
- Question #166
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 submi...
- Question #167
The following output is created by the FREQUENCY procedure: Which TABLES statement was used to completed the following program that produced the output? proc freq data=sales; <_ins...
- Question #168
The following SAS program is submitted: <_insert_ods_code_> proc means data=SASUSER.SHOES; where Product in ('Sandal' , 'Slipper' , 'Boot'); run; <_insert_ods_code_> Which ODS stat...
- Question #169
Given the following data step: After data step execution, what will data set WORK.GEO contain?
- Question #170
Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?
- Question #171
Which statement describes a characteristic of the SAS automatic variable _ERROR_?
- Question #172
The Excel workbook REGIONS.XLS contains the following four worksheets: EAST WEST NORTH SOUTH The following program is submitted: libname MYXLS 'regions.xls'; Which PROC PRINT step...
- Question #173
Given the data set WORK.EMPDATA: Which one of the following where statements would display observations with job titles containing the word 'Manager'?
- Question #174
The following SAS program is submitted: data WORK.DATE_INFO; X="01Jan1960" D; run; What variable X contains what value?
- Question #175
Given the SAS data set WORK.EMP_NAME: Given the SAS data set WORK.EMP_DEPT: The following program is submitted: How many observations are in data set WORK.ALL after submitting the...
- Question #176
The following program is submitted: proc contents data=_all_; run; Which statement best describes the output from the submitted program?
- Question #177
The following SAS program is submitted: How will the Exam variable value be displayed in the FREQ procedure output?
- Question #178
The following program is submitted: proc sort data=SASUSER.PROJECTS out=PSORT; by Code descending Date Cost; run; Which of the following is true concerning the submitted program?
- Question #179
The following code was modified to generate the results further below: proc format; value agegrp low-12 ='Pre-Teen' 13-high = 'Teen'; run; proc means data=SASHELP.CLASS; var Height...
- Question #180
The following SAS program is submitted: What types of variables are DayOfMonth, MonthOfYear, and Year?
- Question #181
The following SAS program is submitted: data ONE TWO SASUSER.TWO set SASUSER.ONE; run; Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?
- Question #182
Which statement is true concerning the SAS automatic variable _ERROR_?
- Question #183
Given the SAS data set WORK.TEMPS: The following program is submitted: Which output is correct?
- Question #184
The following SAS program is submitted: data WORK.ACCOUNTING; set WORK.DEPARTMENT; label Jobcode='Job Description'; run; Which statement is true about the output dataset?
- Question #185
The following output is created by the FREQUENCY procedure: Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?
- Question #186
Which is a valid LIBNAME statement?
- Question #187
The Excel workbook QTR1.XLS contains the following three worksheets: JAN FEB MAR Which statement correctly assigns a library reference to the Excel workbook?
- Question #188
The following SAS program is submitted: What is produced as output?
- Question #189
You're attempting to read a raw data file and you see the following messages displayed in the SAS Log: What does it mean?
- Question #190
The following SAS program is submitted: data stats; set revenue; array weekly{5} mon tue wed thu fri; total = weekly{i} * .25; output; end; run; Which one of the following DO state...
- Question #191
The following SAS program is submitted: data work.test; array agents{4} $ 12 sales1 - sales4; run; Which one of the following represents the variables that are contained in the out...
- Question #192
On which portion(s) of a SAS data set does the PRINT procedure report?
- Question #193
Which one of the following SAS procedures displays the data portion of a SAS data set?
- Question #194
The following SAS program is submitted: proc contents data = sasuser.airplanes; run; Which one of the following is produced as output?
- Question #195
A raw data file is listed below: --------10-------20-------30 John McCloskey 35 71 June Rosesette 10 43 Tineke Jones 9 37 The following SAS program is submitted using the raw data...
- Question #196
The SASDATA.BANKS data set has five observations when the following SAS program is submitted: libname sasdata 'SAS-data-library'; data allobs; set sasdata.banks; capital=0; do year...
- Question #197
The following SAS program is submitted: data allobs; set sasdata.origin (firstobs = 75 obs = 499); run; The SAS data set SASDATA.ORIGIN contains 1000 observations. How many observa...
- Question #198
The following SAS program is submitted: data _null_; set old (keep = prod sales1 sales2); file 'file-specification'; put sales1 sales2; run; Which one of the following default deli...
- Question #199
The contents of the raw data file TEAM are listed below: --------10-------20-------30 Janice 10 Henri 11 Michael 11 Susan 12 The following SAS program is submitted: data group; inf...
- Question #200
The contents of the SAS data set PERM.JAN_SALES are listed below: VARIABLE NAME TYPE idnum character variable sales_date numeric date value A comma delimited raw data file needs to...