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

NO.45 The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.; The following SAS program is submitted:

What are the formats of the variables LocalFee and CountryFee in the output data set?

NO.46 The contents of the raw data file PRODUCT are listed below:
——–10——-20——-30
24613 $25.31
The following SAS program is submitted:
data inventory;
infile ‘product’;
input idnum 5. @10 price;
run;
Which one of the following is the value of the PRICE variable?

NO.47 The following SAS program is submitted:
data work.passengers;
if OrigPassengers = . then’
OrigPassengers = 100;
TransPassengers = 100;
OrigPassengers = .;
TotalPassengers = sum (OrigPassengers, TransPassengers) +0;
run;
What is the value of the TOTALPASSENGERS variable in the output data set?

NO.48 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.

NO.49 The Excel workbook REGIONS.XLS contains the following four worksheets:
EAST
WEST
NORTH
SOUTH
The following program is submitted:
libname MYXLS ‘regions.xls’;
Which PROC PRINT step correctly displays the NORTH worksheet?

NO.50 You’re attempting to read a raw data file and you see the following messages displayed in the SAS Log:

What does it mean?

NO.51 Given the SAS data set WORK.PRODUCTS:

How many variables does the WORK.REVENUE data set contain?

NO.52 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?

NO.53 The following SAS program is submitted:

If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?

NO.54 The following SAS program is submitted:
data combine;
prefix=’505′;
middle=’6465 ‘;
end=’09090′;
<insert statement here>;
run;
Which statement successfully completes the program so that TOTAL has a value of 505-6465-09090?

NO.55 The following SAS program is submitted:
options pageno = 1;
proc print data = sasuser.houses;
run;
proc means data = sasuser.shoes;
run;
The report created by the PRINT procedure step generates 5 pages of output.
What is the page number on the first page of the report generated by the MEANS procedure step?

NO.56 Given the contents of the raw data file TYPECOLOR.DAT:

The following SAS program is submitted:

What are the values of the variables Type and Color?

NO.57 Given the SAS data set WORK.P2000:

And the SAS data set WORK.P2008:

The following output is desired:

Which SAS program correctly combines the data?

NO.58 The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named Char:

The following SAS program is submitted:

What is output?

NO.59 The following SAS program is submitted:
data test;
infile ‘file specification’;
input name $ amount@@;
run;
Which of the following is true?

NO.60 The following SAS program is submitted:

The program fails execution due to syntax errors.
What is the cause of the syntax error?

NO.61 The following SAS program is submitted:
proc contents data = sasuser.airplanes;
run;
Which one of the following is produced as output?

NO.62 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?

NO.63 After a SAS program is submitted, the following is written to the SAS log:
105 data january;
106 set allmonths(keep = product month num_sold cost);
107 if month = ‘Jan’ then output january;
108 sales = cost * num_sold;
109 keep = product sales;
——
22
ERROR 22-322: Syntax error, expecting one of the following:!, !!, &, *,**, +, -,/, <,< =, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR,^=,|,II,
110 run;
What changes should be made to the KEEP statement to correct the errors in the LOG?

NO.64 The following SAS program is submitted:

What new value would be assigned to X if its original value was a missing value?

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

NO.66 Given the following raw data records:

The following output is desired:

Which SAS program correctly reads in the raw data?

NO.67 On which portion(s) of a SAS data set does the PRINT procedure report?