$[6.$

Lecture $3$ Examples.sas $$ Follow the directions below to satisfy the requirements for your homework assignment. Replace all references to $"*$ enter your code here" with the relevant code. $/$ PROC SOL;

PROC SQL;

SELECT last$\_$name, state

FROM custom$$r

WHERE state $=\text{'}$NY$\text{'}$ ;

QUIT;

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

by product cost from the products table. Provide a list of the last names of all employees whose names start with the letters

$"$Me$"$ using the employee 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;