A00-231 exam

The following SAS program is submitted: data one; addressl = ‘214 London Way’; run; data one; set one; address = tranwrd(address1, ‘Way’, ‘Drive’); run; What are the length and value of the variable ADDRESS?A . Length is 14; value is ‘214 London Dri’. B. Length is 14; value is ‘214...

The following SAS program is submitted: What new variables are created?A . Difcount1, Difcount2 and Difcount3 B. Diff1, Diff2 and Diff3 C. Janpt, Febpt, and Marpt D. Patients1, Patients2 and Patients3View AnswerAnswer: A

Given the raw data record in the file phone.txt: Which SAS statement completes the program and results in a value of "James Stevens" for the variableFullName?A . FullName=CATX('',EmpFName,EmpLName); B. FullName=CAT('',EmpFName,EmpLName); C. FullName=EmpFName!!EmpLName; D. FullName=EmpFName + EmpLName;View AnswerAnswer: A

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

Given the following raw data record: ----I----10---I----20---I----30 son Travis, The following output is desired: Obs relation firstname 1 son Travis Which SAS program correctly reads in the raw data?A . data family ( dIm = ‘,’); infile ‘tile specification’; input relation $ firstname $; run; B. options dIm = ‘,’;...

The following SAS program is submitted: data ONE TWO SASUSER.TWO set SASUSER.ONE; run; Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?A . 2 temporary and 1 permanent SAS data sets are created B. 3 temporary and 2 permanent SAS data sets are created C....

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

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

The following SAS program is submitted: proc format value score 1 - 50 = ‘Fail’ 51 - 100 = ‘Pass’; run; proc report data = work.courses nowd; column exam; define exam / display format = score.; run; The variable EXAM has a value of 50.5. How will the EXAM variable...

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