[Jul-2023] Updated and Accurate A00-231 Questions & Answers for passing the exam Quickly [Q151-Q174] : IT certification exam materials : http://blog.dumpleader.com

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?

400 for PROC PRINT4500 for PROC MEANS

401 for PROC PRINT4501 for PROC MEANS

401 for PROC PRINT4500 for PROC MEANS

500 for PROC PRINT5000 for PROC MEANS

NEW QUESTION 152
Which is a valid LIBNAME statement?

libname “_SAS_data_library_location_”;

sasdata libname “_SAS_data_library_location_”;

libname sasdata “_SAS_data_library_location_”;

libname sasdata sas “_SAS_data_library_location_”;

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?

1151960

‘1/15/1960’

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?

norowcount nocolcount

freq percent

norow nocol

nocounts

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?

data family ( dIm = ‘,’); infile ’tile specification’; input relation $ firstname $; run;

options dIm = ‘,’; data family; infile ‘file specification’; input relation $ firstname $; run;

data family; infile ‘file specification’ dIm = ‘,’; input relation $ firstname $; run;

data family; infile ‘file specification’; input relation $ firstname $ / dim = ‘,’; run;

NEW QUESTION 156
The following SAS program is submitted:

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

. (missing numeric)

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?

the numeric value 0

the character value “01011960”

a missing value due to syntax errors

the step will not compile because of the character argument in the mdy function.

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?

A second copy of the workbook named exceldata(2).xlsx. will be created with the new worksheet outdata.

A second worksheet outdata(2) will be added to the existing exceldata.xlsx workbook.

The program will overwrite the outdata worksheet in the exceldata.xlsx workbook.

The program will produce an error message indicating that the exceldata.xlsx workbook already exists.

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?

department = dept II number;

department = left(dept) II number;

department = trim(dept) number;

department=trim(dept)||put(number,3.);

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?

type colordaisygreen

type colordaisy ellow

type colordaisyyellow” “(missing character value)

No values are stored for the TYPE and COLOR variables.

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?

options pageno = 1;

options pagenum = 1;

options reset pageno = 1;

options reset pagenum = 1;

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?

day(BeginDate)

weekday(BeginDate)

dayofweek(BeginDate)

getday(BeginDate,today())

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?

LIST

NOCOLS

CROSSLIST

NOCROSSTAB

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?

X would get a value of 1.

X would get a value of 3.

X would retain its original value of missing.

This step does not run because of syntax errors.

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?

chem2

Unknown

Senior Chemist

‘ ‘ (missing character value)

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

libname sasdata ‘SAS-data-library’;data sasdata.mydata;copy mydata;run;

libname sasdata ‘SAS-data-library’;data sasdata.mydata;keep mydata;run;

libname sasdata ‘SAS-data-library’;data sasdata.mydata;save mydata;run;

libname sasdata ‘SAS-data-library’;data sasdata.mydata;set mydata;run;

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?

data employees; infile ‘file specification’dlm=’*’; input employee $ bdata: mmddyy10.years; run;

data employees; infile ‘file specification’dsd=’*’; input employee $ bdata mmddyy10.years; run;

data employees; infile ‘file specification’DLM dsd; input employee $ bdata mmddyy10.years; run;

data employees; infile ‘file specification’ dLM=’*’ dsd; input employee $ bdata: mmddyy10.years; run;

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

proc contents lib = sasuser.all; run;

proc contents data = sasuser.all; run;

proc contents lib = sasuser._alI_; run;

proc contents data = sasuser._all_; run;

NEW QUESTION 170
The following SAS program is submitted:

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

DayOfMonth, Year, and MonthOfYear are character.

DayOfMonth, Year, and MonthOfYear are numeric.

DayOfMonth and Year are numeric. MonthOfYear is character.

DayOfMonth, Year, and MonthOfYear are date values.

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?

WORK

REPORT.

HOUSES

SASUSER

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?

The program executes successfully and a temporary SAS data set is created.

The program executes successfully and a permanent SAS data set is created.

The program fails execution because the same SAS data set is referenced for both read and write operations.

The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.