using sas code list the observations for employee numbers $($EmpID$)$

$9888$ and

$0177.$ Do this in one of two ways: one, using OR operators or two, using the IN operator.

Note: EmpID is a character variable. Next, create a new temporary SAS dataset containing

Region and TotalSales plus a new variable called Weight, with values of

$1\mathrm{.}5$ for the North

Region,

$1\mathrm{.}7$ for the South Region, and

$2\mathrm{.}0$ for the West and East Regions. Use a SELECT

statement to do this. Finally, list all the observations where Region is

North and Quantity is

less than

$60.$ Include in this list any observations where the customer name $($Customer$)$ is

Pet$$s are Us$.$

Using the Sales.xls dataset,

mpID Name Region Customer Item Quantity UnitCost TotalSales

$1843$ George SmithNorth Barco Corporation$144$L $508\mathrm{.}99449\mathrm{.}5$

$1843$ George SmithSouth Cost Cutter's$1221005\mathrm{.}99599$

$1843$ George SmithNorth Minimart Inc$\mathrm{.}188$S $3519915597$

$1843$ George SmithNorth Barco Corporation$908$X $151295129$

$1843$ George SmithSouth Ely Corp. $122$L $1029\mathrm{.}95299\mathrm{.}5$

$0177$ Glenda JohnsonEast Food Unlimited$188$X $1006\mathrm{.}99699$

$0177$ Glenda JohnsonEast Shop and Drop$144$L $1008\mathrm{.}99899$

$1843$ George SmithSouth Cost Cutter's$855$W $191099109$

$9888$ Sharon Lu West Cost Cutter's$122505\mathrm{.}99299\mathrm{.}5$

$9888$ Sharon Lu West Pet's are Us$100$W $10001\mathrm{.}991990$

$0017$ Jason NguyenEast Roger's Spirits$122$L $50039\mathrm{.}9919995$

$0017$ Jason NguyenSouth Spirited Spirits$407$XX $10019\mathrm{.}951995$

$0177$ Glenda JohnsonNorth Minimart Inc$\mathrm{.}777510\mathrm{.}552\mathrm{.}5$

$0177$ Glenda JohnsonEast Barco Corporation$73321000020000$

$1843$ George SmithNorth Minimart Inc$\mathrm{.}188$S $3519915597$