A00-231試験無料問題集「SASInstitute SAS 9.4 Base Programming - Performance-based 認定」

The following SAS program is submitted:
data work.january;
set work.allmonths (keep = product month num_sold cost);
if month = 'Jan' then output work.january;
sales = cost * num_sold;
keep = product sales;
run;
Which variables does the WORK.JANUARY data set contain?

Which of the following SAS programs creates a variable named City with a value ofChicago?
Select one:

The following SAS program is submitted:
data work.retail;
cost = '20000';
total= .10* cost
run;
What is the result?

The following SAS program is submitted:

Which output is correct?

The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of "Asking Price".
Which SAS program temporarily replaces the label "Asking Price" with the label "Sale Price" in the output?

What describes the SAS automatic _ERROR_ variable?

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?

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?

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?

The contents of the raw data file CALENDAR are listed below:
--------10-------20-------30
01012000
The following SAS program is submitted:
data test;
infile 'calendar';
input @1 date mmddyy10.;
if date = '01012000'd then event = 'January 1st';
run;
Which one of the following is the value of the EVENT variable?

The contents of the raw data file AMOUNT are listed below:
--------10-------20-------30
$1,234
The following SAS program is submitted:
data test;
infile 'amount';
input @1 salary 6.;
if _error_ then description = 'Problems';
else description = 'No Problems';
run;
Which one of the following is the value of the DESCRIPTION variable?

Consider the data step:

Which of the following assignment statements for variable group are functionally equivalent to the original statement used in the above data step?

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

What issue generated the error in the log?

A realtor has two customers. One customer wants to view a list of homes selling for less than $60,000. The other customer wants to view a list of homes selling for greater than $100,000.
Assuming the PRICE variable is numeric, which one of the following PRINT procedure steps will select all desired observations?

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';
input sqfeet bedrooms baths street $
price: dollar10.;
run;
How many observations will the output data set contain?

Which statement describes a characteristic of the SAS automatic variable _ERROR_?

Which statement is true concerning the SAS automatic variable _ERROR_?

Which one of the following statements is true regarding the name of a SAS array?

The following SAS program is submitted:

How many observations are written to the WORK.SALES data set?

A raw data record is listed below:
--------10-------20-------30
1999/10/25
The following SAS program is submitted:
data projectduration;
infile 'file-specification';
input date $ 1 - 10;
run;
Which one of the following statements completes the program above and computes the duration of the project in days as of today's date?