Tag - A00-231 exam

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

00100.00 Total10100.00 Which option correctly completes the program and creates the report?A . LISTB . NOCOLSC . CROSSLISTD . NOCROSSTABView AnswerAnswer: C

Given the contents of the raw data file TYPECOLOR: ----I----10---I----20---I----30 Daisyyellow The following SAS program is submitted: data flowers; infile ‘typecolor’; input type$ 1-5+1 color$; run; What are the values of the variables TYPE and COLOR?A . type colordaisygreenB . type colordaisy ellowC . type colordaisyyellow” “(missing character value)D ....

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 january; 108 sales = cost * num_sold; 109 keep = product sales; ------ 22 ERROR 22-322: Syntax error,...

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

The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of “Asking Price”. Which SAS program temporarily replaces the label “Asking Price” with the label “Sale Price” in the output?A . proc print data = sasuser.houses; label price = “Sale Price”; run;B . proc...

What is the purpose or the MISSOVER option on the INFILE statement?A . It prevents SAS from loading a new record when the end of the current record is reached.B . It enables SAS to scan the input data records until the character string that is specified in the @‘character-string’...

Which statement describes a characteristic of the SAS automatic variable _ERROR_?A . The _ERROR_ variable maintains a count of the number of data errors in a DATA step.B . The _ERROR_ variable is added to the program data vector and becomes part of the data set being created.C . The...

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 format = score.; run; The variable EXAM has a value of 50.5. How will the EXAM variable...

The value 110700 is stored in a numeric variable named SALARY. Which FORMAT statement displays the value as $110,700.00 in a report?A . format salary comma11.2;B . format salary dollar8.2;C . format salary dollar11.2;D . format salary comma8.2 dollar8.2;View AnswerAnswer: C