Suppose you want to write a DATA step that reads a raw data file. Do you need to use a LIBNAME statement to assign a libref to the directory in which the raw data file is stored?

Which of the following statements is true?

Which statement is true of a DATA step when reading from a raw data file?

Which of the LENGTH statements below creates the character variable SalesRep with a length of 18?

Which of the DATA steps below creates the variable SalesRep with a length of 18?

Which of these statements is not true about a SAS informat?

Which of the following DATA steps correctly reads instream data as input for the data set?

By default, SAS creates character variables with a length of _____ bytes for list input.

Which of the following values can SAS store, without truncation, in a character variable that has a length of 8 bytes?

Which of the following statements specifies instream data, or the lines of data that you enter directly in a DATA step?

Which of the following statements cannot be used in a DATA step that reads a raw data file as input?

Which of the following can determine the length of a new variable?

Which of the following SAS functions returns a number from 1 to 12?

Which DATA step ensures that all observations are assigned a nonmissing value for Bonus?

Which of the following statements assigns the value pass to the variable Grade when the variable Points is greater than or equal to 70?

Which SET statement has correct syntax?

Which of the following statements is true about merging SAS data sets by using the DATA step?

Which of the following programs concatenates the data sets, sales and products, in that order?

If you run this DATA step, what observations does the data set bonuses contain?

data bonuses;
merge managers staff;
by EmpID;
run;

What is the syntax error in this DATA step?
data returns_qtr1;
set returns_jan(rename=(ID=CustID)
(Return=Item))
returns_feb(rename=(Dt=Date))
returns_mar;
run;

If you run this DATA step, what observations does the data set bonuses contain?
data bonuses;
merge managers (in=M)
staff (in=S);
by EmpID;
if M=0 and S=1;
run;

What change was needed in the TABLES statement?

proc freq data=orion.sales;
tables Country nocum nopercent;
run;

PROC UNIVARIATE identified two observations with Salary values less than 24000. What procedure can you use to display the observations containing the invalid values?

Which of these procedures produces output that is most useful for detecting duplicate values?

Which of these programs is most useful for determining the exact observation that contains a numeric variable with an extreme value?

A PROC FREQ analysis identified invalid and missing values in a data set. Which of these procedures can display the observations that contain invalid or missing values?

Which option enables you to specify the number of extreme observations displayed by PROC UNIVARIATE?

Which program correctly opens and closes the LISTING destination?

The SAS data set orion.growth contains 6 observations and 3 variables (Department, Total_Employees, and Increase). How many observations and variables will the forecast data set contain?

data forecast;
set orion.growth;
TotalYear1=Total_Employees*(1+Increase);
run;

If you submit the code shown here, what happens if the value of Country is canada?
data northamerica asia check;
set salesdata;
select(Country);
when ("US","CANADA","MEXICO") output northamerica;
when ("JAPAN") output asia;
otherwise output;
end;
run;

Which of the following programs correctly assigns values of Bonus based on values of Promotion?

The data set employee_addresses has 9 variables. After this code runs, how many variables will there be in the usa data set?

data usa(keep=Employee_Name City State) australia other;
set orion.employee_addresses;
if Country='US' then output usa;
else if Country='AU' then output australia;
else output other;
run;

Which program reads data from observation 100 to observation 200 and prints 50 observations?

Which DATA step creates Mth2Dte as an accumulating variable with an initial value of 50?

Which DATA step creates Mth2Dte as an accumulating variable with an initial value of 0?

Which statement retains the value of Sales2Dte in the PDV across iterations of the DATA step?

Is this statement true? To create an accumulating total for a group, you first have to sort the data by the grouping variable(s)

Which statement is true about the following program?
data payroll.empmast;
set payroll.employee;
by gender jobcode;
run;

Which statement is false about BY-group processing when you use the BY statement with the SET statement?

If you process a BY group that consists of a single observation, what are the correct values of FIRST.BY-variable and LAST.BY-variable?

When using the DATA step to summarize grouped data, what is the first step in the process?

Which DATA step statement indicates to continue processing the last observation of a BY group?

Which raw data value below is an example of nonstandard numeric data?

Can you use column input to read both standard and nonstandard data in fixed fields?

Which informat below should you use to read the raw data value $1,230,456 as a numeric variable?

Which style of INPUT statement specification is used to read data in fixed columns?

In the INPUT statement, what is the syntax used to move the input pointer to a specified column?

Formatted input cannot be used to read which of the following types of raw data?

The single trailing @ releases a record when which of the following conditions occurs?

What does a forward slash (/) indicate when used in an INPUT statement?

When you use a trailing @, which of the following things occur?

Which of the following statements is false?

If you specify the period, comma, and blank as delimiters for the SCAN function, what is the fourth word in the text string below?

MR. JONATHAN E. MATTHEWS, PERSONNEL DIRECTOR

If you specify the colon as the delimiter for the SCAN function, how many words appear in the text string below?

Washington:New York:California:New Mexico

Which of the following FIND functions returns the value 1?

Select the statement that replaces the first three characters in values of Dept with the characters PUR.

Select the assignment statement that changes the string Burma to Myanmar in values of the variable Country. Assume that Country has a length of 25 bytes.

Which of the following assignment statements correctly calculates the average of Rest1, Rest2, Rest3, and Rest4?

Which statement correctly describes the result of submitting the DATA step that is shown below? The variables TotalPay and Commission are numeric. The variable Pay is character.

data reg.newsales;
set reg.sales;
TotalPay=Pay+Commission;
run;

A typical value for the character variable Target is 123,456. Which statement correctly converts the values of Target to numeric values when creating the variable TargetNo?

Which function calculates the average of the variables Var1, Var2, Var3, and Var4?

Which function returns the greatest integer less than or equal to the argument?

Which value is returned from the following statement?
x=int(7.89)

If the value of PctDec is -3.272, which statement will NOT return a value of -3 for Decrease?

Within the data set hrd.temp, PayRate is a character variable and Hours is a numeric variable. What happens when the following program is submitted?

data temp;
set hrd.temp;
Salary=PayRate*Hours;
run;

Which of the following functions can convert the values of the numeric variable Level to character values?

A typical value for the numeric variable SiteNum is 12.3. Which statement correctly converts the values of SiteNum to character values when creating the variable Location?

Which of the following functions converts the character values of Base to numeric values?

AvgSale=input(AvgSale,comma6.);

What will this PUTLOG statement do?

Which of the following represents acceptable syntax for the END= option in the INFILE statement?

Is it acceptable to use the END= option in both SET and INFILE statements?

Which of the following is not a task of the PUTLOG statement?

The variable Title is 22 characters long. One of the values for Title is My House on the Lane. Which of the following statements would provide the full value of the variable in the log if the data included two leading spaces?

When you submit the following program, what will be listed in the log?

data work.holdings;
set work.catalog end=last;
if _n_=1 then
putlog 'books';
if last then do;
putlog 'last of books';
putlog _all_;
end;
run;

Select the DO WHILE statement that would generate the same result as the program below.

data work.invest;
Capital=100000;
do until(Capital gt 500000);
Year+1;
Capital+(Capital*.10);
end;
run;

How many times does this DO loop execute?

data work.test;
x=15;
do while(x<12);
x+1;
end;
run;

What is the value of X at the completion of the DATA step?

data work.test;
x=15;
do while(x<12);
x+1;
end;
run;

In the example below, the variable X is summed during each iteration of the DO loop. What is the value of X at the completion of this DATA step?

data test;
do i=1 to 5;
do j=1 to 4;
x+1;
end;
end;
run;

Which statement is false regarding nested DO loops?

During each execution of the following DO loop, the value of Earned is calculated and is added to its previous value. How many times does this DO loop execute?

data finance.earnings;
Amount=1000;
Rate=.075/12;
do Month=1 to 12;
Earned+(Amount+Earned)*Rate;
end;
run;

In the data set invest, what would be the stored value for Year?

data invest;
do Year=2008 to 2012;
Capital+5000;
Capital+(Capital*.03);
end;
run;

What is the value of X at the completion of the DATA step?

data test;
x=15;
do while(x>12);
x+1;
end;
run;

In the following DATA step, how many times does the inner DO loop execute?

data invest;
do Year=2008 to 2012;
Capital+5000;
do Quarter=1 to 4;
Capital+(Capital*.03);
end;
end;
run;

Based on this DATA step, how many observations will the earnings data set contain?

data earnings;
Earned=0;
do Count=1 to 12;
Earned+(Amount+Earned)*(Rate/12);
output;
end;
run;

Which of the following statements will not execute a DO loop?

How many times does this DO loop execute?

data test;
x=15;
do until(x>12);
x+1;
end;
run;

What is the value of X at the completion of the DATA step?

data test;
x=15;
do until(x>12);
x+1;
end;
run;

Which statement about SAS arrays is true?

Which of the following ARRAY statements is correct?

The trial data set contains five numeric variables that store data collected during an experimental trial. Which ARRAY statement groups the variables T1, T2, T3, T4, and T5 into an array named test?

Which DO loop completes the program so that the values stored in the variables Weight1-Weight8 are converted from kilograms to pounds?

data hrd.convert;
set hrd.fitclass;
array wt{*} Weight1-Weight8;
___________
__________
___________
run;

Which ARRAY statement correctly defines a temporary lookup table named country with three elements that are initialized to AU, NZ, and US?

Which statement is false regarding an ARRAY statement?

What belongs within the braces of this ARRAY statement?

array contrib{?} qtr1-qtr4;

What does the following ARRAY statement do?

array seed{*} _character_;

For the program below, select the interative DO statement that processes all elements in the contrib array.

data work.contrib;
array contrib{4} qtr1-qtr4;
_____________
contrib{i}=contrib{i}*1.25;
end;
run;

What is the value of the index variable that references Jul in the statements below?

array quarter{4} Jan Apr Jul Oct;
do i=1 to 4;
yeargoal=quarter{i}*1.2;
end;

Which statement below is false regarding the use of arrays to create variables?

What are the names of the two temporary variables created by the BY statement in the code below?

data orderdata(keep=Customer_Name Quantity Total_Retail_Price)
noorders(keep=Customer_Name Birth_Date);
merge orion.customer
work.orders_2007(in=order);
by Customer_ID;
if order=1 then output orderdata;
else output noorders;
run;

Which statements correctly access the Supplier worksheet in the Excel workbook?

Which statement is true concerning match-merging?

Which of the following data set options can be added to the MERGE statement to help identify data set contributors (that is, identify the matches)?

The following program will execute without errors:

data bonuses;
merge managers(in=M)
staff(in=S);
by EmpID;
if M=0 and S=1;
run;;

Which subsetting IF statement selects observations for subsequent processing only if all three input data sets contribute to the current observation?

data merged.flowers;
merge spring.roses(rename=(red=BrickRed) in=yellow)
spring.lilacs(in=purple)
spring.petunias(in=pink);
by ID;
_________________________
run;

Which of the following LIBNAME statements correctly assigns the libref mymusic to the file AllMusic.xls, which is stored in the Entertainment directory of the C: drive on the Windows operating environment?

The data sets ensemble.spring and ensemble.summer both contain a variable named Blue, and Blue is not the BY variable. Which program prevents the values of the variable Blue from being overwritten when you merge the two data sets?

Suppose the empinfo.bonuses data set contains the variables ID, Name, Office, Manager, Location, and Amount. Specify a data set option in the MERGE statement below to use only the variables ID, Name, and Amount in the data set.

data mergedata.emppay;
merge sales.reps(rename=(office=OfficeNumber))
empinfo.sales
empinfo.bonuses ___________________;
by ID;
run;

The control data set that you use to create a format must contain variables that supply the same information as which of the following statements?

SAS stores formats as entries in which of the following?

Which of the following PROC FORMAT steps creates a format from the temporary data set citycode and saves the format to sasuser.formats?

Given the following OPTIONS statement, in what order will SAS search to find a user-defined format?

options fmtsearch=(rpt prod.newfmt);

Given the following PROC FORMAT step, select the OPTIONS statement to submit before SAS can use the region format.

proc format lib=sasuser;
value region
1='North'
2='South'
3='East'
4='West'
run;

Which of the following statements can you add to this PROC FORMAT step to document all of the formats in the sasuser.formats catalog except the $geoarea and geopop formats?

proc format lib=sasuser fmtlib;
___________________________
run;

Which option do you use with PROC FORMAT to document the format in a particular format catalog?

Which PROC FORMAT option do you use to create a SAS data set from a format?

Which PROC FORMAT statement option is used to create a permanent format?

Given the following OPTIONS statement, in what order will SAS search to find a user-defined format?

options fmtsearch=(orion.MyFmts);

Which statement best describes the purpose of the output control data set?

When the NOFMTERR system option is in effect, what happens when SAS encounters a format it can't locate?

Which statement is true concerning the FMTLIB option in PROC FORMAT when generating a report for permanent formats?

Which procedure enables you to manage a SAS catalog?

In which location can you not use a FORMAT?

Which value statement correctly creates a nested format definition?

Which statement about PROC SQL is false?

Which code creates a report that displays two columns from orion.donate? (Assume that the orion library is already defined.)

Which PROC SQL step creates only an output table named clinic.bills?

The tables Orion.customer and orion.country both store country abbreviations in a column named Country. The other columns have unique names. In a PROC SQL step, which SELECT statement correctly joins the two tables on matching values of Country?

PROC SQL stops running when it encounters which of the following?

In this PROC SQL step, which clause or clauses are written incorrectly?

proc sql;
select Employee_ID
Name
Dependents
from orion.employees
where Salary < 50000;
quit;

Which code fragment correctly completes the WHERE clause in this PROC SQL step joining the two tables by Policy?

proc sql;
select claims.Policy,
Claim_Num,
Dependents
from insurance.claims
insurance.accounts
where _______________=
_______________;
quit;

In the SELECT statement, when is a WHERE clause required?

Airline.expenses and airline.revenue both have 30 rows, and one column in common named Flight_ID. Each row in the first table has a value of Flight_ID that matches the Flight_ID value in one and only one row in the second table. When you run this PROC SQL program, how many rows appear in the result set?

proc sql;
select expenses.Flight_ID,
Amount, Date
from airline.expenses,
airline.revenue;
quit;

The tables orion.orders and orion.customers have the common column Customer_ID. What output does this program generate?

proc sql;
select Order_ID,
Customer_ID,
Order_Type
from orion.orders;
select Customer_ID,
Customer_Age_Group,
Order_Type
from orion.customers;
quit;

Will this PROC SQL step run?

proc sql;
select SaleDate
from company.sales
where SaleAmt>500;
quit;

The table insurance.claims contains the columns Policy, Claim_Num, and Status. The table insurance.accounts also contains the column Policy. These two tables are not sorted. Will this PROC SQL step create a report?

proc sql;
select accounts.Policy,
Claim_Num,
Status
from insurance.claims,
insurance.accounts
where accounts.Policy =
claims.Policy;
quit;

Which code fragment completes the FROM clause in this PROC SQL step?

proc sql;
select x.Policy,
Claim_Num,
Status
from insurance.claims ___
insurance.accounts x
where x.Policy =
y.Policy;
quit;

Which of the following statements about the SAS macro facility are true?

Which of the following statements is true about macro variables?

What is the value and length of the macro variable fname, based on the %LET statement shown below?

%let fname= Marie

What is the value and length of the macro variable name, based on the %LET statement shown below?

%let name="Marie Hudson";

What is the value and length of the macro variable total, based on the %LET statement shown below?

%let total=10+2;