A00-201 Exam Questions
115 real A00-201 exam questions with expert-verified answers and explanations. Page 1 of 3.
- Question #1
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;
- Question #2
Which one of the following is true when SAS encounters a data error in a DATA step?
- Question #3
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...
- Question #4
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;
- Question #5
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...
- Question #6
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;
- Question #7
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...
- Question #8
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...
- Question #9
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;...
- Question #10
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!!...
- Question #11
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...
- Question #12
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...
- Question #13
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?
- Question #14
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...
- Question #15
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?
- Question #16
Which one of the following informat's would read this value and store it as a SAS date value?
- Question #17
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 #18
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 -...
- Question #19
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...
- Question #20
Which one of the following statements is true regarding the naming of a SAS array?
- Question #21
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...
- Question #22
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...
- Question #23
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...
- Question #24
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 #25
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...
- Question #26
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 #27
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';...
- Question #28
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 #29
How many raw data records are read during each iteration of the DATA step during execution?
- Question #30
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?
- Question #31
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 #32
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 #33
The SAS data set SASDATA.ORIGIN contains 1000 observations. How many observations does the ALLOBS data set contain?
- Question #34
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...
- Question #35
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...
- Question #36
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 #37
The following SAS program is submitted: data _null_; set old; put sales1 sales2; run; Where is the output written?
- Question #38
When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations: How many observations are processed by each procedure?
- Question #39
Which one of the following ODS statement options terminates output being written to an HTML file?
- Question #40
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...
- Question #41
years for a total of 60 observations. Which one of the following is the result of the above program?
- Question #42
Which one of the following SAS procedures displays the data portion of a SAS data set?
- Question #43
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 #44
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...
- Question #45
Which one of the following SAS system options displays the time on a report?
- Question #46
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...
- Question #47
Which one of the following is true of the SUM statement in a SAS DATA step program?
- Question #48
Which one of the following SAS statements correctly computes the average of four numerical values?
- Question #49
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...
- Question #50
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?