Preparing for the SAS Programming Certification Exam Quiz Answers

Get All Weeks Preparing for the SAS Programming Certification Exam Quiz Answers

In this course, you have the opportunity to use the skills you acquired in the two SAS programming courses to solve realistic problems. This course is also designed to give you a thorough review of SAS programming concepts so you are prepared to take the SAS Certified Specialist: Base Programming Using SAS 9.4 Exam.

Enroll on Coursera

Preparing for the SAS Programming Certification Exam Quiz Answers

Week 1 Quiz Answers

Quiz 1: Essentials Review Questions

Q1. A SAS program will always create which of the following?

  • log
  • output data
  • results
  • all of the above

Q2. Which of the following is a SAS syntax requirement?

  • Separate each step with a line space.
  • Begin each statement in column one.
  • Put only one statement on each line.
  • End each statement with a semicolon.

Q3. How many steps are in this program?

libname orion "c:/mydata";
data work.sales;
set orion.employee;
where Job_Title like "%Sales%";
Bonus=Salary*.02;
format Bonus euro8.;
run;
title "Sales Listing";
  • one
  • two
  • three
  • four

Q4. How many statements does the first step contain?

libname orion "c:/mydata";
data work.sales;
set orion.employee;
where Job_Title like "%Sales%";
Bonus=Salary*.02;
format Bonus euro8.;
run;
title "Sales Listing";
  • 10
  • 2
  • 1
  • 6

Q5. Which of the following statements are considered step boundaries (the end of one step and the beginning of another)?

  • RUN, QUIT, DATA, and PROC
  • RUN, EXIT, and END
  • RUN, END, DATA, and PROC
  • RUN, QUIT, and END

Q6. What generally happens when SAS detects a syntax error?

  • SAS stops processing the entire program.
  • SAS continues to process the step, and the SAS log displays messages about the error.
  • SAS stops processing the step in which the error occurred, and the SAS log displays messages about the error.
  • SAS stops processing the step in which the error occurred, and the results tab displays messages about the error.

Q7. Does this comment contain syntax errors?


Report created for budget
presentation; revised October 15.
****;
proc print data=sales;
run;
  • Yes. Every comment line must end with a semicolon.
  • No. The comment is correctly specified.
  • Yes. The comment is on more than one line.
  • Yes. There is a semicolon in the middle of the comment.

Q8. Based on the following program and data, which of the following is true.

proc print data=cities;
where STATE='ca';
run;
  • A syntax error is generated because STATE is uppercase in the program.
  • A syntax error is generated because single quotation marks are used in the WHERE statement.
  • There are no syntax errors, and three rows are printed.
  • There are no syntax errors, but no rows are printed.

Quiz 2: Programming Question 1.02

Q1. If necessary, start SAS Studio. Open p101q2.sas from the programs folder. Note: An earlier version of this SAS program used sashelp.demographics. if you have that version in your programs folder, copy and paste this code that uses sashelp.heart instead.

Identify and fix the syntax errors.

Run the program.

How many individuals are in the Optimal category for BP_Status?

Enter answer here

Q2. What is the average Systolic value for those patients with Optimal blood pressure status?

Enter answer here

Quiz 3: Accessing Data Review Questions

Q1. SAS tables consist of which of the following components?

  • info portion and DATA step
  • descriptor portion and data portion
  • descriptor portion and value portion
  • PROC step and DATA step

Q2. What type of variable is Salary in the table below?

  • either character or numeric
  • numeric
  • character
  • cannot tell from the data shown

Q3. With the system option VALIDVARNAME=V7, which of the following variable names is valid?

  • 4BirthDate
  • $Cost
  • Items
  • Tax-Rate
  • all of the above

Q4. Which of the following files is a permanent SAS file?

  • Work.PrdSale
  • MySales
  • Certxl.Quarter1
  • all of the above

Q5. What is the default length for the SAS date column BillDate?

  • 8
  • unknown
  • 9
  • 10

Q6. Which LIBNAME statement defines the states library to read SAS files in the myfiles\popstats folder on the C: drive?

  • libname states ‘c:\myfiles\’;
  • libname base states ‘c:\myfiles\popstats’;
  • libname states sas ‘c:\myfiles\popstats’;
  • libname states ‘c:\myfiles\popstats’;

Q7. Which data source could be read using a library?

  • Microsoft Excel workbook
  • tab-delimited file
  • comma-delimited file
  • all of the above

Q8. When you specify an engine for a library, what are you specifying?

  • the name of a folder or directory where files are stored
  • credentials to access protected files
  • instructions for creating temporary SAS files
  • the file format for files that are stored in the library

Q9. Which option must be added to the PROC IMPORT statement to read a tab-delimited file?

proc import datafile="d:/mydata/tourism.tab"
out=tourism replace;
run;
  • TAB
  • DBMS=TAB
  • DLM=TAB
  • DLM=” “

Q10. Which statement about the CONTENTS procedure is false?

  • PROC CONTENTS can be used to list all tables in a library.
  • The PROC CONTENTS report includes the engine used to read the data.
  • PROC CONTENTS lists a sample of the first five rows from the data.
  • The PROC CONTENTS report displays all column attributes.

Q11. Which of the following statements lists the contents of the orion library in a report and suppresses the full detailed report for each individual table?

  • proc contents data=orion;
  • proc contents data=orion.all;
  • proc contents data=orion.all nods;
  • proc contents data=orion / all nods;

Quiz 4: Programming Question 1.03

Q1. If necessary, start SAS Studio and submit the libname.sas program to redefine the cr library.

Write and submit a program that generates a report that lists the tables in the cr library. You do not need to examine the full descriptor portion of each table.

How many SAS tables are in the cr library?

Enter answer here

Quiz 5: Programming Question 1.04

Q1. If necessary, start SAS Studio and run libname.sas. Write and submit a program to do the following:


Read the payroll.csv text file in the data folder and create a temporary SAS table named payroll. Enable SAS to scan all the rows from the text file to determine column attributes in the payroll table.

Generate a report of the descriptor portion of the payroll table.

What is the value of Employee_Term_Date for row 23? Note: Type the value exactly as it is displayed.

Enter answer here

Q2. According to the report, what engine is used to read the payroll table?

Enter answer here

Quiz 6: Programming Question 1.05

Q1. If necessary, start SAS Studio and run libname.sas. Write and submit a program to do the following:

Directly read the employee.xlsx file in the data folder. Ensure that column names follow the recommended SAS naming rules.

Generate a report of the descriptor portion for each table read from the employee.xlsx file.

Which column name was automatically changed to follow recommended SAS naming rules? Type the name of the original column before it was changed.

Enter answer here

Q2. What type is Employee_ID in both worksheets?

  • character
  • numeric

Quiz 7: Exploring Data Review Questions

Q1. What does a PROC PRINT report display by default?

  • PROC PRINT displays all rows and column in the table. If you want an additional column for row numbers, you can request it.
  • PROC PRINT displays all rows and columns in the table, a column for row numbers on the far left, and columns in the order in which they occur in the table.
  • PROC PRINT does not create a default report. You must specify the rows and columns to be displayed.
  • PROC PRINT displays columns in the following order: a column for row numbers, all character columns, and all numeric columns.

Q2. Which procedure produces a report that lists the number of rows for each distinct value in a selected column?

  • CONTENTS
  • MEANS
  • FREQ
  • PRINT

Q3. Which FORMAT statement produces the following results?

  • format Order_Date ddmmyyyy. Cost_Price Retail_Price dollar10.2;
  • format Order_Date ddmmyy10. Cost_Price Retail_Price dollar10.2;
  • format Order_Date date10. Cost_Price Retail_Price $10.2;
  • format Order_Date dmy10. Cost_Price Retail_Price dollar10.2;

Q4. Which statement in PROC MEANS specifies the numeric columns to summarize?

  • COL
  • TABLES
  • VAR
  • MEANS

Q5. Which statement selects rows with BirthDate on or after January 1, 1980?

  • where BirthDate ge 1/1/1980;
  • where BirthDate ge “01JAN1980″d;
  • where BirthDate >= ‘1/1/1980’d;
  • where Birthdate >= “01JAN1980”;

Q6. Which statement selects ProductID values with CX as the second and third letters in the string?

  • where ProductID like “%CX%”;
  • where ProductID like “CX“;
  • where ProductID like “_CX%”;
  • where ProductID like “_CX*”;

Q7. Which statement selects rows where Country is either Argentina or Brazil?

  • where Country=”Argentina” or Country=”Brazil”;
  • where Country in(“Argentina”, “Brazil”);
  • where Country in(“Argentina” “Brazil”);
  • all of the above

Q8. True or False: This PROC PRINT step creates a report that lists only those rows where Location is Maui.

%let island=Maui;
proc print data=tourism;
where Location='&island';
run;
  • True
  • False

Q9. Which step creates a new, temporary sorted table named calc?

proc sort data=work.calc out=finance.dividend;
run;
proc sort dividend out=calc;
by account;
run;
proc sort data=finance.dividend out=work.calc;
by account;
run;
proc sort from finance.dividend to calc;
by account;
run;

Q10. Given the following program and data, how many rows will there be in the quizdups table?

proc sort data=quiz nodupkey dupout=quizdups;
by Name;
run;
  • zero
  • one
  • three
  • four

Quiz 8: Programming Question 1.06

Q1. If necessary, start SAS Studio. Open p103q1.sas from the programs folder.

  • Identify and fix the syntax errors.
  • Run the program.
  • What is the name of the first player listed in the baseball_sort table?
  • Anderson, Dave
  • Harper, Terry

Q2. How many rows are included in the PROC PRINT result?

Enter answer here

Q3. Which value of Position has the most players?

Enter answer here

Q4. What is the average value of the Salary column? Note: Type your answer exactly as the value is displayed.

Enter answer here

Quiz 9: Programming Question 1.07

Q1. If necessary, start SAS Studio and run libname.sas. Write and submit a program that uses procedures to evaluate whether the data in the cr.employee_raw table meets the requirements listed below.

Requirements:

Values in the EmpID column must be unique.

Values in the Country column should be either US or AU.

There are 17 unique department names.

If TermDate has a known value, it should be after HireDate.

Which value of EmpID occurs more than once?

Enter answer here

Q2. How many rows in the Country column violate the data rules? Note: Type a number for your answer.

Enter answer here

Q3. What is the name of the department that has the most employees?

Enter answer here

Q4. How many rows have a known value for TermDate that is before HireDate? Note: Type a number for your answer.

Enter answer here

Quiz 10: Programming Question 1.08

Q1. If necessary, start SAS Studio and run libname.sas. Write and submit a program to read the cr.employee_raw table and create a new sorted table named emp_sort. Sort rows by all columns and remove entirely duplicated rows.

What is the value of EmpID for observation 10 in the emp_sort table?

Enter answer here

Q2. In your program, write and submit a procedure step to read the emp_sort table and create a listing of all employees with a JobTitle that includes Logistics.

What year was the most recent person hired in the group? Note: Type your answer as a 4-digit year.

Enter answer here

Q3. In your program, write and submit a procedure step to read the emp_sort table and answer this question:

What is the average salary for employees with a hire date on or after January 1, 2010, and a missing value for TermDate? Note: Type your answer exactly as the value is displayed.

Enter answer here

Q4. In your program, write and submit a procedure step to read the emp_sort table and answer this question:

What is the third highest salary among all employees? Note: Type your answer exactly the way the value is displayed.

Enter answer here

Weeks 2 Quiz Answers

Quiz 1: Preparing Data Review Questions

Q1. In which phase does the DATA step read rows from the input table?

  • execution
  • compilation

Q2. Which statement about the following program is true?

data australia;
set orion.sales;
where Country='AU';
run;
  • The program reads a temporary table and creates a permanent table.
  • The program does not execute because of syntax errors.
  • The program reads a permanent table and creates a temporary table.

Q3. Given the assignment statement below, what is the value of AvgQ for the row that is shown?

  • AvgQ=mean(Q1, Q2, Q3, Q4);
  • 3
  • 4
  • . (missing value)
  • The statement generates a syntax error.

Q4. Which expression extracts the first five positions from PostalCode?

  • PostalCode5=substr(PostalCode, 5);
  • PostalCode5=substr(PostalCode, 1, ‘-‘);
  • PostalCode5=substr(PostalCode,1-5);
  • PostalCode5=substr(PostalCode, 1, 5);

Q5. Which statement about the following program is true?

data customer_age;
set orion.customers;
drop BirthDate;
Age=yrdif(BirthDate, today(),"AGE");
run;
  • Age is calculated as a precise number of years (including decimal values).
  • Age is calculated and rounded to the nearest whole number.
  • Age is not calculated because the DROP statement is before the assignment statement.
  • Age is not calculated because the TODAY function does not include any arguments.

Q6. Which of the following is a way that the length of a new variable could be set in the DATA step?

  • by the length of the variable the first time it is referenced in the DATA step
  • in an assignment statement
  • using a LENGTH statement
  • all of the above

Q7. What is the length of the variable Type that is created in the DATA step below?

data work.newloan;
set cert.records;
if code='1' then Type='Fixed';
else Type='Variable';
length type $ 10;
run;
  • 5
  • 8
  • 10
  • It depends on the first value of Type in the cert.records table.

Q8. In the program below, what is the value of Region if Area is nw?

data work.bonus;
set orion.sales;
length Region $ 5;
if Area in('NW', 'SW') then Region='West';
else if Area in('NE', 'SE') then Region='East';
else Region='Other';
run;
  • West
  • East
  • Other
  • Missing

Q9. In the program below, what is the value of Region if Area is SW ?

data work.bonus;
set orion.sales;
length Region $ 5;
if Area in('NW', 'SW') then Region='West';
if Area in('NE', 'SE') then Region='East';
else Region='Other';
run;
  • West
  • East
  • Other
  • missing

Q10. True or False: This program will successfully create two tables, east and west, separating the rows from the orion.sales table.

data west east;
set orion.sales;
if Area in('NW', 'SW') then do;
Region='West’;
output west;
if Area in('NE', 'SE') then do;
Region='East'
output east;
run;
  • True
  • False

Quiz 2: Programming Question 2.01

Q1. If necessary, start SAS Studio. Open and examine the sashelp.holiday table.

  • Open p104q1.sas from the programs folder.
  • Identify and fix the syntax errors. The values of CountryCode should be the last two letters of Category. The output table should include the Desc, CountryCode, and Date columns.
  • Run the program.
  • How many holidays where CountryCode is CA are included in the output table? Note: Type a number for your answer.
  • Enter answer here

Q2. What value should be provided as the second argument of the SUBSTR function to correctly create the CountryCode column?

Enter answer here

Q3. What is the SAS date value for Boxing Day?

Enter answer here

Quiz 3: Programming Question 2.02

Q1. If necessary, start SAS Studio and submit libname.sas. Write and submit a new program to do the following:

Create a new table named sales and read cr.employee. Include only employees in the Sales Department with no termination date (TermDate).

Create a new column named SalesLevel based on the following values of JobTitle:

JobTitleSalesLevel
Sales Rep. IEntry
Sales Rep. II or Sales Rep. IIIMiddle
Sales Rep. IVSenior

Generate a report that includes the number of Sales employees in each level.

What is the total number of Sales employees?

Enter answer here

Q2. What is the total number of middle-level sales reps?

Enter answer here

Quiz 4: Programming Question 2.03

Q1. If necessary, start SAS Studio and submit libname.sas. Write and submit a program to do the following:

  • Create a new table named bonus and read cr.employee.
  • Exclude any employees with a known value for TermDate.
  • Use the YRDIF function to create a new column named YearsEmp that calculates the number of years that each person has been employed as of 01JAN2019.
  • For employees that have been employed 10 years or more, create a new column named Bonus that is 3% of Salary. Create another column named Vacation that is assigned the number 20.
  • For all other employees, calculate Bonus as 2% of Salary. Assign 15 as the value of Vacation.
  • Count the number of employees with 20 and 15 vacation days.
  • Sort the bonus table by YearsEmp in descending order.
  • How many employees are in the bonus table?
Enter answer here

Q2. How many years has the employee in row number 1 of the sorted bonus table been employed?

Enter answer here

Q3. How many employees have 20 vacation days?

Enter answer here

Q4. What is the bonus amount for the second employee listed in the sorted bonus table?

Enter answer here

Quiz 5: Analyzing Data Review Questions

Q1. If you run this program, which title or titles appear in the final PROC PRINT results?

title 'ABC Company';
title2 'Sales Report';
proc print data=sales;
run;
title2 'Inventory Report';
proc print data=inventory;
run;
  • ABC Company
    • Inventory Report
  • Inventory Report
    • ABC Company
  • Sales Report
    • Inventory Report

Q2. Which statement is true based on the given program?

data pressure;
set data.health;
BP=cats(Systolic, "/", Diastolic);
label BP_Status=
"Blood Pressure Status";
run;
proc print data=pressure(obs=10);
var BP BP_Status;
run;
  • The label for BP_Status appears in the FREQ report.
  • The label for BP_Status appears in the PRINT report.
  • The label for BP_Status appears in both reports.
  • The column BP_Status has a permanent label in the data.health table.

Q3. Which of the following statements about the BY statement in a reporting procedure is false?

  • First./Last. variables are created for each BY variable.
  • The BY statement can be used in the PRINT, MEANS, FREQ, and UNIVARIATE procedures.
  • The procedure results are grouped by the unique values of the BY variables.
  • The input data must be sorted by the BY variables.

Q4. Which statements must be added to this program to create the following report?

proc print data=employee;
where Department="Executives";
var Job_Title Salary;
format Salary dollar10.;
run;
  • id Employee_ID;
  • sum Salary;
  • keep Employee_ID Job_Title Salary;
  • a and b
  • b and c

Q5. By default, PROC FREQ creates a table of frequencies and percentages for which column types?

  • character columns
  • numeric columns
  • both character and numeric columns
  • None. Columns must always be specified.

Q6. Which TABLES statement can be used to create the following output?

  • tables Department*City;
  • tables Department*City / norow nocol;
  • tables Department City / crosslist;
  • tables Department City / freq percent;

Q7. Which option is not required in the PROC FREQ step to produce this output?

  • LIST
  • NLEVELS
  • NOCUM
  • ORDER=FREQ

Q8. Which statement about the MEANS procedure is true?

  • The input table must be sorted by the column(s) in the CLASS statement.
  • Default statistics include N, SUM, MEAN, MIN, and MAX.
  • The default output is a table.
  • Without a VAR statement, PROC MEANS summarizes all numeric columns from the input table.

Q9. Which WAYS statement creates the following report?

proc means data=employee;
var Salary;
class Country City;
run;
  • ways all;
  • ways 1, 2, 3;
  • ways 0 1;
  • ways 2;

Q10. True or False: To create the SumSalary and MedianSalary columns in the SalSum table, you must add the SUM and MEDIAN options to the PROC MEANS statement.

proc means data=employee noprint;
var Salary;
class Country City;
output out=SalSum;
ways 2;
run;
  • True
  • False

Quiz 6: Programming Question 2.04

Q1. If necessary, start SAS Studio. Open p105q1.sas from the programs folder.

Identify and fix the errors so that the program creates the output shown below.

Run the program.

What is the label for nHome in the sashelp.baseball table?

Enter answer here

Q2. Which option must be added so that the descriptive column heading text appears in the report?

Enter answer here

Q3. How many total home runs did Baltimore have?

Enter answer here

Q4. Which statement must be added so that the player’s name replaces the default OBS column?

Enter answer here

Quiz 7: Programming Question 2.05

Q1. If necessary, start SAS Studio and submit libname.sas. Write and submit a program to analyze the number of employees in the cr.employee table by City, Department, and JobTitle.

Which city has the highest number of employees?

Enter answer here

Q2. What percentage of all employees are in the Sales Department? Note: Type your answer exactly the way the value is displayed

Enter answer here

Q3. How many unique values of JobTitle are in the employee table?

Enter answer here

Quiz 8: Programming Question 2.06

Q1. If necessary, start SAS Studio and submit libname.sas. Write and submit a program to do the following:

Analyze frequency counts for the cr.profit table.

Create a two-way frequency table that includes the frequency count and percent for each Order_Date and Order_Source.

Display Order_Date using the MONNAME format so there is one row per month in the table.

How many retail orders were in December?

Enter answer here

Q2. What percentage of all orders were retail? Note: Type your answer exactly as the value appears in the report.

Enter answer here

Quiz 9: Programming Question 2.07

Q1. If necessary, start SAS Studio and submit libname.sas. Write and submit a program to do the following:

Calculate summary statistics for the cr.employee table.

Subset the rows to include only the Sales Department.

Calculate the sum, mean, minimum, and maximum of Salary for each value of JobTitle. Round values to the nearest whole number.

What is the total salary for all Sales employees combined? Note: Type the value exactly as it appears.

Enter answer here

Q2. What is the mean salary for Sales Rep. IV employees? Note: Type your answer exactly as shown.

Enter answer here

Quiz 10: Programming Question 2.08

Q1. If necessary, start SAS Studio and submit libname.sas. Write and submit a program to do the following:

Use PROC MEANS to read cr.employee and create a summary table named salary_summary. Do not create a report.

Compute statistics for Salary based on the values of Department and City.

In the output table, include a column named TotalSalary that is the sum of Salary and a column named AvgSalary that is the mean of Salary.

In the output table, include one row for each unique combination of Department and City.

How many rows are in the salary_summary table?

Enter answer here

Q2. What is the value of AvgSalary for the Administration Department in Sydney?

Enter answer here

Quiz 11: Exporting Data Review Questions

Q1. Which statement is false concerning the options for the PROC EXPORT statement?

  • The INFILE= option identifies the input SAS table.
  • The OUTFILE= option specifies the path and file name of the external data file being created.
  • The DBMS= option specifies the database identifier for the type of file being created.
  • The REPLACE option specifies to overwrite an existing file.

Q2. Which PROC EXPORT step contains valid syntax?

proc export outfile="c:\temp\sales.txt" tab
data=orion.sales replace;
run;
proc export data=orion.sales dbms=csv
outfile="c:\temp\cars.csv";
run;
proc export data=orion.sales; dlm=',';
outfile="c:\temp\cars.csv";
run;
proc export dbms=tab data=orion.sales replace=yes
outfile="c:\temp\cars.txt";
run;

Q3. True or False: This LIBNAME statement creates the midyear.xlsx file if it does not exist.

libname sales xlsx 'c:\mydata\midyear.xlsx';
  • True
  • False

Q4. What does the following program create?

libname hr xlsx ‘c:\mydata\employee.xlsx’;

data hr.US_Emp;
set orion.employee_master;
where Country='US';
run;
data hr.AU_Emp;
set orion.employee_master;
where Country='AU';
run;
  • two SAS tables: hr.US_Emp and hr.AU_Emp
  • two Excel workbooks: hr.US_Emp and hr. AU_Emp
  • two worksheets in the Excel workbook employee: US_Emp and AU_Emp
  • two worksheets in the Excel workbook employee_master: US_Emp and AU_Emp

Q5. Which of the following is not a valid output format when using the Output Delivery System (ODS)?

  • CSVALL
  • EXCEL
  • POWERPOINT
  • WORD
  • PDF
  • HTML

Q6. True or False: The following program creates a comma-delimited file that includes column headings and all rows from the employee SAS table.

ods csvall "c:/output/employee.csv";
proc print data=employee;
var ID Name Job_Title Hire_Date;
format Hire_Date ddmmyy8.;
run;
ods close;
  • True
  • False

Q7. True or False: Results can be written to multiple ODS destinations.

ods powerpoint file="c:/output/EmpCounts.pptx";
ods excel file="c:/output/EmpCounts.xlsx";
proc freq data=eg1.employee_master;
tables Country*Department;
run;
proc means data=eg1.employee_master;
var Salary;
class Country City;
  • True
  • False

Q8. Which option in an ODS statement changes the appearance of the output, including colors, fonts, and borders?

  • STYLE=
  • OPTIONS=
  • LAYOUT=
  • CSS=

Q9. Which statement contains valid syntax for specifying a worksheet name?

  • ods proctitle sheet_name=’Sales’;
  • ods excel sheet_name=’Sales’;
  • ods proctitle options(sheet_name=’Sales’);
  • ods excel options(sheet_name=’Sales’);

Q10. Suppose that you are creating an Excel file and a PDF file that include results from multiple SAS procedures. What determines the text of each worksheet name in the Excel file and the table of contents link in the PDF file?

  • assigned titles
  • procedure names
  • Sheet1, Sheet2, and so on
  • Output1, Output2, and so on

Quiz 12: Programming Question 2.09

Q1. If necessary, start SAS Studio. Open p106q1.sas from the programs folder.

Identify and fix the errors.

Run the code.

In the navigation pane, select the heart.xlsx file in the output folder. Click the download button and open the Excel file. Are the titles specified in the TITLE statements included in the spreadsheets?

  • Yes
  • No

Q2. How many worksheets are included in the Excel file?

Enter answer here

Quiz 13: Programming Question 2.10

Q1. If necessary, start SAS Studio. Open p106q2.sas from the programs folder. Modify the program to do the following:

Create a PDF file named truck.pdf in the output folder that combines the results of the two procedures without a page break between the reports.

Apply the Journal style.

In the navigation pane, find the truck.pdf file in the output folder. Right-click the file and select Download File. What is the label for the first bookmark in the PDF table of contents?

  • PROC FREQ Table
  • The Freq Procedure
  • PROC FREQ Output

Q2. Do both reports fit on a single page?

  • yes
  • no

Quiz 14: Programming Question 2.11

Q1. If necessary, start SAS Studio and submit libname.sas. Write a new program that uses PROC EXPORT to export cr.employee_current to the output folder as a comma-delimited file.

In the navigation pane, find the exported text file in the output folder. Right-click the file and select Properties. What is the file size, rounded to the nearest KB? Note: Type a number for your answer.

Enter answer here

Q2. In the navigation pane, right-click the file and select View File as Text. Which fields are enclosed in quotation marks?

  • Salary
  • Department
  • Name
  • JobTitle

Week 3 Quiz Answers

Quiz 1: Controlling DATA Step Processing Review Questions

Q1. Which of the following is not created during the compilation phase?

  • the data set descriptor portion
  • the program data vector
  • the N and ERROR automatic variables
  • the first observation

Q2. During the compilation phase, SAS scans each statement in the DATA step, looking for syntax errors. Which of the following is not considered a syntax error?

  • incorrect data values
  • missing or invalid punctuation
  • invalid options or formats
  • missing or misspelled keywords

Q3. nUnless otherwise directed, how many times does the DATA step loop execute?

  • once for each DATA step statement
  • once for each row in the input file
  • once for each column in the input file
  • once for each compilation phase

Q4. At the beginning of the execution phase, the value of N is 1, the value of ERROR is 0, and the values of the remaining variables are set to which of the following?

  • 0
  • 1
  • undefined
  • missing

Q5. Suppose you run a program that causes three data errors. What is the value of the automatic variable ERROR when the row that contains the third error is processed?

  • 0
  • 1
  • 2
  • 3

Q6. Which of the following actions occurs at the beginning of an iteration of the DATA step?

  • The automatic variables N and ERROR are incremented by 1.
  • The DATA step stops execution.
  • The descriptor portion of the data set is written.
  • The values of variables created in programming statements are reset to missing in the program data vector.

Q7. Consider the following DATA step. Based on the sample input file below, in what order are the variables stored in the new fin2 table?

data fin2;
set finance;
keep Name Raise NewSalary Date;
if Salary>25000 then Raise=0.03;
else Raise=0.05;
NewSalary=(Salary*Raise)+Salary;
run;
  • Name, Raise, NewSalary, Date
  • SSN, Name, Salary, Date, Raise, NewSalary
  • Name, Date, Raise, NewSalary
  • Salary, NewSalary, Name, Raise

Q8. If the input table contains five columns, which PUTLOG statements create the following results in the SAS log?

putlog "NOTE: Begin DATA Step";
putlog Name Sex Age Height Weight ERROR N;
putlog NOTE="Begin DATA Step";
putlog all;
putlog "NOTE: Begin DATA Step";
putlog all;
putlog NOTE(Begin DATA Step);
putlog all;

Q9. After this program runs, how many rows are in the forecast table, assuming that there are 10 rows in the sales table?

data forecast;
set sales;
Qtr=1;
Sales=Sales1.01; output; Qtr=2; Sales=Sales1.01;
output;
Qtr=3;
Sales=Sales*1.01;
  • 10
  • 30
  • 40
  • unknown

Q10. Suppose there are 1,000 total customers, and 200 of those customers have Gold status. After this code runs, how many rows are in the gold table and how many rows are in the other table?

data gold other;
set customers;
if Status="Gold" then output gold;
run;
  • 200 in gold and 800 in other
  • 200 in gold and 0 in other
  • 1000 in gold and 0 in other
  • 1000 in gold and 800 in other

Q11. After this code runs, how many columns are in the Canada table if there are 10 columns in the input customer table?

data Canada(drop=State Zip) US(drop=Province);
set customer(keep=ID Name Country Status
Sales State Zip Province);
if Country=”Canada” then output canada;
else if Country=”US” then output us;
drop Country;
run;

  • 5
  • 6
  • 7
  • 10

Quiz 2: Programming Question 4.01

Q1. If necessary, start SAS Studio and submit libname.sas. Open p201q1.sas from the programs folder. Fix the program to ensure that the following actions occur:

Values of Country should all be uppercase in the output tables.

Include only rows where TermDate is missing.

All rows where Country is US are written to the emp_US table.

All rows where Country is AU are written to the emp_AU table.

How many rows are in the emp_US table?

Enter answer here

Q2. How many rows are in the emp_AU table?

Enter answer here

Quiz 3: Programming Question 4.02

Preparing for the SAS Programming Certification Exam Course Review

In our experience, we suggest you enroll in Preparing for the SAS Programming Certification Exam courses and gain some new skills from Professionals completely free and we assure you will be worth it.

Preparing for the SAS Programming Certification Exam Course for free, if you are stuck anywhere between a quiz or a graded assessment quiz, just visit Networking Funda to get Preparing for the SAS Programming Certification Exam Quiz Answers.

Conclusion:

I hope this Preparing for the SAS Programming Certification Exam Quiz Answer would be useful for you to learn something new from this Course. If it helped you then don’t forget to bookmark our site for more Quiz Answers.

This course is intended for audiences of all experiences who are interested in learning about new skills in a business context; there are no prerequisite courses.

Keep Learning!

Get All Course Quiz Answers of SAS Programmer Professional Certificate

Getting Started with SAS Programming Quiz Answers

Doing More with SAS Programming Coursera Quiz Answers

Preparing for the SAS Programming Certification Exam

Practicing for the SAS Programming Certification Exam

Leave a Reply

Your email address will not be published.

error: Content is protected !!