You are given a table that lists out one row per month in which a member is actively enrolled in a commercial insurance plan in 2018 (excerpt shown below). Each member can contribute between 1 to 12 months in this table, and they can contribute any specific calendar months within the year Table 1. MemberID YearMo (member month) 100001 201801 100001 201802 100001 201803 100002 201801 100002 201802 100003 201807 100003 201808 100003 201809 100003 201810 …… …… a.Write code to output a new table from Table 1 that includes all of the observations for members with a member month in January 2018. Hint: YearMo is a character variable. b.Write code to output a new table from Table 1 that has one row per member and the count of each member’s member months. Include a depiction of what you would expect this table to look like based on the sample shown above. c.Write code to output a new table from Table 1 that has one row for each month in 2018 and counts the number of members who are active in that month. Include a depiction of what you would expect this table to look like based on the sample shown above. ... View more