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)
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)
