Tag A00-231 reliable exam test

QUESTION 71
The following SAS program is submitted:
data WORK.OUTDS;
do until(Prod GT 6);
Prod + 1;
end;
run;
What is the value of the variable Prod in the output data set?

QUESTION 72
On which portion(s) of a SAS data set does the PRINT procedure report?

QUESTION 73
Given the following SAS log entry:

What caused the error?

QUESTION 74
Which step displays a listing of all the data sets in the WORK library?

QUESTION 75
The following SAS program is submitted:
proc contents data = sashelp.class varnum; quit;
What does the VARNUM option print?

QUESTION 76
Which statement specifies that records 1 through 10 are to be read from the raw data file customer.txt?

QUESTION 77
The following code was modified to generate the results further below:
proc format;
value agegrp
low-12 =’Pre-Teen’
13-high = ‘Teen’;
run;
proc means data=SASHELP.CLASS;
var Height;
class Sex Age;
format Age agegrp.;
run;
The following results were generated to display only specific statistics and limit the decimals with the modification:

Which statement below was modified or added to generate the results above:

QUESTION 78
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?

QUESTION 79
Which one of the following SAS system options prevents the page number from appearing on a report?

QUESTION 80
Given the AIRPLANES data set
AlRPLANES
TYPE MPG
——– ——
F-18 105
C-130 25
Harrier 75
A-6 110
The following SAS program is submitted:
data gt100;
set airplanes(keep = type mpg load);
load = mpg * 150;
run;
The program fails to execute due to syntax errors.
What is the cause of the syntax error?

QUESTION 81
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?

QUESTION 82
The following SAS program is submitted:

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

QUESTION 83
The following SAS program is submitted:
data work.test;
array items{3} _temporary_;
run;
What are the names of the variable(s) in the WORKTEST data set?

QUESTION 84
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?

QUESTION 85
The following SAS program is submitted:
data work.totalsales (keep = monthsales{12} );
set work.monthlysales (keep = year product sales);
array monthsales {12} ;
do i=1 to 12;
monthsales{i} = sales;
end;
run;
The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.
Which one of the following is the result of the above program?