Official Bank 0/270

SAS Base Programming for SAS (r) 9 Exam (A00-211) - SASI Exam Questions

Last updated on June 20, 2026

97% Exam Compliance
270 Total Questions
1
Question
Which step sorts the observations of a permanent SAS data set by two variables and stores the sorted observations in a temporary SAS data set?
Options
A proc sort out=EMPLOYEES data=EMPSORT;by Lname and Fname;run;
B proc sort data=SASUSER.EMPLOYEES out=EMPSORT;by Lname Fname;run;
C proc sort data=SASUSER.EMPLOYEES out=SASUSER.EMPSORT;by Lname and Fname;run;
D proc sort out=SASUSER.EMPLOYEES data=WORK.EMPSORT;by Lname Fname;run;
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
The contents of the raw data file SIZE are listed below:

--------10-------20-------30
72 95

The following SAS program is submitted:
data test;
infile 'size';
input @1 height 2. @4 weight 2;
run;

Which one of the following is the value of the variable WEIGHT in the output data set?
Options
A 2
B 72
C . (missing numeric value)
D 95
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
Given the SAS data set WORK.ONE:

And the SAS data set WORK.TWO:

The following program is submitted: What is the first observation in the SAS data set WORK.BOTH?

Exhibit
Options
A Option A
B Option B
C Option D
D Option C
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
The following SAS program is submitted:
data _null_;
set old (keep = prod sales1 sales2);
file 'file-specification';
put sales1 sales2;
run;

Which one of the following default delimiters separates the fields in the raw data file created?
Options
A : (colon)
B ; (semicolon)
C (space)
D , (comma)
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
Given the following raw data records in DATAFILE.TXT:

Exhibit

Which output is correct based on the submitted program?

Exhibit
Options
A Option A
B Option B
C Option D
D Option C
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.