Question in SAS:

a Using the dataset yr.mon.wk, some area codes meet the sales target and some others does not. Define a macro variable for area code 3. For area code 3, check whether Sales Target meet or not. If SalesTarget meet then your footnote will contain Area code 3 meet target" Otherwise your footnote will contain "Some Area code 3 meet target. In your output list the following variables: Sale, Month, Year, Location, Equipments, Sales Target, Areacode. A 00 B c C Week 1 Sale 2 Day 101 10 3 101 26 O UN 4 99 19 3 3 5 103 23 6 96 13 4 3 7 113 18 8 8 90 17 9 123 & Co 10 85 16 11 4 31 6 12 108 103 84 105 0000 13 14 15 14 N 919612 00 01 min 16 102 104 81 103 89 17 D E F G H | J Month Year Location Equipmer Date1 SalesTarge Areacode 1 3 2001 LA MACBOOH NO 2 2 3 2001 LA SURFACE. ## YES 5 3 3 2001 DALLAS MACBOO! NO 6 3 3 2001 CHICAGO MACBOO ## NO 7 3 2001 CHICAGO NOTEBOO ## YES 4 4 3 2001 DALLAS SURFACE. ## NO 2 3 4 2001 BOSTON TABLET YES 6 4 4 2001 LA TABLET NO 8 2 6 2001 DALLAS TABLET YES 5 4 7 2001 BOSTON MACBOOK ## NO 8 1 8 2001 DALLAS TABLET 8/6/2001 YES 9 2 8 2001 LA NOTEBOO 8/9/2001 NO 6 8 2001 CHICAGO TABLET ######## NO 2 3 8 2001 CHICAGO SURFACE. ## YES 3 3 9 2001 LA TABLET YES 5 3 9 2001 BOSTON TABLET YES 3 11 2001 BOSTON NOTEBOO NO 1 12 2001 DALLAS SURFACE. NO 10 1 1 2002 DALLAS DESKTOP 1/8/2002 YES 2 3 3 2002 LA SURFACE.I 3/8/2002 YES 5 1 4 2002 BOSTON DESKTOP ### YES 1 4 2002 CHICAGO TABLET NO 3 4 2002 LA MACBOOH 4/2/2002 NO 2 3 5 2002 CHICAGO TABLET 5/2/2002 YES 3 3 6 2002 LA NOTEBOO 6/2/2002 NO 2 6 2002 BOSTON DESKTOP 6/2/2002 NO 1 7 2002 DALLAS NOTEBOO ######## YES 8 7 2002 BOSTON NOTEBOO ## NO 3 7 2002 LA DESKTOP 7/8/2002 NO 4 3 7 2002 BOSTON DESKTOP NO 1 1 8 2002 BOSTON MACBOOK ## NO 7 8 2002 LA TABLET YES 8 2 8 2002 CHICAGO NOTEBOO 8/5/2002 YES 1 9 2002 BOSTON DESKTOP 9/4/2002 NO 18 N U - 19 20 96 00 00 1 8 8 21 98 3 22 113 24 in m 23 112 15 24 118 2 2 N N 25 97 86 B 3 8 26 2 27 114 2 4 4 28 107 11 29 61 12 4 N 30 108 co 8 3 31 112 24 88 32 33 34 96 29 12 5 N 112 35 93 4 2 5 6 a Using the dataset yr.mon.wk, some area codes meet the sales target and some others does not. Define a macro variable for area code 3. For area code 3, check whether Sales Target meet or not. If SalesTarget meet then your footnote will contain Area code 3 meet target" Otherwise your footnote will contain "Some Area code 3 meet target. In your output list the following variables: Sale, Month, Year, Location, Equipments, Sales Target, Areacode. A 00 B c C Week 1 Sale 2 Day 101 10 3 101 26 O UN 4 99 19 3 3 5 103 23 6 96 13 4 3 7 113 18 8 8 90 17 9 123 & Co 10 85 16 11 4 31 6 12 108 103 84 105 0000 13 14 15 14 N 919612 00 01 min 16 102 104 81 103 89 17 D E F G H | J Month Year Location Equipmer Date1 SalesTarge Areacode 1 3 2001 LA MACBOOH NO 2 2 3 2001 LA SURFACE. ## YES 5 3 3 2001 DALLAS MACBOO! NO 6 3 3 2001 CHICAGO MACBOO ## NO 7 3 2001 CHICAGO NOTEBOO ## YES 4 4 3 2001 DALLAS SURFACE. ## NO 2 3 4 2001 BOSTON TABLET YES 6 4 4 2001 LA TABLET NO 8 2 6 2001 DALLAS TABLET YES 5 4 7 2001 BOSTON MACBOOK ## NO 8 1 8 2001 DALLAS TABLET 8/6/2001 YES 9 2 8 2001 LA NOTEBOO 8/9/2001 NO 6 8 2001 CHICAGO TABLET ######## NO 2 3 8 2001 CHICAGO SURFACE. ## YES 3 3 9 2001 LA TABLET YES 5 3 9 2001 BOSTON TABLET YES 3 11 2001 BOSTON NOTEBOO NO 1 12 2001 DALLAS SURFACE. NO 10 1 1 2002 DALLAS DESKTOP 1/8/2002 YES 2 3 3 2002 LA SURFACE.I 3/8/2002 YES 5 1 4 2002 BOSTON DESKTOP ### YES 1 4 2002 CHICAGO TABLET NO 3 4 2002 LA MACBOOH 4/2/2002 NO 2 3 5 2002 CHICAGO TABLET 5/2/2002 YES 3 3 6 2002 LA NOTEBOO 6/2/2002 NO 2 6 2002 BOSTON DESKTOP 6/2/2002 NO 1 7 2002 DALLAS NOTEBOO ######## YES 8 7 2002 BOSTON NOTEBOO ## NO 3 7 2002 LA DESKTOP 7/8/2002 NO 4 3 7 2002 BOSTON DESKTOP NO 1 1 8 2002 BOSTON MACBOOK ## NO 7 8 2002 LA TABLET YES 8 2 8 2002 CHICAGO NOTEBOO 8/5/2002 YES 1 9 2002 BOSTON DESKTOP 9/4/2002 NO 18 N U - 19 20 96 00 00 1 8 8 21 98 3 22 113 24 in m 23 112 15 24 118 2 2 N N 25 97 86 B 3 8 26 2 27 114 2 4 4 28 107 11 29 61 12 4 N 30 108 co 8 3 31 112 24 88 32 33 34 96 29 12 5 N 112 35 93 4 2 5 6