THANK YOU IN ADVANCE This is an extention of the problem posted a few days ago.   I need help to generate individual school reports from a master schools table (A) and append national averages. The addition requirement is data for each school, and the national averages, are reported over several years.   Thank you   Have I a master schools table (A) with annual, individual school records and national averages Year School ID Enrolments  %Females %LowSES %Black %Secondary_Education 2002 1                  200 50 12 15 59 2003 1                  111 100 80 80 100 2004 1                    80 0 15 26 25 2005 1                    20 100 25 3 59 2001 2                    80 40 34 5 90 2002 2                    55 50 34 64 64 2003 2                    45 46 56 76 86 2004 2                    25 56 78 42 38 2005 2                    20 20 29 78 98 2001 3                    80 60 55 18 56 2002 3                  266 50 65 20 50 2003 3                  300 100 48 45 50 2004 3                  800 0 67 67 50 2005 3              1,000 100 63 58 45 2001 All                  160 50 45 12 73 2002 All                  521 50 37 33 58 2003 All                  456 82 61 67 79 2004 All                  905 19 53 45 38 2005 All              1,040 73 39 46 67     I want three separate tables, one for each school: Year School ID Enrolments  %Females %LowSES %Black %Secondary_Education 2002 1                  200 50 12 15 59 2003 1                  111 100 80 80 100 2004 1                    80 0 15 26 25 2005 1                    20 100 25 3 59 2002 All                  521 50 37 33 58 2003 All                  456 82 61 67 79 2004 All                  905 19 53 45 38 2005 All              1,040 73 39 46 67                             Year School ID Enrolments  %Females %LowSES %Black %Secondary_Education 2001 2                    80 40 34 5 90 2002 2                    55 50 34 64 64 2003 2                    45 46 56 76 86 2004 2                    25 56 78 42 38 2005 2                    20 20 29 78 98 2001 All                  160 50 45 12 73 2002 All                  521 50 37 33 58 2003 All                  456 82 61 67 79 2004 All                  905 19 53 45 38 2005 All              1,040 73 39 46 67                             Year School ID Enrolments  %Females %LowSES %Black %Secondary_Education 2001 3                    80 60 55 18 56 2002 3                  266 50 65 20 50 2003 3                  300 100 48 45 50 2004 3                  800 0 67 67 50 2005 3              1,000 100 63 58 45 2001 All                  160 50 45 12 73 2002 All                  521 50 37 33 58 2003 All                  456 82 61 67 79 2004 All                  905 19 53 45 38 2005 All              1,040 73 39 46 67 ... View more

  THANK YOU in advance.   The task is to create a SAS / SQL program to: (a) sequentially read in school ids from the master schools table (A) to create a lookup list; (b) then use the list of school ids to create separate tables for each school, and append national average.      Have: master schools table (A) with individual school records and national averages, (i.e. All): School ID Enrolments  %Females %LowSES %Black %Secondary_Education 1 30 60 33 0 80 2 200 50 12 15 59 3 111 100 80 80 100 4 80 0 15 26 25 5 20 100 25 3 59 All 441 65 33 25 65   Want five separate tables, one for each school: School ID Enrolments %Females %LowSES %Black %Secondary_Education 1 30 60 33 0 80 All 441 65 33 25 65                         School ID Enrolments %Females %LowSES %Black %Secondary_Education 2 200 50 12 15 59 All 441 65 33 25 65                         School ID Enrolments %Females %LowSES %Black %Secondary_Education 3 111 100 80 80 100 All 441 65 33 25 65                         School ID Enrolments %Females %LowSES %Black %Secondary_Education 4 80 0 15 26 25 All 441 65 33 25 65                         School ID Enrolments %Females %LowSES %Black %Secondary_Education 5 20 100 25 3 59 All 441 65 33 25 65 ... View more

I have: National_Code National_Title Superseded_By_Code RVE20104 Diploma of Aeronotics AZC20210, AZC20110 TTE30803 Diploma of Aeronotics AZC30110, AZC32010   I want: National_Code National_Title Superseded_By_Code RVE20104 Diploma of Aeronotics AZC20210 RVE20104 Diploma of Aeronotics AZC20110 TTE30803 Diploma of Aeronotics AZC30110 TTE30803 Diploma of Aeronotics AZC32010   Can you please write me some code in SAS SQL or BASE SAS? Many thanks Gwin  ... View more