Sas L - C4

Front 1

What does a PROC PRINT statement do?

Back 1

Displays all observations, all variables, and an Obs column on the left side

PROC PRINT data=orion.sales;

Run;

Front 2

What does a VAR statement do in a PROC PRINT statement?

Back 2

Selects variables to include in the report and specifies their order

PROC PRINT data=orion.sales;

Var First_Name Last_Name Salary;

Run;

Front 3

What does a SUM statement do in a PROC PRINT statement?

Back 3

Calculates and displays report totals for the requested NUMERIC variables

PROC PRINT data=orion.sales;

Var First_Name Last_Name Salary;

sum Salary;

Run;

Front 4

What does a WHERE statement do in a PROC PRINT statement?

Back 4

Selects the observations that meet the criteria specified in the WHERE statement

PROC PRINT data=orion.sales;

Var First_Name Last_Name Salary;

where Salary<25500;

sum Salary;

Run;

Front 5

What does a NOOBS option do in a PROC PRINT statement?

Back 5

Suppresses the Obsevation column in the print out

PROC PRINT data=orion.sales NOOBS;

Var First_Name Last_Name Salary;

sum Salary;

Run;

Front 6

What is the comparison operator for equal to?

Back 6

= or EQ

WHERE gender = 'M';

WHERE gender eq 'M';

Front 7

What is the comparison operator for Not Equal To

Back 7

^= or ~= or NE

WHERE salary ^= .;

WHERE salary ~= .;

WHERE salary ne .;

Prints salary that does not equal missing value

Front 8

What is the comparison operator for Greater Than

Back 8

> or GT

WHERE salary>50000;

WERE salary GT 50000;

Front 9

What is the comparison operator for Less Than

Back 9

< or LT

WHERE salary<50000;

WHERE salary LT 50000;

Front 10

What is the comparison operator for Greater Than or Equal?

Back 10

>= or GE

WHERE salary >= 50000;

WHERE salary GE 50000;

Front 11

What is the comparison operator for Less than or equal?

Back 11

<= or LE

Where salary <= 50000;

WHERE salary LE 50000;

Front 12

What is the comparison operator for equal to one of a list?

Back 12

IN

WHERE Country in ('AU' 'US');

WHERE OrderType in (1,2,3);

The value list in the IN operator must be enclosed in parenthesis and separated by either commas or blanks. Character values must be enclosed in quotation marks

Front 13

What does the NOT operator do?

Back 13

The NOT operator modifies a condition by finding te complement of the specified criteria

WHERE city NOT in ('LONDON', 'ROME', 'PARIS');

Front 14

Create a WHERE statement to subset by Country and Job_Title

PROC PRINT data=orion.sales NOOBS;

var Last_Name First_Name Country Job_Title;

Back 14

WHERE country = 'AU' and

Job_Title contains 'Rep';

run;

Front 15

What does a CONTAINS option do in a PROC PRINT statement?

Back 15

Selects observations that include the specified substring

Where Job_Title contains 'Rep';

Where Job_Title ? 'Rep';

*Case Sensitive

Front 16

What are the six special WHERE operators that can only be used in WHERE expressions?

Back 16

1) Contains (Char) - includes substring

2) Between-And (Char/Num) - an inclusive range

3) Where Same And (Char/Num) - Augment WHERE statement

4) IS NULL (Char/Num) - A missing value

5) IS MISSING (Char/Num) - a missing value

6) LIKE (Char) - Matches a pattern

Front 17

What does the BETWEEN-AND operator do?

Back 17

Selects observations in which the value of a variable falls within an inclusive range of values

Where salary between 50000 and 100000;

Where salary not between 50000 and 100000;

Where Last_Name between 'A' and 'L';

Where Last_Name between 'Baker' and Gomez';

Front 18

Equivalent statements for the BETWEEN-AND operator

Back 18

Where salary between 50000 and 100000;

Where salary >= 50000 and salary <=100000;

Where 50000<=Salary<=100000;

Front 19

What does the WHERE SAME AND operator do?

Back 19

Add more conditions to an existing WHERE expression

PROC PRINT data=orion.sales;

where country='AU' and Salary <30000;

where same and Gender='F'

var First_Name Last_Name Gende Salary Country;

run;

Front 20

WHERE SAME AND is same as....

Back 20

Where also

Front 21

What does the IS NULL operator do?

Back 21

Selects observations in which a variable has a missing value

Where employee_ID is null;

Where employee_ID is not null;

Where employee_ID = ' ';

Where employee_ID= .;

Front 22

What does the IS MISSING operator do?

Back 22

Selects observations in which a variable has a missing value

Where Employee_ID is missing;

Where Employee_ID is not missing;

Where Employee_ID=' ';

Where Employee_ID= .;

Front 23

What does the LIKE operator do?

Back 23

Selects observations by comparing character values to specified patterns.

a % sign specifies any number of characters can occupy that position

ex: Where name like '%N';

a _ specifies that exactly one character can occupy that position

ex: Where name like 'T_M';

Where name like 'T_M%'

Front 24

What does the SORT procedure do?

Back 24

rearranges the observations in the input data set based on the values of the variable or variables listed in the BY statement

Proc sort data=orion.sales;

out=work.sales;

by Salary;

run;

Front 25

What does the OUT statement do in a PROC SORT statement?

Back 25

Out=new library.data set

This creates a new, sorted data set instead of writing over original data set

Front 26

What is the default for a PROC SORT step?

Back 26

Ascending

Front 27

What is shorthand for descending?

Back 27

DESC

Front 28

Where titles or footnotes in Proc Print step?

Back 28

Before Proc Print

Front 29

How many titles can you have?

Back 29

1-10

TITLEn'text'

title1 'This is the first Line';

Front 30

If you want to end a title or footnote, what do you do

Back 30

title;

footnote;

Front 31

What does the LABEL statement do in a PROC PRINT step?

Back 31

Changes the names of the variables

Proc Print data=orion.sales label;

var Employee_ID Last_Name Salary;

LABEL Employee_ID='Sales ID';

Last_Name='Last Name';

Salary='Annual Salary';

run;

Front 32

What does the SPLIT= option do in a PROC PRINT step?

Back 32

Specifies a split character to control line breaks in column headings

Proc Print data=orion.sales split='*';

var Employee_ID Last_Name Salay

LABEL Employee_ID='Sales ID'; Last_Name='Last*Name'; Salary='Annual*Salary';

run;

Essentially this a WRAP TEXT function