나루다루

QUESTION NO: 66The following SAS program is submitted:proc means data = sasuser.shoes;where product in ('Sandal' , 'Slipper' , 'Boot');run; Which ODS statements complete the program and send the report to an HTML file? A. ods html = 'sales.html'; ods html close;B. ods file = 'sales.html'; ods file close;C. ods file html = 'sales.html'; ods file close;D. ods html file = 'sales.html'; ods html clo..

QUESTION NO: 65The following SAS program is submitted:data combine;prefix='505';middle='6465 ';end='09090';;run; Which statement successfully completes the program so that TOTAL has a value of 505-6465-09090? A. total = cat('-', prefix, middle, end);B. total = catx('-', prefix, middle, end);C. total = prefix !!'-'!! middle ''!!'-'!! end;D. total = prefix!!'-'!! left(middle)!!'-'!! end; Answer: B..

QUESTION NO: 64After 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;ERROR 22-322: Syntax error, expecting one of the following:!, !!, &, *,**, +, -,/, , >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTI..

QUESTION NO: 63Given the SAS data set ONE:x y z1 A 271 A 331 B 452 A 522 B 593 B 704 A 824 C 91 The following SAS program is submitted:data two;set one;by x y;if first.y;run; proc print data = two noobs;run; Which report is produced? A. X Y Z 1 A 27 1 B 45 2 A 52 2 B 69 3 B 70 4 A 82 4 C 91 B. X Y Z 1 A 33 1 B 45 2 A 52 2 B 69 3 B 70 4 A 82 4 C 91 C. X Y Z 1 B 45 2 A 52 2 B 69 3 B 70 4 A 82 4 C ..

QUESTION NO: 62The 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. @;else if relative = 'parents' theninput @28 doctor $15.clinic $ 44-53@54 diagnosis $15. @;input age;run; How many raw data records are read during each iteration of the DATA step execution? A. 1B. 2C. 3D. 4 ..

QUESTION NO: 61Given the SAS data set QTR 1_REVENUE: destination revenue YYZ 53634 FRA 62129 FRA 75962 RDU 76254YYZ 82174 The following SAS program is submitted:proc sort data = qtr1_revenue;by destination descending revenue; run; What is the first observation in the output data set? A. destination revenue FRA 62129B. destination revenue FRA 75962C. destination revenue YYZ 53634D. destination re..

QUESTION NO: 60The following SAS program is submitted:data test;infile 'file specification';input name $ amount@@;run; Which of the following is true? A. Two @@ together are the same as one c.B. Two @@ hold the data records until the bottom of the DATA step.C. Two @@ hold the raw data record across iterations of the DATA step.D. Two @@ are invalid syntax and will cause the program to fail to exe..

QUESTION NO: 59Given the contents of the raw data file EMPLOYEE:Alan 19/2/2004 ACCTRob 22/5/2004 MKTGMaryJane 14/3/2004 EDOC The following SAS program is submitted:data emps;infile 'employee';input@1 name$@15 date @25 department$;run; Which INFORMAT correctly completes the program? A. date9.B. ddmmyyyy9.C. ddmmyy10.D. ddmmyyyy10. Answer: C # 문제수정 - 데이터 부분이 누락되어 추가하였다. # 문제 풀이 - @1 : 데이터의 1번째부터 변..