A00-211 Exam Questions

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

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

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

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

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

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

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

Given the following code: proc print data=SASHELP.CLASS(firstobs=5 obs=15); where Sex='M'; run; How many observations will be displayed?

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

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?

The following SAS program is submitted: What new variables are created?

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?

Which statement specifies that records 1 through 10 are to be read from the raw data file customer.txt?

The following SAS program is submitted: What value will SAS assign to Pos?

Given the following raw data records in DATAFILE.TXT: Which output is correct based on the submitted program?

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

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

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

Given the following data step: After data step execution, what will data set WORK.GEO contain?

Which of the following choices is an unacceptable ODS destination for producing output that can be viewed in Microsoft Excel?

Which statement describes a characteristic of the SAS automatic variable _ERROR_?

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

Given the data set WORK.EMPDATA: Which one of the following where statements would display observations with job titles containing the word 'Manager'?

The following SAS program is submitted: data WORK.DATE_INFO; X="01Jan1960" D; run; What variable X contains what value?

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

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

The following SAS program is submitted: How will the Exam variable value be displayed in the FREQ procedure output?

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?

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

The following SAS program is submitted: What types of variables are DayOfMonth, MonthOfYear, and Year?

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?

Which statement is true concerning the SAS automatic variable _ERROR_?

Given the SAS data set WORK.TEMPS: The following program is submitted: Which output is correct?

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?

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?

Which is a valid LIBNAME statement?

The Excel workbook QTR1.XLS contains the following three worksheets: JAN FEB MAR Which statement correctly assigns a library reference to the Excel workbook?

The following SAS program is submitted: What is produced as output?

You're attempting to read a raw data file and you see the following messages displayed in the SAS Log: What does it mean?

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

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

On which portion(s) of a SAS data set does the PRINT procedure report?

Which one of the following SAS procedures displays the data portion of a SAS data set?

The following SAS program is submitted: proc contents data = sasuser.airplanes; run; Which one of the following is produced as output?

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

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

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

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

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

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