[Jul-2023] Updated and Accurate A00-231 Questions & Answers for passing the exam Quickly [Q151-Q174]

NEW QUESTION 151
When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:
libname sasdata ‘SAS-data-library’;
options obs = 500;
proc print data = sasdata.prdsales (firstobs = 100); run;
options obs = max;
proc means data = sasdata.prdsales (firstobs = 500); run;
How many observations are processed by each procedure?

NEW QUESTION 152
Which is a valid LIBNAME statement?

NEW QUESTION 153
The following SAS program is submitted:
data revenue;
set year_1;
var1 = mdy(1,15,1960);
run;
Which one of the following values does the variable named VAR1 contain?

NEW QUESTION 154
The following output is created by the FREQUENCY procedure:

Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?

NEW QUESTION 155
Given the following raw data record:
—-I—-10—I—-20—I—-30
son Travis,
The following output is desired:
Obs relation firstname
1 son Travis
Which SAS program correctly reads in the raw data?

NEW QUESTION 156
The following SAS program is submitted:

What is the value of the variable Prod in the output data set?

NEW QUESTION 157
The following SAS program is submitted:
data WORK.DATE_INFO;
Day=”01″ ;
Yr=1960 ;
X=mdy(Day,01,Yr) ;
run;
What is the value of the variable X?

NEW QUESTION 158
The following SAS program is submitted:
data work.accounting;
set work.dept1 work.dept2;
jobcode = ‘FA1’;
length jobcode $ 8;
run;
A character variable named JOBCODE is contained in both the WORK.DEPT1 and WORK.DEPT2 SAS data sets. The variable JOBCODE has a length of 5 in the WORK.DEPT1 data set and a length of 7 in the WORK.DEPT2 data set.
What is the length of the variable JOBCODE in the output data set?

NEW QUESTION 159
A SAS programmer assigns a library reference to an existing Excel workbook named exceldata.xlsx. Using a DATA step, the programmer attempts to create a worksheet named outdata in this Excel workbook. However, the Excel workbook already contains a worksheet named outdata.
What will happen?

NEW QUESTION 160
Given the raw data record DEPT:
—-|—-10—|—-20—|—-30
Printing 750
The following SAS program is submitted:
data bonus;
infile ‘dept’;
inputdept$ 1-11 number 13- 15;
<insert statement here>
run;
Which SAS statement completes the program and results in a value of ‘Printing750’ for the DEPARTMENT variable?

NEW QUESTION 161
Given the contents of the raw data file TYPECOLOR:
—-I—-10—I—-20—I—-30
Daisyyellow
The following SAS program is submitted:
data flowers;
infile ‘typecolor’;
input type$ 1-5+1 color$;
run;
What are the values of the variables TYPE and COLOR?

NEW QUESTION 162
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?

NEW QUESTION 163
Given the SAS data set WORK.ONE:

The following SAS program is submitted:

The data set WORK.TWO is created, where Day would be 1 for Sunday, 2 for Monday, 3 for Tuesday, … :

Which expression successfully completed the program and creates the variable DAY?

NEW QUESTION 164
The following SAS program is submitted:
proc freq data = class;
tables gender * age / <insert option here>;
run;
The following report is created:
The FREQ Procedure
Table of gender by age
Row Column
Gender ageFrequencyPercent Percent Percent
F11110.0020.0050.00
12220.0040.0040.00
13220.0040.0066.67
Total550.00100.00
M11110.0020.0050.00
12330.0060.0060,00
13110.0020.0033.33
Total550.00100.00
Total11220.00100.00
12550.00100.00
13330.00100.00
Total10100.00
Which option correctly completes the program and creates the report?

NEW QUESTION 165
Consider the following data step:

In filtering the values of the variable X in data set WORK.OLD, what value new value would be assigned to X if its original value was a missing value?

NEW QUESTION 166
The following SAS program is submitted:
data test;
set chemists;
jobcode = ‘Chem2’
then description = ‘Senior Chemist’;
else description = ‘Unknown’;
run;
The value for the variable JOBCODE is:
JOBCODE
————-
chem2
What is the value of the variable DESCRIPTION?

NEW QUESTION 167
Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?

NEW QUESTION 168
Given the following raw data records:

The following output data set is desired:

Which SAS program correctly reads in the raw data?

NEW QUESTION 169
Which program displays a listing of all data sets in the SASUSER library?

NEW QUESTION 170
The following SAS program is submitted:

What types of variables are DayOfMonth, MonthOfYear, and Year?

NEW QUESTION 171
The following SAS SORT procedure step generates an output data set:
proc sort data = sasuser.houses out = report;
by style;
run;
In which library is the output data set stored?

NEW QUESTION 172
Given the raw data file EMPLOYEE.TXT:

The following SAS program is submitted:

What value does the variable idnum contain when the name of the employee is “Ruth”?

NEW QUESTION 173
CORRECT TEXT
Given the SAS data set WORK.EMP_NAME:

Given the SAS data set WORK.EMP_DEPT:

The following program is submitted:

How many observations are in data set WORK.ALL after submitting the program?
Enter your numeric answer in the space below.

NEW QUESTION 174
The following SAS program is submitted:
libname temp ‘SAS data library’;
data temp.sales;
merge temp.sales
work.receipt;
by names;
run;
The input data files are sorted by the NAMES variable:
What is the result?