Premium

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



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.

Correct Answer : Get Lastest Questions and Answer :

Explanation:







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.?

: 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
1. 13-Aug-2025

2. 13-Aug-1925

 3. Access Mostly Uused Products by 50000+ Subscribers

4. 13-Aug-1920


Correct Answer : Get Lastest Questions and Answer :
Explanation: Yes, here date is given in 4 digit. But the problem is with the informat, you are saying date has width of 8 only, which is not
correct actually it is 10 character long. So last two digit will be truncated and year part remain will be 20 only. Now we have yearcutoff=2026, it
means this 20 will be read as 2020. So correct date representation will be 13-Aug-2020, which is not correct values of given date.




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?

: You have been given below SAS data in raw file
1. endDate-startDate

2. endDate-startDate+1

 3. Access Mostly Uused Products by 50000+ Subscribers

4. startDate-endDate

5. (startDate-endDate)*24


Correct Answer : Get Lastest Questions and Answer :
Explanation: As you know, SAS first convert dates into number of days starting from January 1, 1960. Which makes calculations in SAS faster.
However, when you do the subtractions dates are inclusive. Hence, you need to +1 whenever you subtract dates to find the number of days interval.


Related Questions

Question :

The following SAS program is submitted:

What is produced as output?

 :
1. A file named test.cvs that can only be opened in Excel.
2. A text file named test.cvs that can be opened in Excel or in any text editor.
3. Access Mostly Uused Products by 50000+ Subscribers
4. A file named test.cvs that can only be opened by SAS.


Question :

You're attempting to
read a raw data file
and you see the following
messages displayed
in the SAS Log:
What does it mean?

 :
1. A compiler error, triggered by an invalid character for the variable Salary.
2. An execution error, triggered by an invalid character for the variable Salary.
 3. Access Mostly Uused Products by 50000+ Subscribers
4. An error on the INPUT statement specification for reading the variable Salary.


Question :

The following SAS program is submitted:

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


Question :
 :
1. 1
2. 2
 3. Access Mostly Uused Products by 50000+ Subscribers
4. 4



Question :
The following SAS program is submitted:
data WORK.DATE_INFO;
Day="01" ;
Yr=1960 ;
X=mdy(Day,01,Yr) ;
run;
What is the value of the variable X?

 :
1. the numeric value 0
2. the character value "01011960"
 3. Access Mostly Uused Products by 50000+ Subscribers
4. the step will not compile because of the character argument in the mdy function.


Question :

The following SAS program is submitted:
data WORK.AUTHORS;
array Favorites{3} $ 8 ('Shakespeare','Hemingway','McCaffrey');
run;
What is the value of the second variable in the dataset WORK.AUTHORS?

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