2023 Latest 100% Exam Passing Ratio – A00-231 Dumps PDF [Q156-Q175]

Q156. 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?

Q157. Given the contents of the raw data file ‘EMPLOYEE.TXT’

Which SAS informat correctly completes the program?

Q158. A raw data file is listed below:
RANCH,1250,2,1,Sheppard Avenue,”$64,000″
SPLIT,1190,1,1,Rand Street,”$65,850″
CONDO,1400,2,1.5,Market Street,”80,050″
TWOSTORY,1810,4,3,Garris Street,”$107,250″
RANCH,1500,3,3,Kemble Avenue,”$86,650″
SPLIT,1615,4,3,West Drive,”94,450″
SPLIT,1305,3,1.5,Graham Avenue,”$73,650″
The following SAS program is submitted using the raw data file as input:
data work.condo_ranch;
infile ‘file-specification’ dsd;
input style $ @;
if style = ‘CONDO’ or style = ‘RANCH’ then input sqfeet bedrooms baths street $ price : dollar10.; run; How many observations does the WORK.CONDO_RANCH data set contain?

Q159. The following SAS program is submitted:
data one;
date = ’04juI2005’d;
format date weekdate.; run;
proc print data = one; run;
What output is generated?

Q160. The following SAS program is submitted:
data work.test;
set work.staff (keep = jansales febsales marsales);
array diff_sales{3} difsales1 – difsales3;
array monthly{3} jansales febsales marsales;
run;
What new variables are created?

Q161. Consider the following data step:

The computed variables City and State have their values assigned using two different methods, a RETAIN statement and an Assignment statement.
Which statement regarding this program is true?

Q162. The following program is submitted:
proc contents data=_all_;
run;
Which statement best describes the output from the submitted program?

Q163. Given the contents of the raw data file EMPLOYEE:
—-|—-10—-|—-20—-|—-30
Alan
19/2/2004
ACCT
Rob
22/5/2004
MKTG
MaryJane
14/3/2004
EDUC
The following SAS program is submitted:
data emps;
infile ’employee’;
input@1 name$
@15 date <insert INFORMAT here>
@25 department$;
run;
Which INFORMAT correctly completes the program?

Q164. The following SAS program is submittad:
data work.sales;
do year = 1 to 5;
do month=1 to 12;
x+1;
output
end;
end;
run;
How many observations are written the WORK SALES data set?

Q165. CORRECT TEXT
This question will ask you to provide a line of missing code:
Given the SAS data set WORK.EMPLOYEE_UNFO:

The following SAS program is submitted:

In the space above, write the statement that will sort the data by ascending Expenses values within each ascending IDNumber value.

Q166. The following SAS program is submitted:

What will the data set WORK.TEST contain?

Q167. This question will ask you to provide a segment of missing code.
Given the SAS data set WORK.ONE:

The following SAS program is submitted:

The data set WORK.TWO is created, where Day would be the day of the month:

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

Q168. CORRECT TEXT
The following SAS program is submitted:

What value will SAS assign to Pos? Enter your numeric answer in the space below.

Q169. The following SAS program is submitted, creating the SAS data set ONE:
data one;
infile ‘file specification’;
input num chars$;
run;
ONE
NUMCHAR
123
323
177
The following SAS program is submitted:
proc print data = one;
where char = 23;
run;
What is output?

Q170. The following SAS program is submitted:
data WORK.ACCOUNTING;
set WORK.DEPARTMENT;
label Jobcode=’Job Description’;
run;
Which statement is true about the output dataset?

Q171. 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?

Q172. The following SAS program is submitted:
data work.products;
Product_Number = 5461;
Item = ‘1001’;
Item_Reference = Item’/’Product_Number;
run;
Which one of the following is the value of the variable ITEM_REFERENCE in the output data set?

Q173. The following SAS program is submitted:
data work.month;
date = input(’13mar2000′,date9.);
run;
Which one of the following represents the type and length of the variable DATE in the output data set?

Q174. After a SAS program is submitted, the following is written to the SAS log:

What changes should be made to the KEEP statement to correct the errors in the LOG?

Q175. The SAS data set EMPLOYEE_INFO is listed below:
IDNumber Expenses
2542 100.00
3612 133.15
2198 234.34
2198 111.12
The following SAS program is submitted:
proc sort data = employee_info;
run;
Which one of the following BY statements completes the program and sorts the data sequentially by descending expense values within each descending IDNUMBER value?