Premium

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



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

: 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;


Correct Answer : Get Lastest Questions and Answer :
Explanation: Option 3 is only syntactically correct. You should have used do while loop.




Question : Which of the following is correct example of summation

: 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


Correct Answer : Get Lastest Questions and Answer :
Explanation: Optiion 2 is correct to show the proper summation example




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;


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


2. B


 3. Access Mostly Uused Products by 50000+ Subscribers


4. D


Correct Answer : Get Lastest Questions and Answer :
Explanation: In this kind of program we need to fine which option are wrong at first. Lets observe the input and output , input has variable
number of records. Output does not have any column named sequence, which can be possibly generated by option 1,3 and 4 . Hence, all these three option
are wrong. Only remaining option is 2 and validate its code as per need. In option 2 one misleading option is missover, which should ethnically generate
empty records with the use of course_name only. But condition in do while loop avoid doing this. Hence, option 2 is correct.


Related Questions

Question : You have been given below dataset

How will you read it in 2 observation in order of course_name , training_date, location, duration, fee and institute?

 : You have been given below dataset
1. input course_name $ training_date mmddyy8. /
location $ duration /
Fee INSTITUTE $;


2. input
#1 course_name $ training_date mmddyy8. /
#2 location $ duration /
#3 Fee INSTITUTE $;


3. Access Mostly Uused Products by 50000+ Subscribers
#1 course_name $ training_date mmddyy8. ;
#2 location $ duration ;
#3 Fee INSTITUTE $;


4. input course_name $ training_date mmddyy8. \
location $ duration \
Fee INSTITUTE $;



Question : You have been given below dataset


Now you want to read ID first from line 4 and then go back to line 1 to read course_name and date, which of the following syntax are correct?

 : You have been given below dataset
1. Input #4 id $ \
course_name $ course_date mmddyy8.;


2. Input #4 id $
@1 course_name $ course_date mmddyy8.;


 3. Access Mostly Uused Products by 50000+ Subscribers
#1 course_name $ course_date mmddyy8.;


4. Input #4 id $
#1 course_name $ course_date mmddyy8.;



Question : You have below raw data file



And given SAS input statement

input
# 4 course_id $
#1 course_name $ training_date mmddyy8. /
location $ duration /
Fee INSTITUTE $;

How many observation will be produced using above input statement?

 : You have below raw data file
1. 24

2. 16

 3. Access Mostly Uused Products by 50000+ Subscribers

4. 4

5. 6



Question : You have bene given below dataset


Which of the following code read LOCATION and Course_duraction correctly?

A. Input
#2 location $ duration ;

B. Input
@2 location $ duration ;

C. Input
#1 course_name $ course_date mmddyy8.
#2 location $ duration ;

D. Input
#2 location $ duration ;
#1 course_name $ course_date mmddyy8.

 : You have bene given below dataset
1. A,B,C
2. A,C,D
 3. Access Mostly Uused Products by 50000+ Subscribers
4. B,C,D
Correct Answer : Exp : Question is asking to read data for both location and course_duration which always appears in nd line. So we can use line
position control for that. In option @2 is used which is not correct line control syntax we can rule it out. Now remaining all three are correct.


Question : You have been given below dataset


Which of the following program can read data correctly?

: You have bene given below dataset
1. input
course_id $ /
course_name $ training_date mmddyy8. /
location $ duration /
Fee INSTITUTE $;


2. input
# 1 course_id $
#4 course_name $ training_date mmddyy8. /
location $ duration /
Fee INSTITUTE $;


 3. Access Mostly Uused Products by 50000+ Subscribers
# 4 course_id $ /
#1 course_name $ training_date mmddyy8. /
location $ duration /
Fee INSTITUTE $;


4. input
# 4 course_id $
#1 course_name $ training_date mmddyy8. /
location $ duration /
Fee INSTITUTE $;



Question : Which of the following read correctly course_name, corse_date, location, duration , course_fee and institute in this order


 : Which of the following read correctly course_name, corse_date, location, duration , course_fee and institute in this order
1. input course_name $ training_date mmddyy8. /
location $ duration /
Fee INSTITUTE $;


2. input
#1 course_name $ training_date mmddyy8. /
#2 location $ duration /
#3 Fee INSTITUTE $;


 3. Access Mostly Uused Products by 50000+ Subscribers
location $ duration /;
Fee INSTITUTE $;


4. input
@1course_name $ training_date mmddyy8. /
@2 location $ duration /
@3 Fee INSTITUTE $;




Question : You need to write a do loop which counts upto but in each iteration step should be incremented by value .

 : You need to write a do loop which counts upto but in each iteration step should be incremented by value .
1. Do hecounter=1 to 100 by 10;

2. Do hecounter=1 to 100 by 10++;

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Do hecounter+10=1 to 100 ;