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

Question : You have been given below date, which input format you will use to read date values correctly?


1. mmddyy8.

2. Mmddyyyy8.

3. Access Mostly Uused Products by 50000+ Subscribers

4. DATETIME20.


Correct Answer : Get Lastest Questions and Answer :
Explanation: You should have used correct format to read this value is mmddyy8 . Because width of the values you can see is 8. Also there is
no valid format like mmddyyyy8. It is always mmddyyw. Hence, mmddyy8. Can represent following dates correctly.
02/22/17
02-22-17





Question : You are going to read following time values
12:12:12.12
And you can use format timew. Than what is the minimum possible width you can define?


1. 2

2. 3

3. Access Mostly Uused Products by 50000+ Subscribers

4. 5

5. 11


Correct Answer : Get Lastest Questions and Answer :
Explanation: To read time values using SAS , you need to specify the width. However, you can not specify width below 5. If you specify width
less than actual required than time value will be truncated. However, minimum width upto 5 has to be defined.




Question : Which of the following date values and its format are correct?
A. 22May2017:10:03:17.2 DATETIME20.
B. 22May2017:10:03:17.2 DATETIME16.
C. 22FEB2017 DATE9.
D. 22FEB2017 DDMMMYYYY9.


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: You need to be aware which all are correct format to read date values like
DATEw.
DATETIMEw.
MMDDYYw.
TIMEw.

Related Questions

---

Question : You have been given a data set, which contains all the training courses provided by the HadoopExam.com, now you need to select particular
data which has only three courses in output which are Hadoop, SAS, and Spark. Which of the following is correct statement to select these specific
courses?


1. where courses='Hadoop' or 'SAS' or 'Spark';

2. where courses in 'Hadoop' or 'SAS' or 'Spark';

3. Access Mostly Uused Products by 50000+ Subscribers

4. where courses in ('Hadoop','SAS','Spark');



Question : You have been given some dataset HETRAIN.HELR, now you need to sort this dataset and sorted data needs to be copied in new dataset named
NEWCOURSES. Which of the following is correct syntax?


1. proc sort data=work.newcourses out=hetrain.helr1;
run;


2. proc sort helr1 out=newcourses;
by name;
run;


3. Access Mostly Uused Products by 50000+ Subscribers
by name;
run;


4. proc sort from hetrain.helr1 to newcourses;
by name;
run;



Question : Which of the following statement is correct when you want Date to appear on top of the page and output should not have page number defined?


1. When you want DATE without page number in output use system option date and withoutnumber

2. When you want DATE without page number in output use system option date and withoutpagenumber

3. Access Mostly Uused Products by 50000+ Subscribers

4. When you want DATE without page number in output use system option date and NONNUMBER



Question : Which one of the following SAS system options displays the time on a report?

1. TIME
2. DATE
3. Access Mostly Uused Products by 50000+ Subscribers
4. DATETIME


Question : Which one of the following SAS system options prevents the page number from appearing on a report?

1. NONUM
2. NOPAGE
3. Access Mostly Uused Products by 50000+ Subscribers
4. NOPAGENUM


Question : The following SAS program is submitted:
proc means data = sasuser.houses std mean max;
var sqfeet;
run;
Which one of the following is needed to display the standard deviation with only two decimal places?

1. Add the option MAXDEC = 2 to the MEANS procedure statement.
2. Add the statement MAXDEC = 7.2; in the MEANS procedure step.
3. Access Mostly Uused Products by 50000+ Subscribers
4. Add the option FORMAT = 7.2 option to the MEANS procedure statement.