Premium

Base SAS Certified Associate: Programming Fundamentals Using SAS Questions and Answers (Dumps and Practice 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;


Correct Answer : Get Lastest Questions and Answer :
Explanation: We can clearly see that the data statement is wrongly spelled instead of data it is dta.




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.


Correct Answer : Get Lastest Questions and Answer :
Explanation: In the given program you can see that there is an unbalanced quotation mark, and SAS is unable to detect the end of statement.
Hence, already submitted program needs to cancel already submitted program and add the quotation mark 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


Correct Answer : Get Lastest Questions and Answer :
Explanation: There are two reason when you see Data step running message on active window in SAS window environment
- When you missed the RUN statement after the DATA step
- When you have unbalanced quotation mark.



Related Questions

Question : You have below program
data course2017_1;
set course2017 end=last;
if last;
run;

Now during the compilation phase, all the variables will be created in the program data vector, and all the observation will be set to

 : You have below program
1. Blank values

2. Missing Values

3. Access Mostly Uused Products by 50000+ Subscribers

4. There will not be any observations



Question : You have been wring the SAS programs, now you want to override the behavior of output generations, which of the option or statement you
will choose

: You have been wring the SAS programs, now you want to override the behavior of output generations, which of the option or statement you
1. DROP= and KEEP= data set options

2. OUTPUT statement

 3. Access Mostly Uused Products by 50000+ Subscribers

4. BY statement



Question : You have been given below datasets


Which of the following program will generate result as Course100 dataset using Course101 and Course102?

 : You have been given below datasets
1. data course100;
set course101;
set course102;
run;


2. data course100;
set course101 set course102;
run;


 3. Access Mostly Uused Products by 50000+ Subscribers
set course101 set course102;
by course_id;
run;


4. data course100;
merge course101 set course102;
by course_id;
run;



Question : You have been given below dataset

Which of the following is a correct SAS program which can generate output as Course100?

 : You have been given below dataset
1. data course100;
set course101 ;
set course102 ;
run;


2. data course100;
set course101 set course102 ;
run;


 3. Access Mostly Uused Products by 50000+ Subscribers
set course101 course102 ;
by COURSE_ID;
run;


4. data course100;
merge course101 course102 ;
by COURSE_ID;
run;



Question : You have been given below dataset

You execute below program, which of the generated output is correct?
data course100;
set course101 course102;
run;


 : You have been given below dataset
1. Image1
2. Image2
 3. Access Mostly Uused Products by 50000+ Subscribers
4. Image4


Question : You have been given below two datasets

And you have below program
data course100;
set course101 course102;
run;

What will be the value of the fee in 2nd observation when program executed?

 : You have been given below two datasets
1. 6500

2. Null

 3. Access Mostly Uused Products by 50000+ Subscribers

4. 5000