Hi SAS Community, I can't figure out a way to dynamically rename columns of datasets because I ran into a couple of snags. I have 121 SAS tables that I need to combine into one, but each dataset may have columns out of order, incorrect naming conventions (LAST_NAME and Last Name), or data lines start on line 4. I included photos and attached an example of this in a text file, if that would be more helpful. I'm using SAS Studio for this Have Want 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;
... View more
