Premium

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



Question :
You have submitted the following SAS SORT procedure step generates an output data set:

proc sort data = sasuser.employer out = employee;
by style;
run;

In which library is the output data set stored?
:
1. WORK
2. REPORT
 3. Access Mostly Uused Products by 50000+ Subscribers
4. SASUSER

Correct Answer : Get Lastest Questions and Answer :

Explanation: If libname name is not specified, then the data will be stored in WORK.
The Work library is the temporary library that is automatically defined by SAS at the beginning of each SAS session or job. The Work library stores temporary SAS files that you
create, as well as files created internally by SAS. To access files in the Work library, specify a one-level name for the file. The libref Work is automatically assigned to these
files unless you have assigned the User libref. When you invoke SAS, it assigns the Work libref to a subdirectory of the directory specified in the WORK system option described in
System Options under UNIX. This subdirectory is usually named SAS_workcode_nodename , where:
" workcode : is a 12-character code. The first four characters are randomly generated numbers. The next eight characters are based on the hexadecimal process identification number
of the SAS session.
" nodename : is the name of the UNIX computer where the SAS process is running. This libref cannot be cleared or reassigned during a SAS session.





Question :

Which statement is false regarding DO UNTIL statements?

:
1. The condition is evaluated at the top of the loop, before the enclosed statements are executed.
2. The enclosed statements are always executed at least once.
 3. Access Mostly Uused Products by 50000+ Subscribers
4. The DO loop must have a closing END statement.

Correct Answer : Get Lastest Questions and Answer :

Explanation: The DO UNTIL condition is evaluated at the bottom of the loop, so the enclosed statements are always excecuted at least once.

The expression is evaluated at the bottom of the loop after the statements in the DO loop have been executed. If the expression is true, the DO loop does not iterate again.
There are three other forms of the DO statement:

The DO statement, the simplest form of DO-group processing, designates a group of statements to be executed as a unit, usually as a part of IF-THEN/ELSE statements.

The iterative DO statement executes statements between DO and END statements repetitively based on the value of an index variable.

The DO WHILE statement executes statements in a DO loop repetitively while a condition is true, checking the condition before each iteration of the DO loop. The DO UNTIL statement
evaluates the condition at the bottom of the loop; the DO WHILE statement evaluates the condition at the top of the loop.
Note: The statements in a DO UNTIL loop always execute at least one time, whereas the statements in a DO WHILE loop do not iterate even once if the condition is false.






Question : Which of the following program will create following output


A. proc print data=hetrain.helr2;
var DATE LOCATION FEE NOOFSTUDENTS;
sum FEE NOOFSTUDENTS;
run;

B. proc print data=hetrain.helr2;
var DATE LOCATION ;
sum FEE NOOFSTUDENTS;
run;

C. proc print data=hetrain.helr2;
var DATE LOCATION FEE ;
sum FEE NOOFSTUDENTS;
run;

: Which of the following program will create following output
1. A,B
2. B,C
 3. Access Mostly Uused Products by 50000+ Subscribers
4. A,B,C

Correct Answer : Get Lastest Questions and Answer :
Explanation: All the given options are correct. You do not need to name the variables in a VAR statement if you specify them in the SUM
statement, but you can. If you choose not to name the variables in the VAR statement as well, then the SUM statement determines their order in the
output.


Related 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



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. ;




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


Question : Whenver dates are given in the SAS dateset, SAS will read data from a fixed date , what is that fixed date?
 : Whenver dates are given in the SAS dateset, SAS will read data from a fixed date , what is that fixed date?
1. January 1, 2000 for dates greater than 01 Jan 2000

2. January 1, 2001 for dates greater than 01 Jan 2001

 3. Access Mostly Uused Products by 50000+ Subscribers

4. January 1, 1960 for any dates

5. January 1, 1000 for any dates



Question : Why SAS prefer to use SAS date values as numeric rather that text?

 : Why SAS prefer to use SAS date values as numeric rather that text?
1. It can be easily converted from numeric to text.

2. SAS does not have to any special calculation while storing numeric data

 3. Access Mostly Uused Products by 50000+ Subscribers

4. Date can be used for various calculations, hence storing them as numeric value will help.



Question : Which of the following statements are correct for SAS date values?

 : Which of the following statements are correct for SAS date values?
1. SAS automatically make the adjustment for day light savings on date values.

2. SAS automatically make the adjustment for leap years on date values.

 3. Access Mostly Uused Products by 50000+ Subscribers

4. SAS automatically make the adjustment for Julian dates on date values.