In: Computer Science
Which of the following SAS statement(s) could not be used under “Proc Means” Step? Check all that apply. A. CLASS Statement B. BY Statement C. TITLE Statement D. VAR Statement E. WHERE Statement F. TABLES Statement
ANS:-
PROC MEANS is one of the most common SAS procedure used for analyzing data. It is mainly used to calculate descriptive statistics such as mean, median, count, sum etc.
The syntax of the PROC MEANS statement is:
PROC MEANS <options>; <statements>;
A) CLASS Statement is used under "PROC MEANS" for grouping of data we use class statement
Example:- Proc Means data = test N NMISS NOLABELS;
Class Age;
Var q1 - q5;
Run;
B)BY Statement is used under "PROC MEANS" for separeting the groups .
Example:-proc sort data= test;
by age;
run;
C)TITEL Statement is not used under "PROC MEANS".
D)WAR Statement is used under "PROC MEANS" in the VAR we need to refer the numeric variables thwt we want to analyze.
Example:- Proc Means Data = test;
Var q1 - q5;
Run;
E)WHERE Statement is used under "PROC MEANS" to filter or subset data.
Example:-Proc Means Data = test noprint;
Where Q1 > 1;Class Age;
Var q1 - q5 ;
Output out=F1(drop= FREQ) mean= median= / autoname;
Run;
F)TABLES Statement is not used under "PROC MEANS".