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

Question : You have been given below file which has multiple observations in single record


You want to produce result such that
Course_name -> course_date course_fee

So that you decided to use @@ double trailing sign, which of the following statement is true for that?

A. You will have to read multiple input statement for single raw record across multiple iteration of the data steps than you will use it.
B. You should put it at the end of input statement
C. You should put it at the beginning of input statement
D. Hold on the line will be released if pointer moves past of the record


1. A,B,C
2. B,C,D
3. Access Mostly Uused Products by 50000+ Subscribers
4. A,B,D

Correct Answer : Get Lastest Questions and Answer :
Explanation: whenever you want to read multiple observation from single raw record you can use either @@ or @ sign. However, if the length
of each record is same you should consider using @@ sign. You should always put this @@ sign at the end of record. As soon as pointer pass the entire
line it will release the hold on that line and move for next line.




Question : You have been given below dataset


And you will be using single @ sign to read this data, which statement is true regarding that?


1. Record which is hold by trailing @ sign will be released once end of the record is reached.

2. Record which is hold by trailing @ sign will be released once data step next iteration begins.

3. Access Mostly Uused Products by 50000+ Subscribers

4. It will never release hold on the record automatically, you have to explicitly mark using @@ sign.


Correct Answer : Get Lastest Questions and Answer :
Explanation: As soon as control return to the data step for next iteration control will be released for that line.




Question : You have been given below dataset


Each raw record has 3 observation, which of the following program can read it perfectly?


1. input course_name $ course_date mmddyy8. course_fee @@;

2. input course_name $ course_date mmddyy8. course_fee @;

3. Access Mostly Uused Products by 50000+ Subscribers

4. @ input course_name $ course_date mmddyy8. course_fee @;


Correct Answer : Get Lastest Questions and Answer :
Explanation: To read data from fixed fields which has multiple observation in single record, you can use double training @@ sign. All other
options are wrong.

Related Questions

---

Question :
After a SAS program is submitted, the following is written to the SAS log:
105 data WORK.JANUARY;
106 set WORK.ALLYEAR(keep=Product Month Quantity Cost);
107 if Month='JAN' then output WORK.JANUARY;
108 Sales=Cost * Quantity;
109 drop=Month Quantity Cost;
-----
ERROR 22-322: Syntax error, expecting one of the following: !,
!!, , *, **, +, -,
, , =, >, >=,
AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL,
NOTIN, OR, ^=, |, ||, ~=.
110 run;
What data set option could be attached to WORK.JANUARY to replace the DROP statement that
generated the error in the log?



1. (drop Month Quantity Cost)
2. (drop Month, Quantity, Cost)
3. Access Mostly Uused Products by 50000+ Subscribers
4. (drop=Month Quantity Cost)


Question :
Consider the following data step:

The computed variables City and State have their values assigned using two different methods, a
RETAIN statement and an Assignment statement. Which statement regarding this program is true?

1. The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.
2. Both the RETAIN and assignment statement are being used to initialize new variables and
are equally efficient. Method used is a matter of programmer preference.
3. Access Mostly Uused Products by 50000+ Subscribers
statement has been omitted.
4. City's value will be assigned one time, State's value 5 times.


Question :
Given the SAS data set WORK.ONE:

What value will SAS assign to Total?


1. 3
2. 1.6
3. Access Mostly Uused Products by 50000+ Subscribers
4. The program fails to execute due to errors.


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