Premium

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



Question :

The contents of the raw data file PRODUCT are listed below:
--------10-------20-------30
24613____$25.31
The following SAS program is submitted:
data inventory;
infile 'product';
input idnum 5. @10 price;
run;
Which one of the following is the value of the PRICE variable?


:
1. 25.31
2. $25.31
 3. Access Mostly Uused Products by 50000+ Subscribers
4. No value is stored as the program fails to execute due to errors

Correct Answer : Get Lastest Questions and Answer :

Explanation: Correct answer is 3 (missing) because when input statment tries to read price as number but encounters character value, so assigns a missing value to price variable.







Question :

The following SAS program is submitted:
proc print data = sasuser.houses;
run;

proc means data = sasuser.shoes;
run;
Which one of the following OPTIONS statements resets the page number to 1 for the second report?


:
1. options pageno = 1;
2. options pagenum = 1;
 3. Access Mostly Uused Products by 50000+ Subscribers
4. options reset pagenum = 1;

Correct Answer : Get Lastest Questions and Answer :

Explanation:





Question :

Which one of the following is true of the SUM statement in a SAS DATA step program?

:
1. It is only valid in conjunction with a SUM function.
2. It is not valid with the SET, MERGE and UPDATE statements.
 3. Access Mostly Uused Products by 50000+ Subscribers
4. It does not retain the accumulator variable value from one iteration of the SAS DATA step to the next.

Correct Answer : Get Lastest Questions and Answer :

Explanation:



Related Questions

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.

 : You have similar variables in your dataset like sales of last months jan, feb, mar, apr, may, jun. And you wanted to do some
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

 : You have following array declaration
1. A,B
2. B,C
 3. Access Mostly Uused Products by 50000+ Subscribers
4. D,E
5. A,E


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

What is the correct value for xxxx ?

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

 : You have following array declaration
1. A,B
2. B,C
 3. Access Mostly Uused Products by 50000+ Subscribers
4. D,E
5. A,E


Question : You have been given below SAS program

data course100;
set course101;
array fee{4} fee1 fee2 fee3 fee4;
array new_fee{4} nfee1 nfee2 nfee3 nfee4;

xxxxx
put _all_;
new_fee{index}=fee{index}+fee{index}*.10;
end;
run;

Replace xxxxx with the correct statement, so that all the defined array variables can be processed?

 : You have been given below SAS program
1. do index=1 to 4;

2. do index=0 to 4;

 3. Access Mostly Uused Products by 50000+ Subscribers

4. do until index= 4;



Question : You have defined below program

data course100;
set course101;
array fee{4} fee1 fee2 fee3 fee4;
array new_fee{4} nfee1 nfee2 nfee3 nfee4;

do index=1 to 4;
put _all_;
new_fee{index}=fee{index}+fee{index}*.10;
end;
run;

what is the index value which can point variable fee3 and nfee4

 : You have defined below program
1. 3 , 4

2. 4, 4

 3. Access Mostly Uused Products by 50000+ Subscribers

4. 4, 4