Online Access Free A00-211 Exam Questions

Consider the following data step:

The computed variables City and State have their values assigned using two different methods, a RETAIN statement and an Assignment statement. Which statement regarding this program is true?

• A.The assignment statement is fine, but the value of City will be truncated to 8 bytes as theLENGTH statement has been omitted.
• B.Both the RETAIN and assignment statement are being used to initialize new variables and are equally efficient. Method used is a matter of programmer preference.
• C.City's value will be assigned one time, State's value 5 times.
• D.The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as theLENGTH statement has been omitted.

The following SAS DATA step is submitted:
data sasdata.atlanta
sasdata.boston
work.portland
work.phoenix;
set company.prdsales;
if region = 'NE' then output boston;
if region = 'SE' then output atlanta;
if region = 'SW' then output phoenix;
if region = 'NW' then output portland;
run;
Which one of the following is true regarding the output data sets?

• A.No library references are required.
• B.The data sets listed in the last two IF statements require a library reference.
• C.The data sets listed in the first two IF statements require a library reference.
• D.The data sets listed on all the IF statements require a library reference.

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 character.
• C.The program fails to execute due to errors.
• D.The type of the variable CharEmpid is unknown.

The following SAS program is submitted:
data WORK.DATE_INFO;
X="01Jan1960" D;
run;
What variable X contains what value?

• A.the numeric value 0
• B.the character value "01Jan1960"
• C.the code contains a syntax error and does not execute.
• D.the date value 01011960

The following SAS program is submitted:
Data_null_;
set old;
put sales 1 sales2;
run;
Where is the output written?

• A.to the SAS data set _NULL_
• B.to the SAS output window or to an output file
• C.to the raw data file that was most recently opened
• D.to the SAS log