QUESTION NO: 28 The contents of the raw data file PRODUCT are listed below: --------10-------20-------30 24613 $25.31 The following SAS program is submitted: data inventory; infile'product'; input idnum 5. @10 price; run; Which one of the following is the value of the PRICE variable? A. 25.31 B. $25.31 C. . (missing numeric value) D. No value is stored as the program fails to execute due to erro..
QUESTION NO: 27 The following SAS program is submitted: libnametemp 'SAS data library'; data work.new;set temp.jobs; format newdate mmddw10.; mdate= month(newdate); ddate= weekday(newdate); run; proc print data = work.new; run; The variable NEWDATE contains the SAS date value for April 15. 2005. What output is produced if April 15, 2005 falls on a Friday? A. Obsnewdate mdate ddate 104/15/2005 AP..
QUESTION NO: 26 Given the SAS data set WORKAWARDS: WORK.AWARDS FNAME POINTS MONTH Amy 2 4 Amy 1 7 Gerard 3 3 Wang 3 3 Wang 1 12 Wang 1 8 The following SAS program is submitted: proc sort data = work.awards; by descending fname points; run;How are the observations sorted? A. ENAME POINTS MONTH Wang 3 3 Wang 1 12 Wang 1 8 Gerard 3 3 Amy 2 4 Amy 1 7 B. ENAME POINTS MONTH Amy 2 4 Amy 1 7 Gerard 3 3 ..
QUESTION NO: 25 Read the table: Given the SAS data set SASUSER.HOUSES: Obs style bedrooms baths price sqteet street 1 CONDO 2 1.5 80050 1200 MAIN 2 CONDO 3 2.5 79350 1300 ELM 3 CONDO 4 2.5 127150 1400 OAK 4 CONDO 2 2.0 110700 1100 FIFTH 5 TWOSTORY 4 3.0 107250 2100 SECOND 6 TWOSTORY 2 1.0 55650 1600 WEST 7 TWOSTORY 2 1.0 69250 1450 NORTH 6 TWOSTORY 4 2.5 102950 2000 SOUTH The following SAS progr..
QUESTION NO: 24 Given the SAS data set ONE: ONE Obs Dte 1 09JAN2005 2 12JAN2005 The following SAS program is submitted: data two; set one; day = ; format dte date9.; run; The data set TWO is created: TWO Obs Dte Day 1 09JAN2005 1 12 JAN2005 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,..
QUESTION NO: 23 Given the SAS data set EMPLOYEES: EMPLOYEES NAME SALARY Innis 60000 Jolli 50000 Ellis 55000 Liu 45000 The following SAS program is submitted: proc print data = employees; where name like '_i%'; run; What is contained in the output? A. Liu only B. Innis and Ellis only C. Innis, Ellis, and Liu only D. Innis, Jolli, Ellis, and Liu Answer: A Solution : _ : 딱 한글자만 허락 % : 글자제한 x