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

Question : Which of the given procedure can generate below output


1. proc freq data=course2017 ;
TABLES COURSE_NAME*FEE ;
run;

2. proc freq data=course2017 ;
VAR COURSE_NAME*FEE ;
run;

3. Access Mostly Uused Products by 50000+ Subscribers
CLASS COURSE_NAME*FEE ;
run;

4. proc freq data=course2017 ;
BY COURSE_NAME*FEE ;
run;


Correct Answer : Get Lastest Questions and Answer :
Explanation: Two way frequency: Use the * between two variables. For each category of the course and for various fees across the observation
it will be printed.
First Variable COURSE_NAME will create rows
Second variable FEE will create columns for distinct frequencies
You need to use TABLES statement for creating n-way cross tabulation.





Question : Which of the following procedure will generate given output?


1. proc freq data=course2017 ;
TABLES COURSE_NAME*FEE nofreq norow nocol; ;
run;

2. proc freq data=course2017 ;
TABLES COURSE_NAME*FEE LIST nofreq norow nocol; ;
run;

3. Access Mostly Uused Products by 50000+ Subscribers
TABLES COURSE_NAME*FEE / nocol; ;
run;

4. proc freq data=course2017 ;
TABLES COURSE_NAME*FEE / nofreq norow nocol; ;
run;


Correct Answer : Get Lastest Questions and Answer :
Explanation: As we can see in the result it is a cross tabulation of two variables named COURSE_NAME and FEE.
Now the only value which is presented is cell percent and other will not be generated. To do this there are various option which can be used using the /
in the TABLES statement.
A. NOFREQ : Remove frequency values
B. NOCOL : Remove Column frequencies
C. NOROW: Remove the row level percentage.
D. NOPERCENT : Remove percent





Question : You have been asked to create a report in various formats. You have started to write SAS program to generate the reports. How many types of
output you can generate using ODS statement?


1. 1

2. 2

3. Access Mostly Uused Products by 50000+ Subscribers

4. As such there is no limit


Correct Answer : Get Lastest Questions and Answer :
Explanation: You can write as many ODS statements as you want and create that many output. You need to open the ODS destination for each
type of output you want to create.

Related Questions

---

Question :
The SAS program is submitted:

If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?

1. ' ' (missing character value)
2. Unknown
3. Access Mostly Uused Products by 50000+ Subscribers
4. SENIOR PILOT


Question :
Given the contents of the raw data file 'EMPLOYEE.TXT'

Which SAS informat correctly completes the program?


1. date9
2. mmddyy10
3. Access Mostly Uused Products by 50000+ Subscribers
4. mondayyr10


Question :
Given the SAS data set WORK.P2000:



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


Question :
The following SAS program is submitted:

What is the value of the second variable in the data set WORK.AUTHORS?

1. Hemingway
2. Hemingwa
3. Access Mostly Uused Products by 50000+ Subscribers
4. The program contains errors. No variables are created.


Question : You have set YEARCUTOFF= (which is default as well). Now you have date as //. How this date will be read by SAS, when you have
specified the format as MMDDYY8.?


1. 13-Aug-2025

2. 13-Aug-1925

3. Access Mostly Uused Products by 50000+ Subscribers

4. 13-Aug-1920



Question : You have been given below SAS data in raw file


Where second and third field of the date will give you startDate and endDate of training course, which of the following will give you the correct value
for course duration?


1. endDate-startDate

2. endDate-startDate+1

3. Access Mostly Uused Products by 50000+ Subscribers

4. startDate-endDate

5. (startDate-endDate)*24