FREE SAS Programming & Syntax Questions and Answers

Question 1

What is the purpose of a 'DATA' step in SAS?

Accepted Answer

To create datasets and manipulate data.

Answer

To display results of a procedure.

Answer

To define the format of the output.

Answer

To connect to a database.

Question 2

Which of the following is the correct syntax to read in a CSV file in SAS?

Accepted Answer

Answer

proc import datafile='file.csv';

Answer

data import; infile 'file.csv';

Answer

proc import datafile='file.csv' out=mydata;

Answer

proc import file='file.csv';

Question 3

How would you create a new variable in a SAS 'DATA' step?

Accepted Answer

all of the above.

Answer

newvar = oldvar + 10;

Answer

newvar = oldvar;

Answer

newvar = 'value';

Question 4

What is the function of 'PROC PRINT' in SAS?

Accepted Answer

It prints the contents of a dataset.

Answer

It performs statistical analysis.

Answer

It sorts the dataset.

Answer

It merges two datasets.

Question 5

What is the correct way to define a macro variable in SAS?

Accepted Answer

Answer

%let var = value;

Answer

let var = value;

Answer

var = value;

Answer

%define var = value;

Question 6

Which of the following SAS procedures is used for descriptive statistics?

Accepted Answer

PROC MEANS.

Answer

PROC PRINT.

Answer

PROC SQL.

Answer

PROC UNIVARIATE.

Question 7

What does the 'INFILE' statement do in SAS?

Accepted Answer

It identifies the external file to read data from.

Answer

It specifies where to store the dataset.

Answer

It sorts the input file.

Answer

It merges multiple files.

Question 8

Which SAS function would you use to compute the mean of a numeric variable?

Accepted Answer

all of the above.

Answer

MEAN.

Answer

AVG.

Answer

PROC MEANS.

Question 9

How do you check for missing values in a dataset in SAS?

Accepted Answer

Using the 'IS MISSING' function.

Answer

Using the 'IF' statement.

Answer

Using the 'MISSING' function.

Answer

None of the above.