Defining and Using Macro Variables for Numeric Substitution

a$.$ Save the customer$\_$dim dataset to the Homework folder on your computer. Create a libref that points to that location.

b$.$ Copy and paste the program found below into the Editor window. Edit the program to display only the Gold$-$level customers between the ages of $30$ to $45.$

$!$ Customer ages range from $19$ to $73.$

proc print

data$=$yourlibref.customer$\_$dim;

var Customer$\_$Name Customer$\_$Gender

Customer$\_$Age;

where Customer$\_$Group contains 'Gold';

title 'Gold Customers';

run;

SAS Output

Gold Customers between $30$ and $45$

$\backslash$table$[[$Customer$,$Customer$],[$Obs$,$Customer$\_$Name,Gender,Age,$],[,,,,],[3,$Cornelia Krahl,F$,33,],[11,$Oliver S$.$ F$$ling$,$M$,43,],[32,$James Klisurich,M$,38,],[35,$Viola Folsom,F$,38,],[40,$Kyndal Hooks,F$,43,],[57,$Rita Lotz,F$,43],[75,$Angel Borwick,F$,38]]$

c$.$ Modify the program so that the values $30$ and $45$ are replaced by references to the macro variables age $1$ and age$2,$ respectively.

d$.$ Modify the program so that the value Gold is replaced by references to a macro variable, type.

e$.$ Include the appropriate system option to display resolved values of macro variables in the SAS log$.$ Resubmit the program and examine the log$.$

f$.$ Modify the values of age$1,$ age$2,$ and Gold. Resubmit the program and examine the log$.$

g$.$ Turn off the system option from part e above.