Premium

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



Question : You have been looking a SAS program written by your team mate. However, he has not done formatting of the code.
He has used Proc print , to display data in the output window.
Below is the code, which is written by your team mate. Please find the total number of statement in this code.

proc print data=EmployeeInfo
label double;
var name age salary bonus; where sex='male';
label sex='SEX'; run;

: You have been looking a SAS program written by your team mate. However, he has not done formatting of the code.
1. three
2. four
 3. Access Mostly Uused Products by 50000+ Subscribers
4. six

Correct Answer : Get Lastest Questions and Answer :

Explanation: In SAS program formatting does not matter when you run it. And each statement is separated by ; . Hence , there are in total 5 statements as below.

1. proc print data=EmployeeInfo
label double;

2. var name age salary bonus;

3. Access Mostly Uused Products by 50000+ Subscribers

4. label sex='SEX';

5. run;





Question : You have been given below SAS programming statement
Libname Hadoop spss c:\hadoopexam\courses.spss;

: You have been given below SAS programming statement
1. Above statement is having wrong syntax or half.

2. Above statement is defining two libref pointing to the same data file

 3. Access Mostly Uused Products by 50000+ Subscribers

4. It is defining a library named spss using Hadoop sas engine


Correct Answer : Get Lastest Questions and Answer :
Explanation: Using LIBNAME statement, you can define a SAS library reference as well as which SAS engine can be used to process the files.
And always library name come before the engine name. So option 3 is correct.




Question : You are a good SAS programmer, hence whenever you write a program you will follow which of the following
A. Whenever you write a DATA or PROC step, you will always start it with the first column
B. Whatever statements you write inside the step, you should indent it properly.
C. You always write RUN statement as a first column
D. You should prefer multiple statement in single line, separated by semicolon
E. You always assign a new label to column when output generated

: You are a good SAS programmer, hence whenever you write a program you will follow which of the following
1. A,B,C
2. B,C,D
 3. Access Mostly Uused Products by 50000+ Subscribers
4. A,D,E
5. A,C,E

Correct Answer : Get Lastest Questions and Answer :
Explanation: There are some good programming practice
- Always start DATA and PROC step with the first column
- Any statement within the step should be well indented
- RUN statement should also start with first column
- You should avoid writing multiple statements in single line
- It is not necessary to assign new labels to the column



Related Questions

Question : You have written below statements for generating HTML output
ods html body='/folders/myfolders/hadoopexam/hesample102.html'
contents='/folders/myfolders/hadoopexam/contents.html'
frame='/folders/myfolders/hadoopexam/frame102.html';
Once successfully executed, than what is the expected in the contents.html file

 : You have written below statements for generating HTML output
1. It will have all the contents from the respective PROC step

2. It will have three separate reports generated.

3. Access Mostly Uused Products by 50000+ Subscribers

4. It will have links which points to the contents in the frame102.html file



Question : You have written below statements for generating HTML output
ods html body='/folders/myfolders/hadoopexam/hesample102.html'
contents='/folders/myfolders/hadoopexam/contents.html'
frame='/folders/myfolders/hadoopexam/frame102.html';
What contents.html file can have?

 : You have written below statements for generating HTML output
1. Heading for all the outputs generated from the PROC steps.

2. Heading for all the outputs generated from the DATA steps.

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Each HTML files till now have created using SAS program



Question : You have written below statements for generating HTML output
ods html body='/folders/myfolders/hadoopexam/hesample102.html'
contents='/folders/myfolders/hadoopexam/contents.html'
frame='/folders/myfolders/hadoopexam/frame102.html';

What would be there in frame102.html file?

 : You have written below statements for generating HTML output
1. It will have contents from contents.html file

2. It will have contents from hesample102.html file

 3. Access Mostly Uused Products by 50000+ Subscribers

4. It does not have anything it, it is just a frame around the output.



Question : When you have following HTML ods
ods html
path='/folders/myfolders/hadoopexam/' (url='http://hadoopexam.com/sas/')
body='hesample103.html'
contents='toc103.html'
frame='frame103.html';
What is the reason for using URL option here?

 : When you have following HTML ods
1. It will directly upload the files on HadoopExam.com if connection is open with the server.

2. It will have relative URL created in the output, so these generated reports can be uploaded on the server.

 3. Access Mostly Uused Products by 50000+ Subscribers

4. It can only be uploaded only one serer where website is hosted.



Question : Which of the following option will help you to create PDF output as below.

 : Which of the following option will help you to create PDF output as below.
1. style=Sapphire

2. bookmarklist=Sapphire

 3. Access Mostly Uused Products by 50000+ Subscribers

4. color=Sapphire



Question : You are using the below code to generate report in HTML format
ods html
path='/folders/myfolders/hadoopexam/' (url='http://hadoopexam.com/sas/')
body='hesample103.html'
contents='toc103.html'
frame='frame103.html';
What is the use of providing PATH option?

 : You are using the below code to generate report in HTML format
1. It will have URL appended with the PATH values and relative link will be created in all html files.

2. This is the path of the Server location where the website is hosted and file needs to be manually uploaded on that server.

 3. Access Mostly Uused Products by 50000+ Subscribers

4. It is the location where all the logs of the SAS program will be stored.