나루다루

QUESTION NO: 54 The following SAS program is submitted: proc freq data = sales;run; Which TABLES statement(s) completed the program and produced the output? A. tables region product;B. tables region * product;C. tables product * region;D. tables product; tables region; Answer: B - 이원분할표 : tables x * y;

QUESTION NO: 53 The following SAS program is submitted: data work.test;array items{3} _temporary_;run; What are the names of the variable(s) in the WORKTEST data set? A. ITEMSB. ITEMS1, ITEMS2, ITEMS3C. No variables are created because it is a temporary array.D. The program fails to execute because there are no variables listed on the ARRAY statement. Answer: C - array items{3} : 길이가 3인 items 배열..

QUESTION NO: 25Given the SAS data set SASUSER.HOUSES:Obs style bedrooms baths price sqteet street1 CONDO 2 1.5 80050 1200 MAIN2 CONDO 3 2.5 79350 1300 ELM3 CONDO 4 2.5 127150 1400 OAK4 CONDO 2 2.0 110700 1100 FIFTH5 TWOSTORY 4 3.0 107250 2100 SECOND6 TWOSTORY 2 1.0 55650 1600 WEST7 TWOSTORY 2 1.0 69250 1450 NORTH6 TWOSTORY 4 2.5 102950 2000 SOUTH The following SAS program is submitted:proc repor..

QUESTION NO: 24Given the SAS data set ONE: ONE Obs Dte1 09JAN20052 12JAN2005 The following SAS program is submitted:data two;set one;day = ;format dte date9.;run; The data set TWO is created:TWOObs Dte Day1 09JAN2005 12 12JAN2005 4 Which expression successfully completed the program and created the variable DAY? A. day(dte)B. weekday(dte)C. dayofweek(dte)D. datdif(dte,'01jan2005'd,'act/act') Ans..

QUESTION NO: 23Given the SAS data set EMPLOYEES: EMPLOYEESNAME SALARYInnis 60000Jolli 50000Ellis 55000Liu 45000 The following SAS program is submitted:proc print data = employees; where name like '_i%';run; What is contained in the output? A. Liu onlyB. Innis and Ellis onlyC. Innis, Ellis, and Liu onlyD. Innis, Jolli, Ellis, and Liu Answer: A # 문제 풀이 - _ : 1글자만 대체 - % : 여러 글자를 대체 가능 (문자, 숫자는 상관 ..

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 data ..

QUESTION NO: 21The 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. 0B. 1C. 5D. 60 Answer: B # 문제 풀이 - Q12 참조

QUESTION NO: 20Given 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 15DY65DW 5.60 HARDWARE 45 5 DGTY23 4.55 HARDWARE 67 2 The following SAS program is submitted: data hware inter cheap; set prices(keep = producttype price); if producttype = 'HARDWARE' then output hware; el..