proc sql;
   create table have1
       (FIRST_NAME char(7),
        LAST_NAME char(7),
        Member_MBI char(7),
        Diagnosis char(7)
       );

insert into have1
    values('Kat', 'Brown', '1A1', 'Fair')
    values('Mike', 'Salder', 'ME3', 'Good')
    values('Roger', 'Blue', 'ME1', 'Bad');

title 'Have 1';

select *
   from have1;

proc printto; run;


proc sql;
   create table have2
       ('LAST NAME'n char(7),
       'First Name'n char(7),
       Diagnosis char(7)        
       );

insert into have2
    values('Grove', 'Cathy', 'Fair')
    values('Pot', 'Raine', 'Bad')
    values('Kelly', 'Cheyene', 'Good');

title 'Have 2';

select *
   from have2;

proc printto; run;



proc sql;
   create table have3
       (A char(27),
        B char(27),
        C char(27),
        D char(20)        
       );

insert into have3
    values('', '', '', 'Report Period: 09')
    values('', '', '', '')
    values('Member Last Name', 'Member First name', 'Diagnosis', 'Member MBI')
    values('Crab', 'Fish', 'Fair', '7C1')
    values('Blob', 'Cramer', 'Bad', 'PE3')
    values('Mark', 'Pencil', 'Good', 'GR9');

title 'Have 3';

select *
   from have3;

proc printto; run;

proc sql;
   create table want
       (LAST_NAME char(7),
       FIRST_NAME char(7),
       DIAGNOSIS char(7),
       MEMBER_MBI char(7)        
       );

insert into want
	values('Brown', 'Kat', 'Fair', '1A1')
    values('Mike', 'Salder', 'Good', 'ME3')
    values('Roger', 'Blue', 'Bad', 'ME1')
    values('Grove', 'Cathy', 'Fair', '')
    values('Pot', 'Raine', 'Bad', '')
    values('Kelly', 'Cheyene', 'Good', '')
    values('Crab', 'Fish', 'Fair', '7C1')
    values('Blob', 'Cramer', 'Bad', 'PE3')
    values('Mark', 'pencil', 'Good', 'GR9');

title 'Want';

select *
   from want;

proc printto; run;