ANSWER IN SAS

6. Using Macro Variables to Subset Data in Procedures a. Create a new program. Write a PROC FREQ step to analyze rows from pg1.np_species. Include only rows where Species_ID starts with YOSE (Yosemite National Park) and Category equals Mammal. Generate frequency tables for Abundance and Conservation_Status. b. Write a PROC PRINT step to list the same subset of rows from pg1.np_species. Include Species_ID, Category, Scientific_Name, and Common_Names in the report. Run the program. c. Create a macro variable named ParkCode to store YOSE, and another macro variable named SpeciesCat to store Mammal. Modify the code to reference the macro variables. Run the program and confirm that the same results are generated. Note: The macro variable values are case sensitive when they are used in a WHERE statement. Change the values of the macro variables to ZION (Zion National Park) and Bird. Run the program