Premium

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



Question :

Which programming statement is used to perform conditional processing on
groups of SAS statements?


:
1. DO
2. BY
 3. Access Mostly Uused Products by 50000+ Subscribers
4. IF/THEN

Correct Answer : Get Lastest Questions and Answer :

Explanation: The key word in this question is 'group'. Conditional
processing can be performed using some iteration of BY, WHERE,
and IF/THEN, but DO provides an opportunity to group statements
together.






Question :

The following SAS program is submitted:


data test;
set sasuser.employees;
if 2 le years_service le 10 then amount = 1000;
else if years_service gt 10 then amount = 2000;
else amount = 0;
amount_per_year = years_service / amount;
run;


Which one of the following values does the variable AMOUNT_PER_YEAR contain if an employee has been with the company for one year?


:
1. 0
2. 1000
 3. Access Mostly Uused Products by 50000+ Subscribers
4. . (missing numeric value)

Correct Answer : Get Lastest Questions and Answer :

Explanation: Amount is set to 0 and therefore amount_per_year is set to missing..

Try this
data test;
years_service=1;
if 2 le years_service le 10 then amount = 1000;
else if years_service gt 10 then amount = 2000;
else amount = 0;
amount_per_year = years_service / amount;
run;

So amount_per_year = .






Question :

Which of the following statements is not true for list inputs?

:
1. Fields cannot be skipped or re-read
2. Fields are read from left to right
 3. Access Mostly Uused Products by 50000+ Subscribers
4. The MISSOVER option must be used at all times to read missing values

Correct Answer : Get Lastest Questions and Answer :

Explanation: If missing values are represented by a special character
that is not used as a separated of data, then the MISSOVER option is
not required




Related Questions

Question : You have been given below dataset which has training fee


Which of the fee can be considered as a standard numeric data for last column fee

 : You have been given below dataset which has training fee
1. Line-1

2. Line-2

3. Access Mostly Uused Products by 50000+ Subscribers

4. Line-4



Question : : You are working on Sales data and by looking at the data you have decided that you have to use formatted input, for which kind of data
you can use formatted input?

 : : You are working on Sales data and by looking at the data you have decided that you have to use formatted input, for which kind of data
1. Standard Free Format Data

2. Standard data with fixed fields and length

 3. Access Mostly Uused Products by 50000+ Subscribers

4. You can use it for both standard and non-standard data in fixed length.



Question : You have been given below dataset



Which of the following format can be used to read data from column 1-8 ?

 : You have been given below dataset
1. w.

2. $w.

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Commaw.d



Question : You are planning to use commaw.d informat, which of the following data can be read using this format?

A. 9,99
B. $99.9
C. %99.9

 : You are planning to use commaw.d informat, which of the following data can be read using this format?
1. A,B,C
2. B,C,D
 3. Access Mostly Uused Products by 50000+ Subscribers
4. A,B,D


Question : You have been given below dataset


Which of the following is correct statement to read data as course_name and Fee, both value should be read as character

 : You have been given below dataset
1. Input +1 FEE $9 . @1 COURSE_NAME $8.

2. Input +6 FEE $9 . @1 COURSE_NAME $5.

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Input @9 FEE $9 @1 COURSE_NAME $8.



Question : You have been given below dataset


Which of the following will correctly read column Fee as a numeric value ?

 : You have been given below dataset
1. Input @11 FEE $9;

2. Input @11 Fee 9.2.;

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Input @11 FEE comma9.2.;