A00-211 Exam Dumps | A SAS program is submitted and the following SAS log is produced: 2 data gt100; 3 set ia.airplanes 4

<< Prev Question Next Question >>

Question 179/218

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.
ERROR: File WORK.MPG.DATA does not exist.
ERROR: File WORK.GT.DATA does not exist.
ERROR: File WORK.THEN.DATA does not exist.
ERROR: File WORK.OUTPUT.DATA does not exist.
ERROR 22-322: Syntax error, expecting one of the following: a name,
a quoted string, (, ;, END, KEY, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
ERROR 202-322: The option or parameter is not recognized and will be ignored.
5 run;
The IA libref was previously assigned in this SAS session.
Which one of the following corrects the errors in the LOG?

A. Place quotes around the value on the IF statement.

B. Delete the word THEN on the IF statement.

C. Add a semicolon at the end of the SET statement.

D. Add an END statement to conclude the IF statement

Question List (218q): Question 1: When the following SAS program is submitted, the data set SA...; Question 2: The following SAS program is submitted: data work.passengers...; Question 3: The following SAS program is submitted: data work.new; lengt...; Question 4: The SAS data set SASUSER.HOUSES contains a variable PRICE wh...; Question 5: The following SAS program is submitted and reads 100 records...; Question 6: The following SAS program is submitted: libname temp 'SAS-da...; Question 7: Given the SAS data set ONE: ONE Obs Dte ----- -------- 1 09J...; Question 8: The following SAS program is submitted: data work.flights; d...; Question 9: The SAS data set named WORK.SALARY contains 10 observations ...; Question 10: The following SAS program is submitted: data work.test; Firs...; Question 11: Given the SAS data set PEPM.STUDENTS: PERM.STUDENTS NAME AGE...; Question 12: Consider the following data step: data WORK.NEW; set WORK.OL...; Question 13: Given the SAS data set WORK.PRODUCTS: (Exhibit) How many obs...; Question 14: The following SAS program is submitted: (Exhibit) What is pr...; Question 15: Given the contents of the raw data file EMPLOYEE: ----|----1...; Question 16: The contents of the raw data file FURNITURE are listed below...; Question 17: The following SAS program is submitted: (Exhibit) How will t...; Question 18: The following SAS program is submitted: proc freq data = cla...; Question 19: The following SAS program is submitted: proc print data = sa...; Question 20: Which of the following choices is an unacceptable ODS destin...; Question 21: The following SAS program is submitted: data one; addressl =...; Question 22: What is the purpose or the MISSOVER option on the INFILE sta...; Question 23: A raw data file is listed below: RANCH,1250,2,1,Sheppard Ave...; Question 24: The SAS data set WORK.ONE contains a numeric variable named ...; Question 25: Given the contents of the raw data file TYPECOLOR: ----I----...; Question 26: Which one of the following SAS procedures displays the data ...; Question 27: After a SAS program is submitted, the following is written t...; Question 28: The data set WORK.REALESTATE has the variable LocalFee with ...; Question 29: Unless specified, which variables and data values are used t...; Question 30: Consider the data step: (Exhibit) Which of the following ass...; Question 31: The observations in the SAS data set WORK.TEST are ordered b...; Question 32: Which one of the following is true of the RETAIN statement i...; Question 33: Given the raw data file EMPLOYEE: ----I----1 0---I----20---I...; Question 34: You're attempting to read a raw data file and you see the fo...; Question 35: Which statement describes a characteristic of the SAS automa...; Question 36: Read the table (Exhibit) The following SAS program is submit...; Question 37: The following SAS program is submitted: data work.test; arra...; Question 38: The following SAS program is submitted: (Exhibit) What is th...; Question 39: The following SAS program is submitted: (Exhibit) How many o...; Question 40: The following SAS program is submitted: data work.empsalary;...; Question 41: The following SAS program is submitted: data revenue; set ye...; Question 42: The following code was modified to generate the results furt...; Question 43: The following SAS program is submitted: (Exhibit) What will ...; Question 44: The following SAS program is submitted: data work.staff; Job...; Question 45: The following SAS program is submitted: libname sasdata 'SAS...; Question 46: The following SAS program is submitted: data work.report; se...; Question 47: The following SAS program is submitted: (Exhibit) What is th...; Question 48: The following SAS program is submitted: data work.accounting...; Question 49: The following program is submitted: proc sort data=SASUSER.P...; Question 50: The following SAS program is submitted: data work.sets; do u...; Question 51: The contents of the raw data file CALENDAR are listed below:...; Question 52: Given the raw data record DEPT: ----|----10---|----20---|---...; Question 53: The following SAS program is submitted: data work.one; x = 3...; Question 54: The following program is submitted: (Exhibit) Why does the p...; Question 55: Consider the following data step: (Exhibit) The computed var...; Question 56: The following SAS program is submitted: proc format value sc...; Question 57: Consider the following data step: (Exhibit) In filtering the...; Question 58: A raw data file is listed below: RANCH,1250,2,1,Sheppard Ave...; Question 59: On which portion(s) of a SAS data set does the PRINT procedu...; Question 60: The following SAS program is submitted: data work.month; dat...; Question 61: The following SAS program is submitted, creating the SAS dat...; Question 62: Given the following raw data records in DATAFILE.TXT: (Exhib...; Question 63: The following SAS program is submitted: <insert ODS state...; Question 64: The following SAS program is submitted: proc contents data =...; Question 65: The following SAS program is submitted: data work.company; s...; Question 66: Given the contents of the raw data file TYPECOLOR.DAT: (Exhi...; Question 67: The following SAS program is submitted: data work.test; Titl...; Question 68: The following SAS program is submitted: <_insert_ods_code...; Question 69: The following SAS program is submitted: data test; set sasus...; Question 70: Given the SAS data set WORK.ORDERS: (Exhibit) The variable O...; Question 71: The following SAS program is submitted: data allobs; set sas...; Question 72: The following SAS program is submitted: (Exhibit) The progra...; Question 73: The value 110700 is stored in a numeric variable named SALAR...; Question 74: A realtor has two customers. One customer wants to view a li...; Question 75: The following SAS program is submitted: (Exhibit) The SAS da...; Question 76: The following SAS program is submitted: data work.test; set ...; Question 77: The following SAS program is submitted: data WORK.DATE_INFO;...; Question 78: The following SAS program is submitted: data work.new; lengt...; Question 79: Which one of the following is true of the SUM statement in a...; Question 80: The following SAS DATA step is submitted: data sasdata.atlan...; Question 81: The following SAS program is submitted: data test; infile 'f...; Question 82: Given the contents of the raw data file 'EMPLOYEE.TXT' (Exhi...; Question 83: The following SAS program is submitted: data work.test; arra...; Question 84: The following SAS program is submitted: (Exhibit) What new v...; Question 85: The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown be...; Question 86: The SAS data set Fed.Banks contains a variable Open_Date whi...; Question 87: The following SAS program is submitted: data work.new; mon =...; Question 88: Given the following raw data records in TEXTFILE.TXT: (Exhib...; Question 89: After a SAS program is submitted, the following is written t...; Question 90: The following SAS program is submitted: (Exhibit) What is th...; Question 91: Given the following data step: (Exhibit) After data step exe...; Question 92: The following SAS program is submitted: (Exhibit) How many r...; Question 93: The SAS data set WORK.ONE contains a numeric variable named ...; Question 94: The following output is created by the FREQUENCY procedure: ...; Question 95: Given the following code: proc print data=SASHELP.CLASS(firs...; Question 96: Which one of the following statements is true regarding the ...; Question 97: The following SAS program is submittad: data work.sales; do ...; Question 98: The following SAS program is submitted: options pageno = 1; ...; Question 99: The following SAS DATA step executes on Monday, April 25, 20...; Question 100: Given the raw data record in the file phone.txt: (Exhibit) W...; Question 101: Given the following raw data records: (Exhibit) The followin...; Question 102: Which statement correctly computes the average of four numer...; Question 103: The following SAS program is submitted: data WORK.AUTHORS; a...; Question 104: Given the SAS data set PRICES: PRICES prodid price K12S 5.10...; Question 105: The following SAS program is submitted: data work.retail; co...; Question 106: Which one of the following SAS statements renames two variab...; Question 107: The following SAS program is submitted: Data_null_; set old;...; Question 108: The following SAS program is submitted: data work.accounting...; Question 109: The following SAS program is submitted: data WORK.DATE_INFO;...; Question 110: The contents of the SAS data set PERM.JAN_SALES are listed b...; Question 111: The following SAS program is submitted: data work.test; Auth...; Question 112: The SAS data set PETS is sorted by the variables TYPE and BR...; Question 113: Which one of the following SAS DATA steps saves the temporar...; Question 114: The following SAS program is submitted: data temp.x; set sas...; Question 115: The following SAS program is submitted: data work.products; ...; Question 116: A raw data file is listed below: --------10-------20-------3...; Question 117: The SAS data set named WORK.TEST is listed below: capacity a...; Question 118: The following SAS program is submitted: data WORK.ACCOUNTING...; Question 119: A user-defined format has been created using the FORMAT proc...; Question 120: Which step displays a listing of all the data sets in the WO...; Question 121: The following SAS program is submitted: libname company 'SAS...; Question 122: Which statement specifies that records 1 through 10 are to b...; Question 123: The contents of the raw data file AMOUNT are listed below: -...; Question 124: Given the SAS data set PERM.STUDENTS: PERM.STUDENTS NAME AGE...; Question 125: The following SAS program is submitted: data stats; set reve...; Question 126: Given the AIRPLANES data set AlRPLANES TYPE MPG -------- ---...; Question 127: A raw data record is listed below: --------10-------20------...; Question 128: The following SAS program is submitted: libname sasdata 'SAS...; Question 129: The Excel workbook REGIONS.XLS contains the following four w...; Question 130: The following SAS program is submitted: libname temp 'SAS da...; Question 131: The following SAS program is submitted: data one; date = '04...; Question 132: A SAS PRINT procedure output of the WORK.LEVELS data set is ...; Question 133: The following SAS program is submitted: proc sort data = wor...; Question 134: The following SAS program is submitted: (Exhibit) If the val...; Question 135: Given the following raw data record: ----I----10---I----20--...; Question 136: Given the raw data file AMOUNT: ----I---- 10---I----20---I--...; Question 137: The following SAS program is submitted: data work.retail; co...; Question 138: The following SAS program is submitted: data work.total; set...; Question 139: The following SAS program is submitted: data combine; prefix...; Question 140: Which one of the following SAS system options prevents the p...; Question 141: Which of the following programs correctly invokes the DATA S...; Question 142: The following SAS SORT procedure step generates an output da...; Question 143: Which one of the following SAS system options displays the t...; Question 144: Given the SAS data set WORK.TEMPS: (Exhibit) The following p...; Question 145: The data set RALESTATE has the variable LOCALFEE with a form...; Question 146: Given the following raw data record: 07Jan2005 Which INFORMA...; Question 147: The following SAS program is submitted: data work.clients; c...; Question 148: The following program is submitted: proc contents data=_all_...; Question 149: Given the SAS data set WORKAWARDS: WORK.AWARDS FNAME POINTS ...; Question 150: The following SAS program is submitted: data work.totalsales...; Question 151: Given the SAS data set EMPLOYEE INFO: EMPLOYEE_INFO IDNumber...; Question 152: Given the SAS data set WORK.ONE: (Exhibit) And the SAS data ...; Question 153: Given the SAS data set AGES: AGES AGE --------- The variable...; Question 154: The following program is submitted: proc contents data=_all_...; Question 155: The following SAS program is submitted: proc sort data = sas...; Question 156: The following SAS program is submitted: (Exhibit) What is th...; Question 157: The following SAS DATA step is submitted: libname temp 'SAS-...; Question 158: The SAS data set WORK.AWARDS is listed below: fname points A...; Question 159: The following SAS program is submitted: data work.test; Firs...; Question 160: The following SAS program is submitted: data work.january; s...; Question 161: The contents of the raw data file PRODUCT are listed below: ...; Question 162: The following SAS program is submitted: proc contents data =...; Question 163: The SASDATA.BANKS data set has five observations when the fo...; Question 164: Given the raw data file YEARAMT: ----|---10---|---20---|----...; Question 165: Given the SAS data set WORK.ONE: (Exhibit) The following SAS...; Question 166: The following output is created by the FREQUENCY procedure: ...; Question 167: Which one of the following is true when SAS encounters a dat...; Question 168: Given the SAS data set PRICES: Prodid price producttype sale...; Question 169: The following SAS program is submitted: libname temp 'SAS da...; Question 170: Which program displays a listing of all data sets in the SAS...; Question 171: The following SAS program is submitted: (Exhibit) Which stat...; Question 172: Given the data set WORK.EMPDATA: (Exhibit) Which one of the ...; Question 173: After a SAS program is submitted, the following is written t...; Question 174: The following SAS program is submitted; data combine; countr...; Question 175: The following SAS program is submitted: proc means data = sa...; Question 176: The following SAS program is submitted: data _null_; set old...; Question 177: The following SAS program is submitted: (Exhibit) Which stat...; Question 178: Which statement is true concerning the SAS automatic variabl...; Question 179: A SAS program is submitted and the following SAS log is prod...; Question 180: Given the SAS data set WORK.ORDERS: (Exhibit) The variable o...; Question 181: The contents of the raw data file TEAM are listed below: ---...; Question 182: The Excel workbook QTR1.XLS contains the following three wor...; Question 183: Given the SAS data set EMPLOYEES: EMPLOYEES NAME SALARY ----...; Question 184: Which ODS statement option terminates output being written t...; 1 commentQuestion 185: The following SAS program is submitted: data WORK.OUTDS; do ...; Question 186: Given the SAS data set QTR 1_REVENUE: destination revenue YY...; Question 187: The contents of two SAS data sets named EMPLOYEE and SALARY ...; Question 188: A raw data file is listed below: --------10-------20-------3...; Question 189: The following SAS program is submitted: data work.totalsales...; Question 190: Which is a valid LIBNAME statement?...; Question 191: The contents of the raw data file SIZE are listed below: ---...; Question 192: The SAS data set BANKS is listed below: BANKS name rate Firs...; Question 193: The following SAS program is submitted: data work.pieces; do...; Question 194: Which step sorts the observations of a permanent SAS data se...; Question 195: The following SAS DATA step is submitted: data work.accounti...; Question 196: Given the SAS data set WORK.P2000: (Exhibit) And the SAS dat...; Question 197: Given the SAS data set SASDATA TWO: SASDATA TWO X Y -- -- 5 ...; Question 198: Given the SAS data set WORK.EMP_NAME: (Exhibit) Given the SA...; Question 199: The following SAS program is submitted: data work.total; set...; Question 200: What describes the SAS automatic _ERROR_ variable?...; Question 201: The SAS data set EMPLOYEE_INFO is listed below: IDNumber Exp...; Question 202: The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed b...; Question 203: Given the SAS data set WORK.PRODUCTS: (Exhibit) How many var...; Question 204: The following SAS program is submitted: data WORK.ONE; Text=...; Question 205: The contents of the raw data file EMPLOYEE are listed below:...; Question 206: Read the table: (Exhibit) Given the SAS data set SASUSER.HOU...; Question 207: The contents of the raw data file NAMENUM are listed below: ...; Question 208: The following SAS program is submitted: footnote1 'Sales Rep...; Question 209: The following SAS program is submitted: data test; set chemi...; Question 210: The following SAS program is submitted: data work.month; dat...; Question 211: The following SAS program is submitted: (Exhibit) What types...; Question 212: The following SAS program is submitted: libname rawdata1 'lo...; Question 213: The following SAS program is submitted: data ONE TWO SASUSER...; Question 214: Given the SAS data set WORK.ONE: (Exhibit) What value will S...; Question 215: Given the SAS data set ONE: Given the SAS data set WORK.ONE:...; Question 216: The following SAS program is submitted: data WORK.ACCOUNTING...; Question 217: The following SAS program is submitted: data work.test; Auth...; Question 218: The following SAS program is submitted: data numrecords; inf...

Question 179/218

LEAVE A REPLY

Download PDF File