A00-201 Exam Questions

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

Which one of the following statements is true regarding the SAS automatic _ERROR_ variable? A.The _ERROR_ variable contains the values 'ON' or 'OFF'. B.The _ERROR_ variable contain...

The following SAS program is submitted: data work.sales; do year = 1 to 5; do month = 1 to 12; x + 1; end; end; run; Which one of the following represents how many observations are...

The SAS data set WORK.AWARDS is listed below: fname points Amy 2 Amy 1 Gerard 3 Wang 1 Wang 1 Wang 2 The following SAS program is submitted: proc sort data = work.awards; by descen...

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

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?

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

Which one of the following SAS DATA steps saves the temporary data set MYDATA as a permanent data set?

The following SAS program is submitted: data work.new; mon = 3; day = 23; year = 2000; date = mdy(mon,day,year); run; Which one of the following is the value of the DATE variable?

The following SAS program is submitted: proc report data = sasuser.houses nowd headline headskip; column style price; where price < 100000; <insert code here> title; run; Click the...

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

Unless specified, which variables and data values are used to calculate statistics in the MEANS procedure?

The following SAS program is submitted: proc print data = sasuser.houses; run; <insert OPTIONS statement here> proc means data = sasuser.shoes; run; Which one of the following OPTI...

The contents of the raw data file EMPLOYEE are listed below: |----1----|----10----|----20----|----30 Ruth 39 11 Joe 35 22 Sue 30 33 John 40 44 The following SAS program is submitte...

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

The following SAS program is submitted: data work.passengers; if OrigPassengers = . then OrigPassengers = 100; TransPassengers = 100; OrigPassengers = .; NonPaying = 10; TotalPasse...

The contents of the raw data file TYPECOLOR are listed below: |----1----|----10----|----20----|----30 daisy yellow The following SAS program is submitted: data flowers; infile 'typ...

The following SAS program is submitted: data test; set sasuser.employees; if 2 le years_service le 10 then amount = 1000; else if years_service gt 10 then amount = 2000; else amoun...

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

Click the Exhibit button to view the output of a FREQ procedure. The variable STYLE has a permanent label of "Style of homes" and the variable BEDROOMS has a permanent label of "Nu...

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

A SAS PRINT procedure output of the WORK.LEVELS data set is listed below: Obs name Level 1 Frank 1 2 Sean 2 3 Sue 2 4 Jose 3 5 Juan 4 6 Kelly 1 7 Juan 1 The following SAS program i...

A raw data file is listed below: -----10----|----20----|----30 1901 2 1905 1 1910 6 1925 . 1941 1 The following SAS program is submitted and references the raw data file above: dat...

The SAS data set EMPLOYEE_INFO is listed below: IDNumber Expenses 2542 100.00 3612 133.15 2198 270.34 3198 311.12 The following SAS program is submitted: proc sort data = employee_...

The contents of the raw data file TEAM are listed below: -----10----|----20----|----30 Janice 10 Henry 11 Michael 11 Susan 12 The following SAS program is submitted: data group; in...

Which one of the following SAS programs created this data set? capacity airplaneType staff 150 Large 10

16: The contents of the raw data file AMOUNT are listed below: '~~~|~~~10~~~|~~~20~~~|~~~30' $1,234 The following SAS program is submitted: data test; infile 'amount'; input @1 sal...

17: The following SAS program is submitted: data work.month; d ate = input('13mar2000',date9.); run; Which one of the following represents the type and length of the variable DATE...

19: The following SAS program is submitted: data work.clients; calls = 5; do while (calls le 6); calls + 1; end; run; Which one of the following is the value of the variable CALLS...

20: 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; i...

21: Which one of the following SAS system options prevents the page number from appearing on a report?

23: The following SAS DATA step executes on Monday, April 25, 2000: data newstaff; set staff; start_date = today(); run; Which one of the following is the value of the variable STA...

24: The value 110700 is stored in a numeric variable. Which one of the following SAS formats is used to display the value as $110,700.00 in a report?

25: A raw data record is listed below: |-----10----|----20----|----30 s on,Travis The following output is desired: relation firstName son Travis Which one of the following SAS prog...

The following SAS program is submitted using the PERM.STUDENTS data set as input: libname sasdata 'SAS-data-library'; data students; set perm.students; file 'file-specification'; p...

Given the following SAS code snippet, and a value for the variable JOBCODE as 'chem2': then description = 'Senior Chemist'; else description = 'Unknown'; run; Which one of the foll...

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

The following SAS program is submitted: data revenue; set year_1; var1 = mdy(1,15,1960); run; Which one of the following values does the variable VAR1 contain?

A raw data file is listed below: RANCH,1250,2,1,Sheppard Avenue,""$54,000"" SPLIT,1190,4,1,Rand Street,""$95,850"" CONDO,11400,2,1,3,Market Street,""$80,050"" TWOSTORY,1800,4,3,Ger...

The following SAS program is submitted: data work.empsalary; set work.people (in = inemp) work.money (in = insal); if insal and inemp; run; The SAS data set WORK.PEOPLE has 5 obser...

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

In the following SAS program, the input data files are sorted by the NAMES variable: libname temp 'SAS-data-library'; data temp.sales; merge temp.sales work.receipt; by names; run;...

When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations: libname sasdata 'SAS-data-library'; options obs = 500; proc print data = sasd...

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

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

The following SAS program is submitted: data numrecords; infile 'file-specification'; input @1 patient $15 relative $ 16-26 @; if relative = 'children' then input @54 diagnosis $15...

The following SAS program is submitted: data stats; set revenue; array weekly(5) mon tue wed thu fri; <insert DO statement here> total = weekly(i) * .25; output; end; run; Which on...

The following SAS program is submitted: data work.flights; destination = 'cph'; select(destination); when('LHR') city = 'london'; when('CPH') city = 'Copenhagen'; otherwise city =...

The following SAS program is submitted: proc report data = work.houses nowd; column style price; where price < 100000; <insert DEFINE statements here> title; run; Click the Exhibit...

The following SAS DATA step is submitted: data sasdata.atlanta sasdata.boston work.portland work.phoenix; set company.prdsales; if region = 'NE' then output sasdata.boston; if regi...