A00-201 Exam Questions

Which one of the following is needed to display the standard deviation with only two decimal places? proc means data = sasuser.houses std mean max; var sqfeet; run;

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

The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments. Which one of the following represents how many observations the...

Which one of the following is the value of the variable TOTAL in the output data set? data work.retail; cost = '20000'; total = .10 * cost; run;

A value for the variable JOBCODE is listed below: JOBCODE CHEM3 Which one of the following values does the variable DESCRIPTION contain? libname sasdata 'SAS-data-library'; data te...

Which one of the following represents the type and length of the variable DATE in the output data set? data work.month; date = put('13mar2000'd,ddmmyy10.); run;

7: The SAS data set QTR1_REVENUE is listed below: destination revenue TYS 53634 FRA 62129 ZZA 82129 RDU 75962 XYZ 82174 The following SAS program is submitted: proc sort data = qtr...

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

9: 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;...

10: The following SAS program is submitted: data work.new; length word $7; amount = 4; if amount = 4 then word = 'FOUR'; else if amount = 7 then word = 'SEVEN'; else word = 'NONE!!...

11: Click the Exhibit button to view a listing of the SASUSER.HOUSES data set. The following SAS program is submitted: proc report data = sasuser.houses nowd headline; column style...

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

13: 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?

14: The following SAS program is submitted: libname rawdata1 'location of SAS data library'; filename rawdata2 'location of raw data file'; data work.testdata; infile <insert item...

15: 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?

Which one of the following informat's would read this value and store it as a SAS date value?

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

A raw data record is listed below: ----|----10----|----20----|----30 Printing 750 The following SAS program is submitted: data bonus; infile 'file-specification'; input dept $ 1 -...

The contents of two SAS data sets named EMPLOYEE and SALARY are listed below: EMPLOYEE name age Bruce 30 Dan 35 SALARY name salary Bruce 40000 Bruce 35000 Dan 37000 Dan . The follo...

Which one of the following statements is true regarding the naming of a SAS array?

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

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

The following SAS program is submitted: data work.report; set work.sales_info; if qtr(sales_date) ge 3; run; The SAS data set WORK.SALES_INFO has one observation for each month in...

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?

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

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

The contents of the raw data file PRODUCT are listed below: ----|----10----|----20----|----30 24613 $25.31 The following SAS program is submitted: data inventory; infile 'product';...

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

How many raw data records are read during each iteration of the DATA step during execution?

The SAS data set WORK.PEOPLE has 5 observations, and the data set WORK.MONEY has 7 observations. How many observations will the data set WORK.EMPSALARY contain?

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

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

The SAS data set SASDATA.ORIGIN contains 1000 observations. How many observations does the ALLOBS data set contain?

June Rossette 10 43 Tineke Jones 9 37 The following SAS program is submitted using the raw data file as input: data work.homework; infile 'file-specification'; input name $ age hei...

The following SAS program is submitted: <insert ODS statement here> proc means data = sasuser.shoes; where product in ('Sandal', 'Slipper', 'Boot'); run; Which one of the following...

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 following SAS program is submitted: data _null_; set old; put sales1 sales2; run; Where is the output written?

When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations: How many observations are processed by each procedure?

Which one of the following ODS statement options terminates output being written to an HTML file?

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

years for a total of 60 observations. Which one of the following is the result of the above program?

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

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

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

Which one of the following SAS system options displays the time on a report?

The following SAS program is submitted: proc sort data = sasuser.houses out = houses; by style; run; proc print data = houses; <insert statement(s) here> run; Click on the Exhibit...

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

Which one of the following SAS statements correctly computes the average of four numerical values?

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

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?