- All Exams Instant Download
What output is produced if April 15, 2005 falls on a Friday?
The following SAS program is submitted: libname temp ‘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,...
Which of the following is true concerning the submitted program?
The following program is submitted: proc sort data=SASUSER.PROJECTS out=PSORT; by Code descending Date Cost; run; Which of the following is true concerning the submitted program?A . The descending option applies to the variable Code.B . The variable Code is sorted by ascending order.C . The PSORT data set is stored...
What is the cause of the syntax error?
Given the AIRPLANES data set AlRPLANES TYPE MPG -------- ------ F-18 105 C-130 25 Harrier 75 A-6 110 The following SAS program is submitted: data gt100; set airplanes(keep = type mpg load); load = mpg * 150; run; The program fails to execute due to syntax errors. What is the...
What are the values of the AMOUNT and WORD variables in SAS dataset work.new?
The following SAS program is submitted: data work. new; length word $7; amount = 4; it amount = 4 then word = ‘FOUR’; else if amount = 7 then word = ‘SEVEN’; else word = ‘NONE!!!’; amount = 7; run; What are the values of the AMOUNT and WORD variables...
Which expression successfully completed the program and created the variable DAY?
Given the SAS data set ONE: ONE ObsDte ------------- 109JAN2005 212JAN2005 The following SAS program is submitted: data two; set one; day = <insert expression here>; format dte date9.; run; The data set TWO is created: TWO ObsDteDay 109JAN20051 12JAN20054 Which expression successfully completed the program and created the variable...
What variable X contains what value?
The following SAS program is submitted: data WORK.DATE_INFO; X="01Jan1960" D; run; What variable X contains what value?A . the numeric value 0B . the character value "01Jan1960"C . the date value 01011960D . the code contains a syntax error and does not execute.View AnswerAnswer: A
Which DEFINE statement completes the program and produces the desired output?
Read the table: Given the SAS data set SASUSER.HOUSES: Obsstylebedroomsbathspricesqteetstreet 1CONDO21.5800501200MAIN 2CONDO32.5793501300ELM 3CONDO42.51271501400OAK 4CONDO22.01107001100FIFTH 5TWOSTORY43.01072502100SECOND 6TWOSTORY21.0556501600WEST 7TWOSTORY21.0692501450NORTH 6TWOSTORY42.5102950 2000SOUTH The following SAS program is submitted: proc report data = sasuser.houses nowd headline; column style price; where price It 100000; <insert DEFINE statement here> define price / mean width = 9...
What is written to the output raw data file?
Given the SAS data set PEPM.STUDENTS: PERM.STUDENTS NAME AGE Alfred 14 Alice13 Barbara13 Carol14 The following SAS program is submitted: libname perm ‘SAS data library’; data students; set perm. Students; file ‘file specification’; put name $15. @5 age 2.; run; What is written to the output raw data file?A ....
Why does the program rail to execute?
The following SAS program is submitted: proc sort data = work.employee; by descending fname; proc sort data = work.salary; by descending fname; data work.empdata; merge work.employee work.salary; by fname; run; Why does the program rail to execute?A . The SORT procedures contain invalid syntax.B . The merged data sets are...
What is the result?
Given the SAS data set SASDATA TWO: SASDATA TWO XY 52 31 56 The following SAS program is submitted: data sasuser.one two sasdata.three; set sasdata two; if x = 5 then output sasuser.one; else output sasdata two; run; What is the result?A . data set SASUSER.ONE has 5 observationsdata set...
