SAS EXAM QUESTIONS & ANSWERS

SAS EXAM QUESTIONS & ANSWERS
SAS stands for - Answers -Statistical Analysis System

4 data-driven tasks for SAS - Answers -data access, data management, data analysis,
data presentation

file extension for (log file, code, output, dataset) - Answers -.log, .sas, .out, .sas7bdat

3 ways to create sas dataset - Answers -from scratch, from raw dataset, from existing
sas dataset

4 uses for data statements - Answers -create SAS dataset from scratch, create SAS
dataset from raw dataset, check for and correct errors in a dataset, create a SAS
dataset from existing SAS datasets

5 uses for proc statements - Answers -create report that lists data, produce descriptive
statistics, create summary report, produce plots and charts, produce other SAS
datasets

base date for sas dates - Answers -January 1, 1960

the sas variable (name/value) is case sensitive, but the sas varaible (name/value) is not
case sensitive. - Answers -value, name

default length of all sas variables - Answers -8

number of digits sas can hold for numeric variable values before converting them to
scientific notation - Answers -12

keyword used in proc sort to keep dataset in original order - Answers -out

proc sort data = ia.employee out = ia.employee_sorted;
by x;
run;

keyword used in proc sort to remove observations that have repeat values for every
variable

example - Answers -nodup

proc sort data = ia.data nodup;
by x;
run;

, keyword used in proc sort to remove observations that have repeat values for sorted
variable - Answers -nodupkey

proc sort data = ia.data nodupkey;
by x;
run;

keyword used in proc freq to identify variable(s) to be used in frequency tables -
Answers -tables

proc freq data = ia.employee;
tables x y x*y;
run;

keyword used for conditional statements in proc statements - Answers -where

proc freq data = ia.data;
where x=1;
tables y;
run;

keyword used to export proc freq results to sas dataset - Answers -out

proc freq data = ia.data;
tables x / out = employee_temp;
run;


keyword used to change the variable name to be printed in proc print output - Answers -
label (x2)

proc print data = ia.data label;
label x = 'employee';
run;

instruction to compare variables and/or constants in order to extract, add, or adjust
variables in a SAS dataset - Answers -operator

4 types of operators - Answers -arithmetic operator, comparison operator, logical
operator, special operator

keyword that removes page number from output - Answers -nonumber

options nonumber;

options number;