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

Question : You have been given below dataset

Now C represent header record and LF represent detail record, now you want to create one observation per detail record, what do you do?


1. We first need to fine which represent header and which record is part of detail in this case C is header and LF is detail record.

2. We need to hold the header record C of each observation until the next header record is read.

3. Access Mostly Uused Products by 50000+ Subscribers

4. All of the above are correct


Correct Answer : Get Lastest Questions and Answer :
Explanation: As we wanted to create only one observation per course header, we need to hold that record until all the detail record is read.
Once the all the detail record is done have the output statement. And also you need to find which the last output statement.




Question : You have been given below dataset

Which of the blow statement will hold the header value until all the detail records are read


1. input header @;

2. input header @@;

3. Access Mostly Uused Products by 50000+ Subscribers

4. input header \;


Correct Answer : Get Lastest Questions and Answer :
Explanation: Trailing @ sign will hold the current header. Will hold header statement until the current data step




Question : Which of the following statement read the header and check whether it is equal to C or not if its C then assign course_name value.


1. if header='C' then input course_name $;

2. if header='C' then input course_name $ @;

3. Access Mostly Uused Products by 50000+ Subscribers

4. if header='C' then input course_name $ \;


Correct Answer : Get Lastest Questions and Answer :
Explanation: To check whether a header value is C, individual character than we should use the if-then statement and put the C in single
quote because it is a character value.

Related Questions

---

Question : You are planning to have statement which can repetitively run when he_fee< , select correct statement from below


1. Do he_fee <9999;

2. Do he_fee lt 9999;

3. Access Mostly Uused Products by 50000+ Subscribers

4. Do while he_fee<9999;



Question : Which of the following is correct example of summation


1. HadoopExam=1+1;

2. HadoopExam+1;

3. Access Mostly Uused Products by 50000+ Subscribers

4. HadoopExam,+1



Question : You have been given below input and output sas data, which of the given program perfectly generate this ouput

A.
filename course73 '/folders/myfolders/hedata/course73.txt';

data data73;
infile course73 missover;
input course_name $ location $ Fee @;
sequence=0;
do while (Fee ne .);
sequence+1;
output;
input location $ Fee @;
end;
run;

B.
filename course73 '/folders/myfolders/hedata/course73.txt';

data data73;
infile course73 missover;
input course_name $ location $ Fee @;

do while (Fee ne .);
output;
input location $ Fee @;
end;
run;

C.
filename course73 '/folders/myfolders/hedata/course73.txt';

data data73;
infile course73 missover;
input course_name $ @;
do sequnce=1 to 4;
input location $ Fee @;
output;
end;
run;

D.
filename course72 '/folders/myfolders/hedata/course72.txt';

data data72;
infile course72;
input course_name $ @;
do sequnce=1 to 4;
input location $ Fee @;
output;
end;
run;



1. A


2. B


3. Access Mostly Uused Products by 50000+ Subscribers


4. D



Question : If you have been given below condition

if header='C' then input course_name $;
else if header='LF' then location $ FEE ;

which of the following statements are correct?


1. If header is not C then location and Fee value will be read from data

2. If header is not C then course name value will be read from data

3. Access Mostly Uused Products by 50000+ Subscribers

4. If header is C then another condition will be checked



Question : You have been given below code, what that means

if header='C' then
do;

if _N_ >1 then
output;
TOTAL_LOCATIONS=0;
input course_name $;
end;

A. _N_ value tells how many detail record have been read or time data steps is executed.
B. If header=C and _N_ >1 then generate the output
C. If header=C or _N_ >1 then generate the output
D. Observation is generated only for the header record and no detail record will be read


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


Question : You have been given below dataset and SAS program, how many observation will be generated at the end of the program



filename course73 '/folders/myfolders/hedata/course73.txt';

data data73;
infile course73 missover;
input course_name $ @;
do sequnce=1 to 4;
input location $ Fee @;
output;
end;
run;

proc print data=data73;
run;


1. 17

2. 20

3. Access Mostly Uused Products by 50000+ Subscribers

4. None