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

Question : What is the purpose or the MISSOVER option on the INFILE statement?

1. It prevents SAS from loading a new record when the end of the current record is reached.
2. It enables SAS to scan the input data records until the character string that is specified in the
@`character-string' expression is round.
3. Access Mostly Uused Products by 50000+ Subscribers
input tine for all the variables in the statement.
4. It causes the DATA step to stop processing if an INPUT statement reaches the end of the current
record without finding values for all variables in the statement.

Correct Answer : Get Lastest Questions and Answer :






Question : A user-defined format has been created using the FORMAT procedure. Where is it stored?


1. in a SAS catalog
2. in an external binary file
3. Access Mostly Uused Products by 50000+ Subscribers
4. in a SAS dataset in a permanent SAS data library


Correct Answer : Get Lastest Questions and Answer :


Explanation:





Question :The following SAS program is submitted, creating the SAS data set ONE:
data one;
infile `file specification';
input num chars$;
run;
ONE
NUMCHAR
----------------
The following SAS program is submitted:
proc print data = one;
where char = 23;
run;
What is output?

1. NUM CHAR
1 77
2. NUM CHAR
1 23
3 23
3. Access Mostly Uused Products by 50000+ Subscribers
1 23
3 23
1 77
4. No output is generated.

Correct Answer : Get Lastest Questions and Answer :

Explanation:

Related Questions

---

Question : You have been working as a data analysts in HadoopExam Inc. recently you have moved from Python programming to SAS programming, and start
using Do looping of SAS. Which of the following statement is correct with regards to Do loop?

A. You can use conditions in the Do loop.
B. It will always generate one observations.
C. It can be used in both DATA and PROC steps
D. It can be used read data as well as producing multiple observation using output statement.


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


Question : You have been given below SAS program

data course100;
Fee=5000;
FEE_HIKE=0.1;

do month=1 to 12;
put _all_;
TOTALFEE+(FEE+TOTALFEE)*FEE_HIKE;
end;
run;

How many time do loop will be iterated?


1. 0

2. 1

3. Access Mostly Uused Products by 50000+ Subscribers

4. 11



Question :
Which function calculates the average of the variables Var1, Var2, Var3, and Var4?

1. mean(var1,var4)
2. mean(var1-var4)
3. Access Mostly Uused Products by 50000+ Subscribers
4. mean(of var1-var4)
Ans : 4
Exp : Use a variable list to specify a range of variables as the function argument. When specifying a variable list, be sure to precede the list with the word OF. If you omit the
word OF, the function argument might not be interpreted as expected.



Question : You have been given below program

data course100 ;
Fee=5000;
FEE_HIKE=0.1;

XXXXX
put _all_;
INCREASE+(FEE+INCREASE)*FEE_HIKE;
iteration+1;
output;
end;
run;

Replace XXXXX values with the DO statement, so that code under which will be executed 20 times?


1. do month=20 to 1 by -1;

2. do month=20 to 1 by 1;

3. Access Mostly Uused Products by 50000+ Subscribers

4. do month++=20 to 1 by -1;



Question : You have been given below SAS program

data course100 ;
Fee=5000;
FEE_HIKE=0.1;

do month=1 to 12 ;
INCREASE+(FEE+INCREASE)*FEE_HIKE;
iteration+1;
output;
end;
put _all_;
run;

At the end of do loop, where statement put _all_ is written what would be the value hold by variable moth?


1. 11

2. 12

3. Access Mostly Uused Products by 50000+ Subscribers

4. 0

5. Missing



Question :
The following PROC PRINT output was created immediately after PROC TABULATE output.
Which system options were specified when the report was created?

1. OBS=, DATE, and NONUMBER
2. NUMBER, PAGENO=1, and DATE
3. Access Mostly Uused Products by 50000+ Subscribers
4. none of the above

Ans : 2
Exp : Clearly, the DATE and NUMBER (page number) options are specified. Because the page number on the output is 1, even though PROC TABULATE output was just produced, PAGENO=1
must also have been specified. If you don't specify PAGENO=, all output in the Output window is numbered sequentially throughout your SAS session.



Question :

Which of the following programs correctly references a SAS data set named SalesAnalysis that is stored in a permanent SAS library?


1. data saleslibrary.salesanalysis;
set mydata.quarter1sales;
if sales>100000;
run;
2. data mysales.totals;
set sales_99.salesanalysis;
if totalsales>50000;
run;
3. Access Mostly Uused Products by 50000+ Subscribers
var sales salesrep month;
run;
4. proc freq data=1999data.salesanalysis;
tables quarter*sales;
run;

Ans : 2
Exp : Librefs must be 1 to 8 characters long, must begin with a letter or underscore, and can contain only letters, numerals, or underscores. After you assign a libref, you specify
it as the first level in the two-level name for a SAS file.


Question : You have been given below SAS program, select the statement which is correct

data course100 ;
Fee=5000;
FEE_HIKE=0.1;

do month=1 to 12 ;
INCREASE+(FEE+INCREASE)*FEE_HIKE;
iteration+1;
output;
end;
put _all_;
run;

A. There would be 12 iteration
B. Output statement will help in generating only last observation as an output.
C. Last value hold by month variable will be 13
D. Iteration variable is redundant, and does not help in creating output.


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


Question : You have been given below SAS program

data course100 ;
Fee=5000;
FEE_HIKE=0.1;

do month=1 to 15 by 3 ;
INCREASE+(FEE+INCREASE)*FEE_HIKE;
iteration+1;
output;
end;
put _all_;
run;

proc print data=course100; run;

How many observation will be in course100 dataset


1. 15

2. 12

3. Access Mostly Uused Products by 50000+ Subscribers

4. 4

5. 6