A00-231

The following SAS program is submitted: data test; infile ‘file specification’; input name $ amount@@; run; Which of the following is true?A . Two @@ together are the same as one c. B. Two @@ hold the data records until the bottom of the DATA step. C. Two @@ hold...

Given the raw data file AMOUNT: ----I---- 10---I----20---I----30 $1,234 The following SAS program is submitted: data test; infile ‘amount’; input@1 salary 6.; if_error_then description = ‘Problems’; else description = ‘No Problems’; run; What is the result?A . The value of the DESCRIPTION variable is No Probl. B. The value of...

The following SAS program is submitted: data WORK.ONE; Text=’Australia, US, Denmark’; Pos=find (Text,’US’,’i’,5); run; What value will SAS assign to Pos?A . 0 B. 1 C. 2 D. 12View AnswerAnswer: D

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