SAS EXAM QUESTIONS AND ANSWERS

SAS EXAM QUESTIONS AND
ANSWERS
SAS stands for - answer- Statistical Analysis System

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

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

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

4 uses for data statements - answer- 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 - answer- create report that lists data, produce descriptive
statistics, create summary report, produce plots and charts, produce other SAS
datasets

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

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

default length of all sas variables - answer- 8

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

keyword used in proc sort to keep dataset in original order - answer- 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 - answer- 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 - answer- 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 -
answer- tables

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

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

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

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

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

keyword used to print only certain variables in proc print/proc means output -
answer- var

proc print data = ia.data;
var x;
run;

keyword used to print column totals for numeric variables in proc print output -
answer- sum

proc print data = ia.data;
sum x;
run;

keyword used to replace a variable value with observation number - answer- id

proc print data = ia.data;
id x;
run;

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