Premium

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



Question : You have been given following value



Then which of the format you should use to read this data

: You have been given following value
1. Column

2. Formatted

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Modified List


Correct Answer : Get Lastest Questions and Answer :
Explanation: This data has embedded blank values in course name. And also numeric values are not in standard format. So you need to use
modified list input to read this data.




Question : You have been given below values with fields in each record.



Which of the following can be used to read data .

: You have been given below values with fields in each record.
1. length course_name $ 16;
input course_name & FEE1: comma7. FEE2 : comma7. FEE3: comma7. FEE4 : comma7. ;


2. input course_name & FEE1: comma7. FEE2 : comma7. FEE3: comma7. FEE4 : comma7. ;


3. Access Mostly Uused Products by 50000+ Subscribers


4. length course_name $ 16;
input course_name & FEE1-FEE4 : comma7. ;



Correct Answer : Get Lastest Questions and Answer :
Explanation: As you can see in the given dataset values has embedded blanks. And length of the first field is 16. So only place where length
for the variable is defined in option 1 and 4. So option 2 and 3 is out. Now option 4 is not correct syntax wise. Because numeric field values, syntax
are not correctly defined. So only correct option is 1




Question : You have been given below dataset in a file course.txt,



Which of the given program correctly reads this files.

A.
filename course22 '/folders/myfolders/hedata/course22.txt';
data data23;
infile course22 MISSOVER ;
input ID $1-3 IDnum $4-11 @13 Fee comma8. LOCATION $ 22-35;
run;
B.

filename course22 '/folders/myfolders/hedata/course22.txt';
data data23;
infile course22;
input ID $1-3 IDnum $4-11 @13 Fee comma8. LOCATION $ 22-35;
run;
C.
filename course22 '/folders/myfolders/hedata/course22.txt';
data data23;
infile course22 MISSOVER ;
input ID $1-3 IDnum @13 Fee comma8. LOCATION;
run;


D.
filename course22 '/folders/myfolders/hedata/course22.txt';
data data23;
infile course22 MISSOVER ;
input @1 ID +3 IDnum $4-11 @13 Fee comma8. LOCATION $ 22-35;
run;

: You have been given below dataset in a file course.txt,
1. A,B
2. A,C
 3. Access Mostly Uused Products by 50000+ Subscribers
4. B,D

Correct Answer : Get Lastest Questions and Answer :
Explanation: You can read given data using column position as well as +n format. Also few values are missing at the end of the records. So
you must use missover option. So based on all this given requirement we can clearly say that option 1 and 4 are correct.


Related Questions

Question : Which of the following program you see as a syntax error
 : Which of the following program you see as a syntax error
1. data work.prices;
infile '/folders/myfolders/hadoopexam/hesample1.dat';
input CODE $ NAME$ FEE1 FEE2;
if NAME='SPARK;
run;



2. dta work.prices;
infile '/folders/myfolders/hadoopexam/hesample1.dat';
input CODE $ NAME$ FEE1 FEE2;
if NAME='SPARK;
run;


3. Access Mostly Uused Products by 50000+ Subscribers
infile '/folders/myfolders/hadoopexam/hesample1.dat';
input CODE $ NAME$ FEE1 FEE2;
if NAME='SP__;
run;


4. data prices;
infile '/folders/myfolders/hadoopexam/hesample1.dat';
input CODE $ NAME$ FEE1 FEE2;
if NAME='SPARK;
run;



Question : What action should you take once you submitted the below SAS program
proc print data=courses;
where course='SPARK;
run;

 : What action should you take once you submitted the below SAS program
1. After submitting to complete the program add another quotation mark on the log window, so program will be successfully completed

2. Recall the program and add another quotation mark and re-submit the program.

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Recall the program, and remove existing quotation and re-submit the program.



Question : You have submitted program in SAS window and active window shows that DATA Step running for long time, what does that mean?

 : You have submitted program in SAS window and active window shows that DATA Step running for long time, what does that mean?
1. There is a spelling error with the SAS keyword

2. You have not provided RUN statement at the end of Data step

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Data file is empty



Question : You have been using SAS program since quite long time and you are always using the SAS PUTLOG statements, in which case it is very helpful?

 : You have been using SAS program since quite long time and you are always using the SAS PUTLOG statements, in which case it is very helpful?
1. Syntax Error

2. Semantic Errors

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Any of the above



Question : Which of the following code can generate below results?

 : Which of the following code can generate below results?
1. proc print data=hetrain.helr1 noobs;
var ID DATE date8. LOCATION$ FEE;
label DATE='Start On' LOCATION='Training Venue';
where FEE>=4000;
run;


2. proc print data=hetrain.helr1;
var ID DATE date8. LOCATION$ FEE;
where FEE>=4000;
label DATE='Start On' LOCATION='Training Venue';
run;


 3. Access Mostly Uused Products by 50000+ Subscribers
id date;
var ID DATE LOCATION FEE;
label DATE='Start On' LOCATION='Training Venue';
where FEE>=4000;
format DATE date10.;
run;


4. proc print hetrain.helr1 noobs;
id date;
var ID DATE date8. LOCATION FEE;
where FEE>=4000;
run;



Question : Which group processing statement produced the PROC MEANS output shown in left ?

 : Which group processing statement produced the PROC MEANS output shown in left ?
1. class sex survive;
2. class survive sex;
3. Access Mostly Uused Products by 50000+ Subscribers
4. by survive sex;