topic Re: Assign variable names to a data set based on variable names of another data set in New SAS User

Assign variable names to a data set based on variable names of another data set

NewUsrStat — Mon, 18 Sep 2023 08:05:57 GMT

Hi guys,

suppose to have a data set1 with column names and another data set2 with other column names. The two data sets have the same number of columns. Is there a way to allow data set2 to take column names of data set1 (position-wise)?

Thank you in advance

Re: Assign variable names to a data set based on variable names of another data set

yabwon — Mon, 18 Sep 2023 08:12:24 GMT

If TYPEs match on positions and LENGHTs agr "long enough" in set1, then the SQL union can do the job:

data set1;
  A=1;
  B="xyz";
  C=42;
run;


data set2;
  X=11;
  Y="abc";
  Z=421;
  output;
  X=12;
  Y="abd";
  Z=422;
  output;
run;


proc sql;
create table WANT as
select * from set1(obs=0)
union all
select * from set2
;
quit;

proc print data=WANT;
run;

Bart

Re: Assign variable names to a data set based on variable names of another data set

andreas_lds — Mon, 18 Sep 2023 10:04:24 GMT

@NewUsrStat wrote:

Hi guys,

suppose to have a data set1 with column names and another data set2 with other column names. The two data sets have the same number of columns. Is there a way to allow data set2 to take column names of data set1 (position-wise)?

Thank you in advance

Can't you fix the creation of dataste2, so it uses the correct names instead of the wrong ones?

Re: Assign variable names to a data set based on variable names of another data set

NewUsrStat — Mon, 18 Sep 2023 12:13:40 GMT

Thank you very much! It works perfectly