QUESTION NO: 22 The following SAS program is submitted: data work.totalsales (keep = monthsales{12}); set work.monthlysales (keep = year product sales); array monthsales{12); do i = 1 to 12; monthsales{i) = sales; end; run; The program fails execution due to syntax errors. What is the cause of the syntax error? A. The variable MONTHSALES does not exist. B. An array cannot be referenced on a KEEP..

QUESTION NO: 21 The following SAS program is submitted: data work.sales; do year = 1 to 5; do month = 1 to 12; x+ 1; end; end; run; How many observations are written to the WORK.SALES data set? A. 0 B. 1 C. 5 D. 60 Answer: B Solution : 다음 처럼 값들이 쌓이게 된다 . 그런데 , output이 없기 때문에 , 값들이 덮어씌어지게 된다 . year month x 1 1 1 2 2 3 3 4 4 5 5 6 6 7 7 8 8 9 9 10 10 11 11 12 12 최종 출력값은 다음과 같다 . year month x 5 12 ..

QUESTION NO: 20 Given the SAS data set PRICES: PRICES Prodid price producttype sales returns K125 5.10 NETWORK 15 2 B132S 2.34 HARDWARE 300 10 R18KY2 1.29 SOFTWARE 25 5 3KL8BY 6.37 HARDWARE 125 15 DY65DW 5.60 HARDWARE 45 5 DGTY23 4.55 HARDWARE 67 2 The following SAS program is submitted: data hware inter cheap; set prices(keep = productype price); if producttype = 'HARDWARE' then output hware; e..

QUESTION NO: 19 The following SAS program is submitted: data work.passengers; if OrigPassengers = . then OrigPassengers= 100; TransPassengers= 100; OrigPassengers= .;TotalPassengers= sum (OrigPassengers, TransPassengers) +0; run; What is the value of the TOTALPASSENGERS variable in the output data set? A. 0 B. 100 C. 200 D. (missing numeric value) Answer: B Solution : sas 에서 . = 결측 ( 즉 값이 없다 ) 라..

QUESTION NO: 18 The SAS data set PETS is sorted by the variables TYPE and BREED. The following SAS program is submitted: proc print data = pets; vartype breed; sum number; run; What is the result? A. The SUM statement produces only a grand total of NUMBER. B. The SUM statement produces only subtotals of NUMBER for each value of TYPE. C. The SUM statement produces both a grand total of NUMBER and..