A00-231 試験問題を無料オンラインアクセス

The following SAS program is submitted:
data WORK.ACCOUNTING;
set WORK.DEPARTMENT;
length EmpId $6;
CharEmpid=EmpId;
run;
If data set WORK.DEPARTMENT has a numeric variable EmpId.
Which statement is true about the output dataset?

• A.The type of the variable CharEmpid is numeric.
• B.The type of the variable CharEmpid is unknown.
• C.The program fails to execute due to errors.
• D.The type of the variable CharEmpid is character.

The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below:
WORK.EMPLOYEE WORK.SALARY
fname age name salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
by fname;
totsal + salary;
run;
Which one of the following statements completes the merge of the two data sets by the FNAME variable?

• A.merge work.employeework.salary (fname = name);
• B.merge work.employeework.salary (rename = (name = fname));
• C.merge work.employeework.salary (rename = (fname = name));
• D.merge work.employeework.salary (name = fname);

The following SAS program is submitted:
data work.test;
Title = 'A Tale of Two Cities, Charles J. Dickens';
Word = scan(title,3,' ,');
run;
Which one of the following is the value of the variable WORD in the output data set?

• A.Dickens
• B.T
• C.of
• D.'' (missing character value)

You're attempting to read a raw data file and you see the following messages displayed in the SAS Log:

What does it mean?

• A.An error on the INPUT statement specification for reading the variable Salary.
• B.The 1st of potentially many errors, this one occurring on the 4th observation.
• C.A compiler error, triggered by an invalid character for the variable Salary.
• D.An execution error, triggered by an invalid character for the variable Salary.

The following output is created by the FREQUENCY procedure:

Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?

• A.freq percent
• B.norowcount nocolcount
• C.nocounts
• D.norow nocol