A00-231

The following SAS program is submitted: proc sort data = work.employee; by descending fname; proc sort data = work.salary; by descending fname; data work.empdata; merge work.employee work.salary; by fname; run; Why does the program rail to execute?A . The SORT procedures contain invalid syntax. B. The merged data sets are...

Given the SAS data set WORK.TEMPS: The following program is submitted: Which output is correct? A . Option A B. Option B C. Option C D. Option DView AnswerAnswer: C

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 data set?A . 1 B. 12 C. Italy D. RussiaView AnswerAnswer: B

Given the following raw data record: 07Jan2005 Which INFORMAT reads this raw data and stores it as a SAS date value?A . dmy9. B. date9. C. ddMMMyy9. D. ddmmmyyyy9.View AnswerAnswer: B

Which ODS statement option terminates output being written to an HTML rile?A . END B. QUIT C. STOP D. CLOSEView AnswerAnswer: D

00100.00 Total10100.00 Which option correctly completes the program and creates the report?A . LIST B. NOCOLS C. CROSSLIST D. NOCROSSTABView AnswerAnswer: C

The following SAS program is submitted: libname temp ‘SAS data library’; data temp.sales; merge temp.sales work.receipt; by names; run; The input data files are sorted by the NAMES variable: What is the result?A . The program executes successfully and a temporary SAS data set is created. B. The program executes...

The following SAS program is submitted: How will the Exam variable value be displayed in the FREQ procedure output?A . Fail B. Pass C. 50.5 D. .(missing numeric value)View AnswerAnswer: C

Given the AIRPLANES data set AlRPLANES TYPE MPG -------- ------ F-18 105 C-130 25 Harrier 75 A-6 110 The following SAS program is submitted: data gt100; set airplanes(keep = type mpg load); load = mpg * 150; run; The program fails to execute due to syntax errors. What is the...

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 WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations. How many observations will the data set WORK.EMPSALARY contain?A . 0 B....