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

Question : The following SAS program is submitted:
data work.retail;
cost = `20000';
total= .10* cost
run;
What is the result?

1. The value of the variable TOTAL in the output data set is 2000. No messages are written to the SAS log.
2. The value of the variable TOTAL in the output data set is 2000. A note that conversion has taken place is written to the SAS log.
3. Access Mostly Uused Products by 50000+ Subscribers
4. The variable TOTAL in the output data set has no value. The program fails to execute due to a syntax error.

Correct Answer : Get Lastest Questions and Answer :

Explanation:

Question : Which program can be used to create the
output similar to shown in left?

1. proc means data=clinic.diabetes;
var age height weight;
class sex;
output out=work.sum_gender
mean=AvgAge AvgHeight AvgWeight;
run;
2. proc summary data=clinic.diabetes print;
var age height weight; class sex;
output out=work.sum_gender
mean=AvgAge AvgHeight AvgWeight;
run;
3. Access Mostly Uused Products by 50000+ Subscribers
var age height weight;
class sex;
output out=work.sum_gender
mean=AvgAge AvgHeight AvgWeight;
run;
4. Both a and b.

Correct Answer : Get Lastest Questions and Answer :

Explanation: You can use either PROC MEANS or PROC SUMMARY to create the table. Adding a PRINT option to the PROC SUMMARY statement produces the same report as if you used PROC MEANS.

Question : You have been given a dataset named hetrain.helr , you have been using the PROC PRINT statement to print the dataset, with the labels.
However, labels are not stored in the dataset than which of the following is a correct statement PORC PRINT statement >

1. proc print data=hetrain.helr1 label;
label welcome='Welcome to HadoopExam Learning Resources';
run;

2. proc print data=hetrain.helr1;
label welcome='Welcome to HadoopExam Learning Resources';
run;

3. Access Mostly Uused Products by 50000+ Subscribers
run;

4. proc print hetrain.helr1 label;
run;

Correct Answer : Get Lastest Questions and Answer :
Explanation: Here we need to focus on correct syntax as well as option. In PROC PRINT we need to use DATA= option so that data can be
printed. However, we wanted to give some description label to the variable name than we should have used label option in PROC PRIN statement and label
statement for a particular variable to tell what should be the label for a variable.

Related Questions

Question : You need to find that how many year it will take to reach your INR investment every year with % compounding interest rate to have
100000 or more, which of the following you will consider?

1. Do loop

2. DO Until loop

3. Access Mostly Uused Products by 50000+ Subscribers

4. Where condition

Question : Which of the following statements are correct, with regards to DO UNTIL statement

A. DO UNTIL statement will always execute enclosed statements at least once.
B. DO UNTIL statement may not execute enclosed statements if condition is true at the start.
C. All the enclosed statements will be executed if condition until become true.
D. END; statement is not mandatory its optional.

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

Question : You have been given a below SAS program

data course100 (drop=index);
do until(TOTAL_INCOME>100000);
TOTAL_INCOME+5000;
TOTAL_INCOME+TOTAL_INCOME*.10;
YEAR+1;
output;
put _all_;
end;
run;

Select the DO while statement which can be replace with the DO UNTIL statement?

1. do while(TOTAL_INCOME>100000);

2. do while(TOTAL_INCOME<100000);

3. Access Mostly Uused Products by 50000+ Subscribers

4. do until(TOTAL_INCOME <> 100000);

Question :

What happens if you submit the following program?

proc sort data=clinic.stress out=maxrates;
by maxhr;
run;
proc print data=maxrates label double noobs;
label rechr='Recovery Heart Rate;
var resthr maxhr rechr date;
where toler='I' and resthr>90;
sum fee;
run;

1. Log messages indicate that the program ran successfully.
2. A "PROC SORT running" message appears at the top of the active window, and a log message may indicate an error in a statement that seems to be valid.
3. Access Mostly Uused Products by 50000+ Subscribers
4. A "PROC PRINT running" message appears at the top of the active window,
and a log message may indicate that a quoted string has become too long or that the statement is ambiguous.
Ans:4
Exp : The missing quotation mark in the LABEL statement causes SAS to misinterpret the statements in the program. When you submit the program, SAS is unable to resolve the PROC step,
and a "PROC PRINT running" message appears at the top of the active window.

Question : Which of the following condition will be replaced at XXXXX , so that TOTAL_INCOME become or number of years should not be more than
10.

data course100 (drop=index);
do year=1 to 10 XXXXX
TOTAL_INCOME+5000;
TOTAL_INCOME+TOTAL_INCOME*.10;

output;
put _all_;
end;
run;

proc print data=course100;
run;

1. until(TOTAL_INCOME>100000);

2. while(TOTAL_INCOME le 100000);

3. Access Mostly Uused Products by 50000+ Subscribers

4. then(TOTAL_INCOME>100000);

Question : You have similar variables in your dataset like sales of last months jan, feb, mar, apr, may, jun. And you wanted to do some
calculations on those variable referencing them through array, which of the following statement is correct with regards to array?

A. You need to create array variable before using it.
B. You can have mixed data types variable in single array declaration.
C. You can use array to create new variables
D. You can use array to create temporary variables.

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

Question : You have following array declaration
array Hadoop{xxxx} fee1-fee4;

What is the correct value for xxxx ?

A. 1:4
B. 4
C. 1-4
D. 0-4
E. 0:4

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