ST 521 Final Exam

Which pointer control is used to read multiple records sequentially?

@n

How do you assign the 5th and 6th characters of an ID code to a new variable named CatCode?

CatCode=substr(ProductID,5,2); substring works best when extracting data from fixed position/length

T/F A macro variable can contain either character or numeric data

FALSE

T/F IF?THEN statements are used for iterative processing.

FALSE

T/F In SQL, SELECT, FROM, and WHERE clauses are required

FALSE

T/F Only one SQL statement may be executed within a PROC SQL step

FALSE

Which variable is a poor candidate for PROC MEANS? IDnum, Age, Height, or Weight

IDnum unlikely to yield useful stats

Select the SQL statement that returns the rowset of customers that have not placed any orders

LEFT JOIN orion.orders o ON c.customer_id=o.customer_id

Which statement correctly converts the values of SiteNum to character values when creating variable location? A typical value is 12.3

Location=dept ||'/'||put(sitenum,4.1); convert numeric to character using PUT, length of 4

Which program creates output with N, mean, stdev, min, max by var (sex)

PROC MEANS or PROC SUMMARY print var age height weight; class sex;

What is the difference between a SUM function and SUM statement?

SUM function asks on a list of variables and returns total, statement increments a variable by value (ex. count+1)

T/F The ARRAY statement is ignored during datastep execution

TRUE

T/F The PUTLOG statement can be useful for debugging programs

TRUE

What happens if you merge data with different entries of same variable?

The values of the 2nd data set overwrite the first

Finish the ARRAY statement to create temporary array elements: array goal{4}

_temporary_ (9000 9300 9600 9900)

By default, PROC FREQ creates a table of frequencies and percentages for which data set variables? (numeric or character)

both numeric and character

Best way to remove extra blanks bt first and last name?

fullname=trim(firstname) ||' '|| trim(lastname);

Which, when used in DATA step, writes obs after each value for Activity has been read?

input Activity : $ 10 . @; output; end; run; output statement must be in loop

Which reads the values for ID and holds the records for each value of Quantity so that all 3 observations are created for each record?

input ID$@; input Quantity:comma.@;

Which can determine the length of a new variable?

length of var's first reference, assignment statement, and LENGTH statement

Which would you use to compare result of investing 4000 a year for five years in three different banks?

nested DO loops

Which array reference for array element q50 array ques{3,25} q1-q75;

ques{2,25}

How to create PROC FREQ table with rows weight and columns height?

tables weight*height;

DUring compilation phase variables are created in PDV and observations are set to:

there are no observations the data step has not yet executed

Which statement will limit a PROC MEANS analysis to the variables Boarded, Transfer, and Deplane?

var boarded transfer deplane; PROC MEANS use VAR