Base SAS Certified Associate: Programming Fundamentals Using SAS Questions and Answers (Dumps and Practice Questions)

Question : You have been given a data set named HESAMPLE with the column variables named COURSE_ID, COURSE_NAME, COURSE_FEE, STUDENTS. TRAINING_DATE
etc. which of the following is not a good fit for descriptive analytics using MEANS PROCEDURE?


1. COURSE_ID

2. COURSE_NAME

3. Access Mostly Uused Products by 50000+ Subscribers

4. STUDENTS

5. TRAINING_DATE


Correct Answer : Get Lastest Questions and Answer :
Explanation: ID number just an unique if for the variables. Hence, there is no point of generating statistics for that variable.




Question : You have been using PROC MEANS procedure for descriptive analytics, which of the following statement is true when you want to categorize
the data using BY statement?
A. Data must be already sorted or indexed in the order of the by statement.
B. Output will be generated in multiple tables instead of single
C. Data must not be already sorted or indexed in the order of the by statement.
D. Output will be generated in single tables instead of single


1. A,B
2. B,C
3. Access Mostly Uused Products by 50000+ Subscribers
4. A,D
5. B,D

Correct Answer : Get Lastest Questions and Answer :
Explanation: When you use MEANS procedure and By statement for the categorization of the data.
Using the By statement: Similar to Class you can use By statement for categorization. However, By statement
A. Data must be already sorted or indexed in the order of the By statement.
B. So you can use the SORT procedure for that.
C. Output will be generated in multiple tables instead of single





Question : Which of the given SAS code will generate the below output


1. proc means data=course2017 ;
by course_name fee;
run;

2. proc means data=course2017 ;
class course_name fee;
run;

3. Access Mostly Uused Products by 50000+ Subscribers
class fee course_name;
run;

4. proc means data=course2017 ;
class course_name ;
run;


Correct Answer : Get Lastest Questions and Answer :
Explanation: As looking at the output you can see that it has been categorized on two variables course_name and fee. Hence option 4 is out.
Now the main point here is between By and class. Remember By statement will always generate multiple tables for multiple variables. Here in the output
only 1 table is given Hence option 1 is out. Also the order of the variable will be maintained from the class statement hence option 2 is correct.

Related Questions

---

Question :


1. a
2. b
3. Access Mostly Uused Products by 50000+ Subscribers
4. d




Question :
Which of the programs correctly invokes the DATA Step Debugger?

1. a
2. b
3. Access Mostly Uused Products by 50000+ Subscribers
4. d


Question :
Which step sorts the observations of a permanent SAS data set by two variables and stores the sorted
observations in a temporary SAS data set?

1. proc sort out=EMPLOYEES data=EMPSORT;
by Lname and Fname;
run;
2. proc sort data=SASUSER.EMPLOYEES out=EMPSORT;
by Lname Fname;
run;
3. Access Mostly Uused Products by 50000+ Subscribers
run;
4. proc sort data=SASUSER.EMPLOYEES out=SASUSER.EMPSORT; by Lname and Fname;
run;


Question :
Consider the data step:
Which of the following assignment statements for
variable group are functionally equivalent to the original
statement used in the above data step?

1. if Age not in(15,16) then Group=1; else Group=2;
2. if (Age NE 16) or (Age NE 15) then Group=1; else Group=2;
3. Access Mostly Uused Products by 50000+ Subscribers
4. both A or C will work



Question :
The following SAS program is submitted:
data WORK.ACCOUNTING;
set WORK.DEPARTMENT;
length EmpId $6;
CharEmpid=EmpId;
run;
If data set WORK.DEPARTMENT has a numeric variable EmpId. Which statement is true about the
output dataset?


1. The type of the variable CharEmpid is numeric.
2. The type of the variable CharEmpid is unknown.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The program fails to execute due to errors.



Question :
The following SAS program is submitted:
data WORK.OUTDS;
do until(Prod GT 6);
Prod + 1;
end;
run;
What is the value of the variable Prod in the output data set?


1. . (missing)
2. 6
3. Access Mostly Uused Products by 50000+ Subscribers
4. Undetermined, infinite loop.