$/*$ Rollow the directions below to satisfy the requirements for your homework assignment. enter your code here" with the relevant code. $,*$ to the relevant lecture examples SAS program and PowerPoint lecture slides. List the employee first and last names from the employee table. $*/$

$1**$ Don't forget, you need to specify both the library and the table name so in this case

you'll select from ITKM$549.$ employee. $*/$

PROC SQL;

enter code here;

QUIT;

$/*$ 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.$*/$

PROC SQL;

enter code here;

QUIT;

$/*$ Provide a list of all of the products, all columns, in descending order

by product cost from the products table.$*/$

PROC SQL;

enter code here;

QUIT;

$/*$ Provide the list of products on the products table that cost between $$50$ and $$100.*/$

PROC SQL;

enter code here;

QUIT;

$/*$ Provide a list of the last names of all employees whose names start with the letters $"$Me$"$ using the employee table. $*/$

PROC SQL;

enter code here;

QUIT;

$/*$ Provide a count of the employees on the employee table. Include a descriptive header name. $*/$ PROC SQL;

enter code here;

QUIT;

$/*$ List all region names from the sales$\_$extract table. Remove duplicates. $*/$ PROC SQL;

enter code her$$;

QUIT;