$[2.$ Lecture $3$ Examples.sas $$ BOYA Homework $3.$sas $x$

CODE LOG RESULTS

$(2)$ : SAS Programmer :

$/*$ Follow the directions below to satisfy the requirements for your homework assignment. Replace all references to $"*$ enter your code here" with the relevant code. $5/*$

$1*$ List the employee first and last names from the employee table. Don't forget, you need to specify both the library and the table name so in this case $3$ you'll select from ITKM$549.$employee. $*/$

PROC SQL;

QUIT; ${?}^{**}$ enter code here;

$3.\frac{?}{?}*$

I$*$ List the last names of all customers from New York $($NY$)$ in the customer table.

List their last names and their state. Hint: Watch your semicolons.$/*$ Provide a list of all of the products, all columns, in descending order

by product cost from the products table. Provide a count of the employees on the employee table. Include a descriptive header name. List all region names from the sales$\_$extract table. Remove duplicates. $*/$

PROC SQL;

QUIT; enter code here;