The DATA step checks for syntax errors in the compilation phase.

Checking for syntax errors is the first step in the compilation phase.

In which phase does the DATA step check for syntax errors?

Checking for syntax errors is the first step in the compilation phase.

Which statement is used to read a SAS data set in a DATA step?

The SET statement indicates the table that will be read. The DATA statement indicates the table that will be created or updated.

Which of the following is true about the SET statement in a DATA step?

The SET statement indicates the input table or table that you are reading.

Which statement is used to create or update a SAS table in a DATA step?

The DATA statement indicates the output table or table you want to create or update.

To process a CSV file with the DATA step, you must first create a copy of the data as a SAS table.

SAS does not have a CSV engine to directly read comma delimited files. The PROC IMPORT step reads data from an external data source and writes it to a SAS table; you process the data with the DATA step.

You can read data directly from an Excel worksheet by using the XLSX LIBNAME engine.

You can use the XLSX LIBNAME engine to read an Excel worksheet directly and process the data with the DATA step.

To process an Excel file with the DATA step, you must first create a copy of the data as a SAS table.

You can use the XLSX LIBNAME engine to read an Excel worksheet directly and process the data with the DATA step.

What is the name of the input data set in the program below? data work.au; set data.sales; where Country='AU'; run;

The SET statement indicates the input table table that is being read.

What is the name of the output data set in the program below? data work.us; set orion.sales; where Country='US'; run;

The output table is listed in the DATA statement.

Which statement in the program below creates the output table? <pre> </pre>

The DATA statement indicates the output table or table you want to create or update.

The data set orion.sales contains nine columns. Given this DATA step, how many columns does work.comp have? <pre> data work.comp; set orion.sales; keep employee_id status job_title salary; run; </pre>

Only the four columns listed in the KEEP statement are written to the work.comp table.

The data set data.stock contains sixteen columns. Given the DATA step, how many columns does work.carsales have? <pre> data work.carsales; set data.stock; drop make model midsize_gas midsize_electric economy; run; </pre>

The columns listed in the DROP statement are omitted from the work.carsales table.

The data set american.stock contains 12 columns and you want 10 of those columns included in the output table. Which statement would be most appropriate?

The DROP statement is the most appropriate because you only specify the 2 columns to drop from the output table.

Given the assignment statement below, which of the following is true regarding the value of AvgExp for the observation that is shown? AvgExp=mean(Exp1, Exp2, Exp3, Exp4); <table> <tbody> <tr> <td> Exp1 </td> <td> Exp2 </td> <td> Exp3 </td> <td> Exp4 </td> </tr> <tr> <td> 2 </td> <td> 7 </td> <td> 3 </td> <td> . </td> </tr> </tbody> </table>

The MEAN function ignores missing values and calculates the known values, so the calculation is (2+7+3)/3=4.

Given the assignment statement below, what is the value of AvgExp for the observation that is shown? AvgExp=mean(Exp1, Exp2, Exp3, Exp4); <table> <tbody> <tr> <td> Exp1 </td> <td> Exp2 </td> <td> Exp3 </td> <td> Exp4 </td> </tr> <tr> <td> 8 </td> <td> 3 </td> <td> 7 </td> <td> . </td> </tr> </tbody> </table>

The MEAN function ignores missing values and calculates the known values, so the calculation is (8+3+7)/3=6.

Given the assignment statement below, what is the value of AvgExp for the observation that is shown? AvgExp=mean(Exp1, Exp2, Exp3, Exp4); <table> <tbody> <tr> <td> Exp1 </td> <td> Exp2 </td> <td> Exp3 </td> <td> Exp4 </td> </tr> <tr> <td> 10 </td> <td> . </td> <td> 5 </td> <td> 9 </td> </tr> </tbody> </table>

The MEAN function ignores missing values, so the calculation is (10+5+9)/3=8.

Which of the following SAS functions returns a number from 1 to 4?

The QTR function returns a number from 1 through 4 that represents the quarter extracted from a SAS date value.

Which of the following SAS functions returns a number from 1 to 12?

The MONTH function returns the month number (1-12) extracted from a SAS date value.

Which of the following SAS functions returns a number from 1 to 31?

The DAY function returns a number from 1 through 31 that represents the day of the month extracted from a SAS date value.

In the program below, what is the value of Credit if Country is 'au'? data work.bonus; set orion.sales; if Country='US' then Credit=300; else if Country='AU' then Credit=500; else Credit=0; run;

The character conditions are case sensitive. The first two IF conditions are false. Therefore, the final ELSE statement assigns Credit a value of zero.

The first IF condition is true. Therefore, SAS assigns the value 265 to Credit and skips the rest of the conditional processing statements. <pre> data work.payment; set orion.sales; if Country='US' then Credit=265; else if Country='AU' then Credit=377; else Credit=0; run; </pre>

The first IF condition is true. Therefore, SAS assigns the value 265 to Credit and skips the rest of the conditional processing statements.

In the program below, what is the value of Credit if Country is 'DK' ? <pre> data work.payment; set orion.sales; if Country='US' then Credit=265; else if Country='AU' then Credit=377; else if Country='EG' then Credit=400 else Credit=100; run; </pre>

The first three IF conditions are false. Therefore, the final ELSE statement assigns the value 100 to Credit. There is no need to test the condition because all preceding conditions are false.

What is the length of the Position column created in this program? data position_salary; set orion.salaries; if salary>70000 then position="Manager"; else position="Employee"; length position $ 9; run;

When the DATA step is compiled, the first mention of Position determines the column name, type, and length. The length is determined by the value in the assignment statement. The value of Manager has seven characters, so the length is 7.

What is the length of the Position column created in this program? data position_salary; set orion.salaries; length position $ 11; if salary>65000 then position="Engineer2"; else if salary>52000 then position="Engineer"; else if salary>50000 then position="Technician2"; else position=”Technician”; run;

When the LENGTH statement is placed before the conditional processing statements it explicitly defines the column name, type, and length.

What is the length of the Car_Type column created in this program? <pre> data car_type; set sashelp.cars; if msrp>80000 then car_type="luxury"; else car_type="regular"; length car_type $ 8; run; </pre>

When the DATA step is compiled, the first mention of Car_Type determines the column name, type, and length. The length is determined by the value in the assignment statement. The value luxury has six characters, so the length is 6.

Use a DO group in a DATA step when you want to execute multiple statements for a true IF-THEN expression.

To execute more than one statement if a condition is true, you must use IF-THEN/DO groups.

Use a DO group in a PROC step when you want to execute multiple statements for a true IF-THEN expression.

IF-THEN/DO groups are used to execute more than one statement if a condition is true and are only valid in DATA steps.

Use an AND operator in a DATA step when you want to execute multiple statements for a true IF-THEN expression.

IF-THEN/DO groups are used to execute more than one statement if a condition is true.

Skip to content

Search

Join/Contribute Explore

Filters

Getting Started with SAS Programming

Home » Courses » Getting Started with SAS Programming

Preparing Data

10 Questions Week 4

Exploring and Validating Data

10 Questions Week 3

Getting Started with SAS Programming

Accessing Data

10 Questions Week 2

Getting Started with SAS Programming

Essentials Review

9 Questions Week 1

Getting Started with SAS Programming

Analyzing and Reporting on Data

10 Questions Week 5

Getting Started with SAS Programming

Exporting Results

10 Questions Week 6

Getting Started with SAS Programming

Using SQL in SAS

10 Questions Week 6

Getting Started with SAS Programming

Re⥃Askly Is An Educational Website Powered By Experience With Focused On A Specific Career Goal.

About Us Privacy Policy Terms Of Services Contact Us

Search

Certified

About Us Privacy Policy Terms Of Services Contact Us

Search

Re⥃askly » Repeat & Ask

Search

About Us Privacy & Policy

Terms Of Services Contact Us

Re⥃askly is an educational website powered by experience with focused on a specific career goal.