Test Online Free SAS Institute A00-215 Exam Questions and Answers

Given the input data sets EMPLOYEES and DONATIONS, and the output data set NODONATIONS below:
EMPLOYERS



DONATIONS



NODONATIONS

• A. data nodonations; merge employees (in-inE) donations (in=inD); by employee_id; if inE=0 and inD-0; run;
• B. data nodonations; merge employees (in-inE) donations (in=inD); by employee_id; run;
• C. data nodonations; merge employees (in-inE) donations (in=inD); by employee_id; if inE=1 and inD-0; run;
• D. data nodonations; merge employees (in-inE) donations (in=inD); by employee_id; if inE=1 and inD-1; run;

Show Answer

• A. The DROP statement flags the variables in the Program Data Vector to be dropped at output.
• B. The DROP statement determines the order of the variables in the Program Data Vector
• C. Variables on the DROP statement are removed from the input data set.
• D. Variables on the DROP statement are not created in the Program Data Vector

Show Answer

Given the program shown below:



Given the partial PROC PRINT report below:



Why are the labels for msbp, MPG_city, and MPG_Highway NOT displaying in the PROC PRINT report^

• A. You must use the LABEL option on the PROC PRINT statement
• B. You must put the LABEL statement in the PROC PRINT step
• C. You must put the LABEL statement after the KEEP statement In the DATA stop
• D. You must use a single LABEL statement for each variable.

Show Answer

• A. Proc contents file=sashelp .shoes; Run;
• B. Proc contents lib=sashelp data=shoes; Run;
• C. Proc contents data=sashelp.shoes; Run;
• D. Proc contents sashelp. Shoes; run;

Show Answer

• A. Ods excel=’ c : \report. xlsx’ style=analysis;
• B. Ods excel workbook=’ report. xles’ analysis;
• C. Ods excel=’ c : \report. xlsx’ / analysis;
• D. Ods excel file =’c \report.xlsx’ styleanalysis;

Show Answer

• A. Name both data sets in the DATA statement
• B. Use an OUT= option in the WHERE statement to output the observations to the appropriate data sets.
• C. Use a PUT statement to output the observations to the appropriate data sets.
• D. Use a separate SET statement for each data set.

Show Answer

When the following code is submitted, execution fails.



Why does the execution fail? Multiple executable statements are not allowed in the DO block.

• A. The OUTPUT statement is not allowed in the DO block.
• B. There are two unclosed DO block.
• C. The conditional logic expressions fail for the DO block

Show Answer

• A. SHOWLABELS
• B. COLS
• C. LABELS=
• D. LABEL

Show Answer

• A. Label1 FName=’ First Name’ ; LName =; Last Name‘ ;
• B. Label1 FName=’ First Name’ LName =’ Last Name‘ ;
• C. Label1 FName=’ First Name’ and LName =’ Last Name‘ ;
• D. Label1 FName=’ First Name’ , LName =; Last Name‘ ;

Show Answer

The following program is summited:



The following report is created:



However, the desired report is shown below:



What change is needed to display the desired formatted values for the Answer varia?

• A. Change the unformatted values on the VALUE statement to upper case letters
• B. Remove the comma located on the VALUE statement
• C. Add a period to the end of the format name on the VALUE statement.
• D. Remove the dollar sign located at the front of the format name

Show Answer

The data set Snacks contains three variables (productName, Flavor, and Price).
Given the program shown below:



What is the type and length of SnackType?

• A. Numeric, 8
• B. Character, 7
• C. Character, 8
• D. Character, 5

Show Answer

Given the code shown below:



What will be the format for MSRP in the RPOC PRINT output?

• A. There is a syntax error in the FORMAT statement in the PROC PRINT step.
• B. Comma12. 2
• C. Dollar10.
• D. Dollar12.

Show Answer